One minor optional addition below....
On Sat, 20 Aug 2016 18:01:46 +0100, Simon Slavin
<slav...@bigfraud.org> wrote:
>
>On 20 Aug 2016, at 5:56pm, Lev <leventel...@gmail.com> wrote:
[...]
>> 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.
1a) If you need it, before creating any tables:
PRAGMA page_size=....;
> 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.
>
> Simon.
--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
