I'm using SQLite dll 3.36.0 downloaded from sqlite.org on Windows 10 and I'm having trouble with journal file. My goal is to disable completely journal file on disk so I'm using the following pragmas at runtime: PRAGMA synchronous=OFF PRAGMA count_changes=OFF PRAGMA journal_mode=OFF PRAGMA temp_store=MEMORY A query about current journal mode with "pragma journal_mode" returns "off" but on data insert or replace a "db-journal" file is always created on disk. Maybe I'm missing something? Thanks in advance for any suggestion.