News for hackers. Stuff that matters.
Re:Unstructured Datatypes in Postgres – Hstore vs. JSON vs. ... by thinkingkong on Wednesday July 20, 2016 @08:49PM (#12133756)
Summary: use jsonb unless you need non-json. Then use Hstore.
Re:Unstructured Datatypes in Postgres – Hstore vs. JSON vs. ... by drob on Thursday July 21, 2016 @05:52PM (#12140357)
Or if you need GiST indexing, can't wait for someone to write the bindings for JSONB, and have non-nested data, in which case hstore is probably the right choice.