Furthermore, it seems like PRAGMA journal_mode = WAL; is the only one that’s persisted. All the other pragmas only apply to the current session, something I wish Sqlite’s documentation was more clear about. Putting them into your DB migration script will do nothing.