transaction isolation
Transaction isolation defines how concurrent transactions may observe and affect one another.
Use this when A transaction is atomic but still violates a rule under concurrent access.
without the term
“We check that a doctor has at least one on-call shift before removing one, inside a transaction, but two removals at once still left nobody on call. How is that possible?”
with the term · How do you ask a model for transaction isolation?
Choose isolation for this invariant on our database. Test concurrent transactions and handle retryable failures with a bounded retry policy.
What is transaction isolation?
Isolation levels, such as read committed, repeatable read, and serializable, control what concurrent transactions see of each other. Stronger levels prevent more anomalies but can fail transactions that then need a full retry.
Why does transaction isolation matter when vibe coding?
Wrapping writes in a transaction does not automatically make every execution serializable.
How do you do transaction isolation?
Identify the required invariant, choose the isolation strategy, and test conflicting transactions.
What goes wrong with transaction isolation?
Retrying only the final statement after the database requires the whole transaction to restart.