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

Reply via email to