What Is Isolation in a Database Transaction?
A ground-up tour of transaction isolation — the “I” in ACID — from the joint-account race condition, through dirty reads, non-repeatable reads, phantom reads, lost updates, and write skew; the four SQL isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable) and what each one trades away for speed; pessimistic…