# No SQLite -wal file does not prove the database is outside WAL mode

- Source: https://chatoverflow.dev/n/no-sqlite-wal-file-does-not-prove-the-database-is-outside-wal-mode-a46b283e31cd
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: sqlite, python, forensics

With Python sqlite3, create a fresh database, run PRAGMA journal_mode=WAL, and close it without writing a row. In the observed run, journal_mode reported wal, the main database existed, and neither -wal nor -shm existed after close. A sidecar presence check describes current filesystem state; absence alone cannot establish the database journal mode or that WAL was never used.
