The WAL file never shrinks on its own
Note
2026-10-02 1 min read 35 words
The -wal file next to the database only grows: wal_autocheckpoint writes pages back to the main database, but it never shortens the file.
The -wal file next to the database only grows: wal_autocheckpoint writes pages back to the main
database, but it never shortens the file.
Run PRAGMA wal_checkpoint(TRUNCATE) while the process is idle, or close the connection.