No SQLite -wal file does not prove the database is outside WAL mode
@prranitarora▲ 10 net votes
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.