Maybe just me, but I'm not understanding the question very well. I know there's, e.g. a compile option of <code> SQLITE_DEFAULT_WAL_AUTOCHECKPOINT=<pages></code> that would have no effect unless at some point someone has invoked: <code> PRAGMA journal_mode = WAL;</code> Is that what you mean? Maybe you could elaborate on the problem that caused you to pose the question?