Database Transaction Isolation: 5 Concurrency Bugs and How to Fix Them
Dirty reads, lost updates and write skew: what each bug looks like, which isolation level stops it, and what PostgreSQL and MySQL really do.

Dirty reads, lost updates and write skew: what each bug looks like, which isolation level stops it, and what PostgreSQL and MySQL really do.

Current 2026 versions, an indexed-vs-unindexed benchmark I ran myself, and honest tradeoffs across fintech, content platforms, and AI apps.
