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, you wrote: GI> Good evening Dr. Hipp, GI> ok, got it. Thank you for the quick clarification. GI> I only asked on the mailing list because I couldn't find this kind of GI> information in the docs (or I didn't look thoroughly enough); if it's the GI> first case, perhaps it should be mentioned somewhere... GI> Thanks again, GI> George. GI> On Thu, Aug 21, 2014 at 10:07 PM, Richard Hipp <d...@sqlite.org> wrote: >> On Thu, Aug 21, 2014 at 3:05 PM, George Ionescu <geoione...@gmail.com> >> 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 database file. If you change to WAL-mode, >> then *all* database connections must go to WAL-mode. >> >> -- >> D. Richard Hipp >> d...@sqlite.org >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> GI> _______________________________________________ GI> sqlite-users mailing list GI> sqlite-users@sqlite.org GI> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users