That doesn't answer the question that was posed, though. The WAL documentation does however state: > The WAL journal mode will be set on all connections to the same database file if it is set on any one connection. Presumably this is done by incrementing the schema version, or via some similar marker in the database header that SQLite checks before preparing a statement.