Hacker News new | ask | show | jobs
by winrid 916 days ago
Yeah, there is. PG has its own warts that Mongo does not have. Also the JSONB query language sucks. See appending an array in PG [0] vs Mongo [1]. Also PG does not provide a way to atomically append to the array, you have to lock the row via SELECT ... FOR UPDATE. Mongo's $push, $set, etc, are atomic.

[0] https://pastebin.com/v2MiV8PE

[1] https://pastebin.com/RmLuGzAY

1 comments

Okay, so use a server side language to do it.
that only solves half the problems I mentioned... :)