---
answer: direct
beat: dev-practices
source: 1 article · updated: November 14, 2026
---

How does optimistic locking work with a version column?

Each row has a version. You read it, then write with a condition: update the row only where the id and version still match what you read, and increment the version. If zero rows were updated, someone else got there first, so you reload and retry or report a conflict.

Answered in

Pessimistic vs Optimistic Locking: Choosing by How Often Your Writes Collide

Lock first or check at commit? Version columns, SELECT FOR UPDATE, retry logic and the contention numbers that decide which strategy fits.

Crashtech Editorial November 14, 2026 Development Best Practices

Read the full analysis

Other questions this article answers

More development best practices questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the Development Best Practices beat.