[antithesis-nl]

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]

> 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]

Hard to imagine doing it any other way, which is probably fine up until you hit some larger files sizes.

[ncruces]

That copies the entire file each time (not just deltas).

You may find sqlite_rsync better.