Storage

SQLite WAL: where committed pages live

A write-ahead log changes where committed work lives. That small fact explains concurrency, checkpoints, and why a casual file copy can mislead.