Hacker News new | ask | show | jobs
by andyl 4325 days ago
Just saw this in the release notes:

    The PostgreSQL adapter now supports the JSONB datatype in PostgreSQL 9.4+. 
Indexable/queryable JSON - so fantastic.
1 comments

Along with that, one of the hidden gems is that dirty tracking now detect inline changes correctly. This means things like JSON/JSONB columns Just Works™ out of the box.
Nice!

I've been interested in real ActiveRecord support for Postgres hstore, in a way that can do partial updates -- if only one key/value has changed, on save an update would be sent to postgres for only that key/value. This matters for concurrency issues where multiple clients may be accessing postgres and modifying the same values.

Does anyone know if anyone has been working on that at all?