How to back up SQLite databases the right way (not by copying them!)

Overview

SQLite databases live on disk as a single file, so it's tempting to think you can make database backups just by copying the file. But this doesn't ensure the copy takes into account any current database activity. The better solution is to use SQLite's own internal backup API, which can make complete, point-in-time snapshots of a SQLite database without needing to close any programs using the data.

Register Now