sqlite3.dart
sqlite3.dart copied to clipboard
Please support backup API
SQLite3 has backup APIs. https://sqlite.org/backup.html if possible, please support it.
and if possible, support backup for moor??
thx.
Can you use VACUUM INTO
to backup databases?
can but documentation says
The VACUUM INTO command is transactional in the sense that the generated output database is a consistent snapshot of the original database. However, if the VACUUM INTO command is interrupted by an unplanned shutdown or power lose, then the generated output database might be incomplete and corrupt. Also, SQLite does not invoke fsync() or FlushFileBuffers() on the generated database to ensure that it has reached non-volatile storage before completing
and
This means that when VACUUMing a database, as much as twice the size of the original database file is required in free disk space.
So I wanna use backup api if possible