News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.