3 ms·
I have used JSON types in Postrgres for a little while now, they're pretty great! I can't really see a downside, is there a disadvantage to this kind of setup?
by entee 11y ago
I have used JSON types in Postrgres for a little while now, they're pretty great! I can't really see a downside, is there a disadvantage to this kind of setup?
In our use case there were very clearly parts of the data that were relational and other parts that were better represented as unstructured. Postgres gave us the chance to do both in one place and worked really well for that purpose, good to see it getting even better.
- kapv89 11y agoRead somewhere that postgres cannot do in-place json updates. Like you cannot do field->>'val' = 1 in it without updating the whole json. Which becomes relevant event in moderately write heavy scenarios
- elsurudo 11y agoI think this is possible as of 9.5. See `jsonb_set` here: http://www.postgresql.org/docs/9.5/static/functions-json.html http://www.postgresql.org/docs/9.5/static/functions-json.htm... Not sure how it is implemented, though.
- lobster_johnson 11y ago9.5 adds a bunch of functions for modifying (setting, deleting) nested data.