Re: [sqlite] Preserve file descriptors for journal files

Hi, On Sun, 7 Jul 2019 05:38:30 -0400 > Have you tried > > PRAGMA journal_mode=WAL; > > Does your application have exclusive access to the database file? If > so, then consider: > > PRAGMA locking_mode=EXCLUSIVE; both options seem to work although the second one is not an option for

[sqlite] Preserve file descriptors for journal files

Hi, we currently switched from a simple file back-end to SQLite in our application (no threads, single process) and use the following settings: sqlite3_config(SQLITE_CONFIG_SINGLETHREAD) sqlite3_enable_shared_cache(0) PRAGMA synchronous = OFF PRAGMA journal_mode = TRUNCATE It is quite common