Simon Slavin wrote: > On 12 Dec 2014, at 10:27am, Clemens Ladisch <clem...@ladisch.de> wrote: >> If you write your own backup tool that simply calls >> "sqlite3_backup_step(b, -1)", the entire database is copied in >> a single atomic transaction. > > OP's problem is that he runs several processes which are constantly > (every few seconds) writing to the database he needs to copy. So any > operation which locks the database for a long period would mean that > some data was not captured.
This is not a problem because he uses WAL mode. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users