SQLite Forum

Empty journal files left on disk after connection was gracefully closed
Login
> Can I configure sqlite to delete empty journal files?

In theory, the WAL files should be automatically deleted when the backup DB connection is closed: <https://www.sqlite.org/wal.html#the_wal_file>

You can also switch that DB out of WAL mode: `PRAGMA journal_mode = delete;`

> Can I configure sqlite not to use shared-memory files?

Only when you have a single connection: <https://www.sqlite.org/wal.html#use_of_wal_without_shared_memory>

(SQLite does not differentiate between connections from multiple processes, and multiple connections from threads in a single process.)