Engineer Atlas
OverviewLearnInternalsModeling LabPlaygroundDatabase FinderRoadmapPracticeInterview
OverviewLearnInternalsModeling LabPlaygroundDatabase FinderRoadmapPracticeInterviewCheat SheetCompare
Database Engineering
  • Database Fundamentals
  • SQL
  • Relational Modeling
  • Normalization & Denormalization
  • Indexes
  • Query Execution & Optimization
  • Transactions
  • Concurrency & Isolation
  • PostgreSQL
  • Redis
  • NoSQL & Data Models
  • Vector Databases & Retrieval
  • Scaling
  • Distributed Databases
  • Caching
Database Internals
  • Overview
  • Build AtlasDB
  • Storage, Records & Pages
  • Index Internals
  • Buffer Management
  • WAL & Recovery
  • Transactions & MVCC Internals
  • LSM Trees
  • Query Engine
  • PostgreSQL & InnoDB Internals
  • Distributed Internals
  • Performance Internals
Database/Learn/Transactions
Database Engineering

Transactions

ACID as four separate guarantees, what a rollback really undoes, and why the write-ahead log exists.

See how this works internally:WAL & Recovery →Transactions & MVCC Internals →
Transactions and ACID
▶ interactive

A transaction makes several statements succeed or fail as one; ACID names the four separate guarantees that make that promise mean something, and the write-ahead log is how the database keeps it through a crash.

Engineer Atlas
GitHub·LinkedIn