4 ms·
Yeah. SQLite's backup API is the right way to do this: https://sqlite.org/backup.html https://sqlite.org/backup.html
by edbaskerville 4y ago
Yeah. SQLite's backup API is the right way to do this:
https://sqlite.org/backup.html https://sqlite.org/backup.html
- ElectricalUnion 4y agoAnd, if you can't use the backup API for some reason, try VACUUM INTO: https://www.sqlite.org/lang_vacuum.html#vacuum_with_an_into_clause https://www.sqlite.org/lang_vacuum.html#vacuum_with_an_into_...
- mwcampbell 4y agoWould creating a ZFS snapshot, then either copying from that snapshot or sending it to another machine with zfs send, also be reliable? IIUC, ZFS snapshots are point-in-time consistent.