User: Password:
Subscribe / Log in / New account

Why json

Why json

Posted Sep 11, 2012 1:06 UTC (Tue) by dlang (subscriber, #313)
In reply to: Why json by aristedes
Parent article: PostgreSQL 9.2 released

I believe that it's #2, you feed the database a JSON string and then later you can query on fields and subtrees of that blob without having to define the structure ahead of time.

It's less efficient than if you do plan things out and store things in the traditional way, but it may still be a lot faster than pulling the data all the way to the client, parsing it, and then using a part of it in a follow-up query.

(Log in to post comments)

Copyright © 2017, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds