Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^5: key value in text format

by The_Dj (Sexton)
on Nov 11, 2019 at 02:56 UTC ( #11108533=note: print w/replies, xml ) Need Help??


in reply to Re^4: key value in text format
in thread 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)?

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]
      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]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://11108533]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (4)
As of 2023-05-30 20:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found
    Notices?