Nick wrote:
> On 11 Dec 2014, at 20:39, David King wrote:
>> Why are you trying to hard to avoid using the backup API? It sounds
>> like it does exactly what you want
>
> Backup API works great if you have periods of no writing.
> However, if a process writes during the backup then the API would stop
> and start over again. So if you have frequent writes then
> theoretically the backup API would not complete.

The ".backup" command of the sqlite3 command-line shell uses a step
size of 100 pages, i.e., gives other processes opportunities to write
regularly.

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.


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to