Core concepts
The building blocks. Explained clearly.

Core Mechanics: In plain terms, ACID ensures a group of database operations either finishes completely or leaves no visible trace (Atomicity), keeps enforced schema rules intact (Consistency), shields concurrent readers from partial work (Isolation), and survives process crashes once flushed to non-volatile storage (Durability).
Visual & Structural Flow: Covers the Write-Ahead Log (WAL) + Multi-Version Concurrency Control (MVCC) commit and recovery pipeline (SQL Client -> Buffer Pool + MVCC -> WAL fsync -> CLOG + Heap Pages), the Write Skew sequence under Snapshot Isolation (Tx 1 Dr. Alice & Tx 2 Dr. Bob), and the ACTIVE -> COMMITTED / ABORTED (40001) retry state machine.
Trade-Offs & Production: Choose READ COMMITTED for independent single-row updates, REPEATABLE READ for multi-query snapshot consistency, and SERIALIZABLE (or a shared guard-row lock followed by every writer) when invariants span multiple rows. Local WAL fsync protects against single-node power loss—not disk corruption or site-wide outages.
Failure Modes & Application: On serialization (40001) or deadlock (40P01) errors, roll back explicitly, apply jittered backoff, retry the entire transaction from BEGIN, and keep external HTTP or webhook calls outside the transaction.
A handbook for software systems
Complex systems. Clear thinking.
Learn how engineering systems work, where they fail, and how to make sound design decisions.

Find your starting point
The building blocks. Explained clearly.
Real requirements. Concrete designs.
Patterns in the context that matters.
How to structure, reason, and prepare.
ACID groups four guarantees for a database transaction: Atomicity (all-or-nothing), Consistency (enforced rules stay valid), Isolation (concurrent work does not expose partial state), and Durability (committed changes survive a crash under configured disk-flush settings).
Learn by doing
Connect services, data, and scale.
Turn requirements into clean abstractions.
Make the logic work, then make it efficient.