How to make PRAGMA option to be permanent for sqlite3
PRAGMA temp_store affects only the current connection.
The only way to change this setting permanently would be to recompile SQLite with another value of the SQLITE_TEMP_STORE option.
PRAGMA temp_store affects only the current connection.
The only way to change this setting permanently would be to recompile SQLite with another value of the SQLITE_TEMP_STORE option.