Skip to main content

One doc tagged with "write-skew"

View all tags

Database Isolation Levels — How to Get It Right

Deep-dive into all 5 isolation anomalies (dirty read, non-repeatable, phantom, lost update, write skew), the 4 standard isolation levels, PostgreSQL vs MySQL vs Oracle implementation differences, snapshot scope (per-statement vs per-transaction), practical fix strategies without raising isolation, and the spec vs implementation distinction.