Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^6: key value in text format

by choroba (Cardinal)
on Nov 11, 2019 at 16:25 UTC ( #11108559=note: print w/replies, xml ) Need Help??


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

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]

Replies are listed 'Best First'.
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". ;-)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2023-09-27 08:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?