On 6 Jun 2019, at 9:11am, Wout Mertens <wout.mert...@gmail.com> wrote:
> I'd like to create a database in WAL mode if it doesn't exist
Create it without the flag then execute
PRAGMA journal_mode=WAL
The PRAGMA is harmless if the database is already in WAL mode.
If you want to get fussy about it execute
PRAGMA journal_mode
once the database is open, and convert to WAL mode only if you get anything but
WAL back.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
