I'm using VACUUM INTO, which does basically that: https://sqlite.org/lang_vacuum.html#vacuuminto https://sqlite.org/lang_vacuum.html#vacuuminto > The VACUUM c

I'm using VACUUM INTO, which does basically that: https://sqlite.org/lang_vacuum.html#vacuuminto https://sqlite.org/lang_vacuum.html#vacuuminto > The VACUUM command with an INTO clause is an alternative to the backup API for generating backup copies of a live database....The VACUUM INTO command is transactional in the sense that the generated output database is a consistent snapshot of the original database. EDIT: Litestream docs will also recommend that: https://github.com/benbjohnson/litestream.io/issues/56 https://github.com/benbjohnson/litestream.io/issues/56