Databases
Understanding and Avoiding Database Deadlocks
Why deadlocks happen even in well-designed schemas, how to read a deadlock log, and the lock-ordering habits that prevent them.
3 min read
Tag
Transactions
4 articles
Spring Boot
Understanding @Transactional: Propagation, Rollback Rules, and the Proxy Behind It
A practical look at how Spring's @Transactional works through dynamic proxies, why self-invocation silently breaks it, and how propagation settings actually behave.
3 min read
Databases
MVCC: How Postgres Handles Concurrency Without Locking Everything
How Postgres lets readers and writers proceed without blocking each other, what a snapshot actually is, and where MVCC's costs show up later.
3 min read
Databases
Transaction Isolation Levels and the Anomalies They Allow
A tour of READ UNCOMMITTED through SERIALIZABLE, the dirty reads and phantom rows each level permits, and how to pick one without guessing.
3 min read