ACID
A set of database transaction properties: Atomicity, Consistency, Isolation, Durability. Guarantees reliable processing of database transactions.
Atomicity — All or Nothing
Deep dive into atomicity: WAL internals, two-phase commit, bank transfer challenges, and Socratic LLM prompts for self-study.
Consistency & Isolation Levels
MVCC architecture, four isolation levels, read phenomena, optimistic vs pessimistic locking, and a booking system race condition challenge.
Durability & Production Patterns
WAL deep dive, fsync mechanics, synchronous_commit tuning, continuous archiving, and point-in-time recovery practice.
Review & Mastery Quiz
5 multiple-choice questions, 3 scenario analyses, and 3 open-ended design questions to consolidate all four ACID properties.
Free Books & Guides
Official Documentation
Video Courses
ACID — Explained (YouTube)
A video explanation of the ACID principle with practical examples.
freeCodeCamp — Software Architecture Course
A comprehensive course covering software architecture principles, patterns, and best practices.
ByteByteGo — Distributed Systems
High-quality animated explanations of system design principles, distributed systems, and architecture patterns.