On 2/27/19, Daniel Polski <dan...@agelektronik.se> wrote: > > Is there some way to take a snapshot of a database regardless if there > comes new writes / transactions while doing the backup, and just write a > copy of that snapshot as it was into a new database file?
I assume you are using WAL mode? If not, you should be. Just making that one change might solve your problem. In WAL mode, run the entire backup inside a transaction. Or use the new VACUUM INTO feature to make your backup. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users