Re: [sqlite] switching from WAL to DELETE mode (Clemens Ladisch)

2016-08-09 Thread Simon Slavin
On 9 Aug 2016, at 1:58pm, Andrii Motsok wrote: > I don't want to bother clients of the first connection with reopening it > twice (DELETE->WAL before modification and WAL->DELETE after). That's not how SQLite works. The journal mode for a database is saved in the database file and new connec

Re: [sqlite] switching from WAL to DELETE mode (Clemens Ladisch)

2016-08-09 Thread Andrii Motsok
Hi, > What problem do you think you can solve with this? I have one readonly connection. Is being used for reading. From time to time I need to modify data using WAL approach. I don't want to bother clients of the first connection with reopening it twice (DELETE->WAL before modification and WA