SQLite Write-Ahead Logging
The default method by which SQLite implements atomic commit and rollback is a rollback journal. Beginning with version 3.7.0 (2010-07-21), a new "Write-Ahead Log" option (hereafter referred to as "WAL") is available.
Write-Ahead Logging Small. Fast. Reliable. Choose any three. Home Menu About Documentation Download License Support Purchase Search About Documentation Download Support Purchase Search Documentation Search Changelog Write-Ahead Logging Table Of Contents 1. Overview 2. How WAL Works 2.1. Checkpointing 2.2. Concurrency 2.3. Performance Considerations 3. Activating And Configuring WAL Mode 3.1. Automatic Checkpoint 3.2. Application-Initiated Checkpoints 3.3. Persistence of WAL mode 4. The WAL File 5. Read-Only Databases 6. Avoiding Excessively Large WAL Files 7. Implementation Of Shared-Memory Fo
saved by
related reading
- How To Corrupt An SQLite Database Filesqlite.org
- 28.3. Write-Ahead Logging (WAL)postgresql.org
- 28.5. WAL Configurationpostgresql.org
- Build Your Own Databasenan.fyi
- Postgres WAL Files and Sequence Numbers | Crunchy Data Blogcrunchydata.com
- Exploring versions of the Postgres logical replication protocolblog.peerdb.io
- How we tracked down a 16-year-old SQLite bugtailscale.com
- Patching the PostgreSQL JDBC Driverengineering.zalando.com
- DBMS Musings: It’s Time to Move on from Two Phase Commitdbmsmusings.blogspot.com
- What is the "-journal" SQLite database? - Stack Overflowstackoverflow.com
- Wesley Aptekar-Cassels | Consider SQLiteblog.wesleyac.com
- Durability & Consistency - ZeroFS Documentationzerofs.net