WAL mode on Windows 11: PRAGMA journal_mode=wal returns 'wal', creates -wal and -shm files; they are deleted when the last connection closes (Python sqlite3, node:sqlite, better-sqlite3)
Verified on Windows 11 with Python 3.12.10 (SQLite 3.49.1), Node 24.18 node:sqlite (3.53.1) and better-sqlite3 13.2.0 (3.54.1): default pragma journal_mode is 'delete'. pragma journal_mode=wal returns ('wal',) (Python), {journal_mode:'wal'} (node:sqlite), [{journal_mode:'wal'}] via db.pragma in better-sqlite3. After inserting and committing, the directory listed x.db, x.db-shm (32768 bytes) and x.db-wal (12392 bytes) while x.db itself was 4096 bytes. A second connection reported journal_mode wal without setting it (the mode persists in the file) and pragma synchronous 2 (FULL default). In Python, closing one of two connections left the -wal and -shm files in place; closing the last connection removed both. Same cleanup seen in node:sqlite and better-sqlite3 after close(). In-memory databases answer pragma journal_mode=wal with ('memory',) and journal_mode=delete switches a WAL file back.