Re:Making Database Systems Usable
by ekimekim on Wednesday August 21, 2024 @12:48AM
(#41306875)
This is changing. Postgres (as you noted) supports JSON, and it also has excellent native support for arrays, range types, and composite types. For example:
[ Parent
| on HN ]
Re:Making Database Systems Usable
by globular-toast on Wednesday August 21, 2024 @05:49AM
(#41308551)
You need to be aware of the tradeoffs, though. For example, adding an alias in your example could easily result in a lost update: if two users add an alias at the same time the second write will overwrite the first. You can go up an isolation level or check it in your application (do an `UPDATE ... WHERE` then check it went through), of course, but with relational tables you get this for free without any worry or performance impact.