3 ms·
Nobody has mentioned jsonb partial updates yet. This is huge and goes further in superseding MongoDB use cases. Previously you would have add your own locking m
by bkeroack 11y ago
Nobody has mentioned jsonb partial updates yet. This is huge and goes further in superseding MongoDB use cases. Previously you would have add your own locking mechanisms (or use SELECT ... FOR UPDATE) so read/modify/update could be performed atomically. Now it will be built in.
- jrochkind1 11y agoYou already could do that with postgres hstore, I think, but postgres hstore is limited to a flat list of key/values, not nested data structures like json. I've been wishing for a while though that Rails ActiveRecord would support the atomic partial update operations inside hstore that postgres already does. (http://www.postgresql.org/docs/9.0/static/hstore.html http://www.postgresql.org/docs/9.0/static/hstore.html)