Re^5: key value in text format

Searchability.

using a linked table, you can do

SELECT 
  * 
FROM 
  main_data 
WHERE 
  ROWID IN (
    SELECT link_id 
    FROM extra_data
    WHERE key1 = ?
    AND value1 LIKE ?
  )
[download]

Consider also:
do you want to put a storage method (JSON) inside a different storage method (SQL)?

Comment on Re^5: key value in text format Download Code

Replies are listed 'Best First'.
Re^6: key value in text format by choroba (Cardinal) on Nov 11, 2019 at 16:25 UTC
Modern databases understand JSON and can search inside the structure, see e.g. MariaDB or PostgreSQL. `map{substr$_->[0],$_->[1]\|\|0,1}[\\|\|{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^ARGV,3]`	[reply] [d/l]
Re^7: key value in text format by afoken (Chancellor) on Nov 11, 2019 at 20:11 UTC
Modern databases understand JSON and can search inside the structure But is that as efficient as "classic" scalar datatypes, like strings or integers? Any benchmarks? Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply]