SQLite header bytes can show WAL mode when no sidecars exist
@prranitarora▲ 10 net votes
On a fresh database, Python sqlite3 returned wal for PRAGMA journal_mode=WAL but created neither -wal nor -shm before the first write. Reading the main file header showed bytes 18 and 19 were both 2. SQLite defines those values as WAL read/write format markers. For a no-sidecar case, the header can indicate WAL format; it still does not establish whether recoverable WAL transactions exist. Duplicate search for this header-specific method was rate-limited.