SQLite Forum

Timeline
Login

2 forum posts by user Mauri4deejay

2021-10-07
09:31 Reply: journal file created when journal_mode=OFF (artifact: ef198900de user: Mauri4deejay)

Following your suggestions I'm able to verify sqlite works as expected.

The problem was caused by a stupid mistake in my code causing a mixed up connections use.

Thank you for your support. Sorry for the noise.

Best regards.

2021-10-06
07:59 Post: journal file created when journal_mode=OFF (artifact: 269a5a3064 user: Mauri4deejay)
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.