Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re^4: key value in text format

by pwagyi (Monk)
on Nov 07, 2019 at 02:05 UTC ( #11108414=note: print w/replies, xml ) Need Help??

in reply to Re^3: key value in text format
in thread key value in text format

The link method to handle key/value pair is a good idea. but I think I might just go with JSON (column) for all key/value pairs. What is the trade-off between the two approaches?

Replies are listed 'Best First'.
Re^5: key value in text format
by The_Dj (Sexton) on Nov 11, 2019 at 02:56 UTC

    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 ? )

    Consider also:
    do you want to put a storage method (JSON) inside a different storage method (SQL)?
      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]
        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?


        Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11108414]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2023-09-30 13:48 GMT
Find Nodes?
    Voting Booth?

    No recent polls found