5 ms·
Using the SQLite backup API, which pretty much corresponds to the .backup CLI command. It doesn't block any reads or writes, so the performance impact is minima
by antithesis-nl 2y ago
Using the SQLite backup API, which pretty much corresponds to the .backup CLI command. It doesn't block any reads or writes, so the performance impact is minimal, even if you do it directly to slow-ish storage.
- hu3 2y ago> It doesn't block any reads or writes. That's neat! I bet it keeps growing a WAL file while the backup is ongoing right?
- rco8786 2y agoHard to imagine doing it any other way, which is probably fine up until you hit some larger files sizes.
- ncruces 2y agoThat copies the entire file each time (not just deltas). You may find sqlite_rsync better.