We've got an entity which does have a column that stores JSON - this column needs to be updated atomically (eg, Read-Modify-Write).
Does anyone have an idea on how to (elegantly) achieve this without
Does anyone have an idea on how to (elegantly) achieve this without
- Resorting to raw queries (SELECT FOR UPDATE)
- Using manual locking (yuck!)
- Using an intermediate table for serialization
- Relying on DB layer JSON support