Re: [sqlite] Mixing journal modes from different threads

Hello George, I use different journal modes within the same application to different database files. My files don't all have the same protection level. Some files I turn it off completely for better speed. Others, I can't afford to lose the data. C Thursday, August 21, 2014, 3:17:05 PM,

Re: [sqlite] Mixing journal modes from different threads

On 21 Aug 2014, at 8:17pm, George Ionescu wrote: > I only asked on the mailing list because I couldn't find this kind of > information in the docs (or I didn't look thoroughly enough); if it's the > first case, perhaps it should be mentioned somewhere...

Re: [sqlite] Mixing journal modes from different threads

Good evening Dr. Hipp, ok, got it. Thank you for the quick clarification. I only asked on the mailing list because I couldn't find this kind of information in the docs (or I didn't look thoroughly enough); if it's the first case, perhaps it should be mentioned somewhere... Thanks again, George.

Re: [sqlite] Mixing journal modes from different threads

On Thu, Aug 21, 2014 at 3:05 PM, George Ionescu wrote: > Hello dear sqlite users, > > is it ok to mix journal modes from different threads accessing the same > database? > SQLite does not allow you to mix WAL mode with other journal modes. Wal-mode is a property of the

[sqlite] Mixing journal modes from different threads

Hello dear sqlite users, is it ok to mix journal modes from different threads accessing the same database? The typical scenario is that I use one thread for reading using normal (default) journalling (e.g. only SELECT queries are performed) and two to four threads for writing using WAL