undefined | Better HN

0 pointswinrid2y ago0 comments

Sometimes this is the case but not always... It's nice to just work with objects in some languages... for some projects. That's engineering - picking trade offs :)

0 comments

cpursley2y ago

Except you can have objects in Postgres via jsonb; there's no trade off and you're both future and vendor proofed.

winridOP2y 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

cpursley2y ago

Okay, so use a server side language to do it.

1 more reply

j / k navigate · click thread line to collapse

0 pointswinrid2y ago0 comments

Sometimes this is the case but not always... It's nice to just work with objects in some languages... for some projects. That's engineering - picking trade offs :)

0 comments

cpursley2y ago

Except you can have objects in Postgres via jsonb; there's no trade off and you're both future and vendor proofed.

winridOP2y ago

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

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

cpursley2y ago

Okay, so use a server side language to do it.

1 more reply

j / k navigate · click thread line to collapse