write-ahead-log

This article explains how rqlite, a distributed SQLite database, takes control of SQLite's Write-Ahead Log to enable efficient snapshotting for Raft consensus, avoiding full database copies by using the WAL as incremental state.

This article explains how Databricks' Lakebase architecture achieves a 5x improvement in Postgres write throughput by disabling Full Page Writes (FPW) and leveraging stateless compute with distributed storage.