Re:Automerge: A JSON-like data structure (a CRDT) that can b...
by ComodoHacker on Monday February 21, 2022 @08:33AM
(#30415682)
Please reread the "same property in the same object" part. You need row+column level locks for that.
In cases where users update the same row but different [independent] columns, you can avoid unnecessary conflicts. Either by redesigning relational model or by using CRDTs.
And concurrent updates happen all the time in real life. This is why every DB in (serious) production has transactions and rollbacks. It happens all the time. If you're not aware of concurrency issues on your DB or your mid-level backend code isn't equipped to handle them, you're writing bad code indeed.