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.
[ Parent
| on HN ]
There are no comments on this comment yet.