Backup

2 articles

Database 09 Sep 2026 9 min read

Back Up a Live SQLite Database Safely with Python

Copying an SQLite file looks like an obvious backup strategy: find the .db file and copy it somewhere safe. That can be acceptable when the database is definitely idle, but it is the wrong abstraction for a database that may be changing while the copy runs. SQLite provides an Online Backup API specifically for this problem. Python exposes it as sqlite3.Connection.backup(), so an application can copy a live database into another SQLite database while preserving a consistent database snapshot.

SQLite Python

Tech Updated 15 Sep 2026 8 min read

Cloud Sync vs Backup: Different Jobs, Different Recovery

Saving files in a cloud-synced folder can feel like having a backup. Your documents appear on several devices, changes reach the cloud automatically, and a replacement computer may be able to download them again. But sync and backup solve different problems. Sync is mainly designed to keep a set of files consistent across locations. Backup is designed to preserve recoverable copies when the working data is lost, damaged, or changed in a way you did not intend.

Cloud Storage Files