News for hackers. Stuff that matters.

A comment on ToroDB – Document-oriented JSON database on top of PostgreSQL. Parent comment

Re:ToroDB – Document-oriented JSON database on top of Postgr... by jeffdavis on Wednesday October 29, 2014 @05:12PM (#8530002)
Can you briefly explain the advantage of tearing apart the JSON document, rather than just storing it as JSONB and using the various JSONB functions/operators/indexes?
[ Parent | on HN ]
Re:ToroDB – Document-oriented JSON database on top of Postgr... by jeremyjh on Wednesday October 29, 2014 @07:04PM (#8530486)
He did explain that - it can yield significant space savings where there is a common "type of document" because the field names do not need to be stored in each document instance, the way they would have to be in JSONB. Also, it means you can query these tables with normal Postgres query tools and they will actually make sense.
[ Parent | on HN ]