On 8 May 2018, at 10:56am, R Smith <ryansmit...@gmail.com> wrote: > Thank you for clarifying - but it is still my understanding that the DB is > not locked (if only in WAL mode), so the backup API, even with -1, either > must ignore changes, or restart. My proposed flag is to lock rather than > restart or ignore.
You can lock the database yourself, using BEGIN EXCLUSIVE or BEGIN IMMEDIATE depending on which you want. Then do all the backup stuff, then COMMIT or ROLLBACK without having changed anything. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users