SQLite Forum

journal file created when journal_mode=OFF
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.