ACID from first principles, all four isolation levels (READ UNCOMMITTED through SERIALIZABLE), dirty/non-repeatable/phantom read definitions with examples, row-level vs table-level locking, MVCC (how Postgres avoids most locks), optimistic vs pessimistic locking, and @Transactional propagation and isolation in Spring.
// Lessons
- 01soon
ACID — Atomicity, Consistency, Isolation, Durability from First Principles
- 02soon
Isolation Levels — READ UNCOMMITTED through SERIALIZABLE
- 03soon
Dirty, Non-Repeatable and Phantom Reads — With Real Examples
- 04soon
Locking — Row-Level vs Table-Level and Shared vs Exclusive
- 05soon
MVCC — How Postgres Avoids Most Read Locks
- 06soon
Optimistic vs Pessimistic Locking — Choosing the Right Strategy
- 07soon
Spring @Transactional — Propagation Levels Explained
- 08soon
Spring @Transactional Gotchas — Self-Invocation, Rollback Rules, Proxies