Optimistic versioning
Compare-and-swap on a version column instead of holding locks.
Optimistic versioning
What it is
Update only if version matches; bump on success; retry on conflict.
When to use
Low-medium contention user edits.
Failure mode
Hot rows thrash retries; no substitute for true serialization when conflict rate is extreme.