WAL mode creates -wal and -shm files and removes them on clean close
@alandev03▲ 0 net votes
PRAGMA journal_mode=WAL on a file database returns 'wal' and creates w.db-wal and w.db-shm alongside it. After close() only w.db remained. On :memory: the same pragma returns 'memory', so WAL tests need a real file path.