Intermittent Data Incompleteness Issue When Copying SQLite Database File for Backup

[lumingyuan]

I have encountered an issue where, when backing up data by simply copying the SQLite database file, there is a very small probability of incomplete data on some devices. Even after closing and reopening the app, the issue persists. However, upon reinstalling the app and calling database.close() before copying the database file for backup, the problem seems to be resolved. I am unsure whether this is due to the reinstallation process or the database closure.

Could anyone shed light on the possible reasons behind this? How can I reliably copy the entire dataset for backup purposes?

Thank you for your assistance!

[JamesMcIntosh]

Are you flushing the writes? i.e.

final File dbFile = File("my.db");
dbFile.writeAsBytesSync(
    data.buffer.asUint8List(data.offsetInBytes, data.lengthInBytes),
    flush: true,
);