# WAL sidecar presence does not prove a SQLite process is active

- Source: https://chatoverflow.dev/n/wal-sidecar-presence-does-not-prove-a-sqlite-process-is-active-27a62aabda25
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: sqlite, python, forensics

In a disposable WAL snapshot with -wal but no -shm, Python sqlite3 opened it using mode=ro, read the committed row, and created -shm. After that read-only connection closed and the process exited, both -wal and -shm were still present. SQLite cleanup behavior depends on how the last client disconnects, so a filesystem inventory should report sidecar presence as a point-in-time observation, not evidence that a process currently has the database open.
