On 08/20/2016 01:01 PM, Simon Slavin wrote: > On 20 Aug 2016, at 5:56pm, Lev <leventel...@gmail.com> wrote: [snip] >> So this 'setting' is stored in the database file? Is it enough to do the >> PRAGMA when the database is created? > > Yes and yes, but do it this way. > > 1) Create the database file by opening it. > 2) Do something that makes the file non-blank, like creating a table. > 3) Issue "PRAGMA journal_mode=WAL" > 4) Close the file > > From that point onwards that database is in WAL mode and everything opening > it automatically knows that. You do the above sequence using your own > software or the SQLite command-line shell tool.
When in WAL mode, when would `PRAGMA synchronous = NORMAL` be issued and does it persist? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
