News for hackers. Stuff that matters.
Re:Unstructured Datatypes in Postgres – Hstore vs. JSON vs. ... by cobbzilla on Thursday July 21, 2016 @01:42AM (#12134984)
my admittedly anecdotal experiences working with JSONB in Postgres: coding is generally easy and performance is great, it even plays nice with ORMs like hibernate (with just a bit more work). the downside is the query syntax: for complex queries where you need to search within the JSON, it's hard to write correct SQL. it's a trial-and-error process and the error messages aren't that great. once you get it working you're fine, but it can be hard to get there sometimes.

There are no comments on this comment yet.