Guides ยท Engineering
SQLite Backup Basics
Backup SQLite databases safely
This guide explains safe SQLite backups: using the online backup API, copying databases with proper locking, and verifying backup integrity with pragma checks.
- sqlite
- backup
- database
- locks
- integrity
Use online backup
Prefer the SQLite online backup API to copy while live.
Lock before copying
If file copying, ensure no writes (use WAL checkpoint and locks).
Store securely
Encrypt backups if they contain sensitive data; store off-host copies.
Verify integrity
Run PRAGMA integrity_check on backups periodically.
Keep Exploring
Guides
Intro to CAD Modeling
Learn the core CAD workflow for turning simple sketches into precise, editable 3D parts.
How it works
Air Traffic Control
Air traffic control coordinates aircraft movements to maintain safe separation.
Comparison
Hydrogen Car vs EV
Hydrogen cars make electricity from fuel onboard, while EVs store electricity directly in batteries.
Examples
Lever Simple Machine
A lever multiplies force by pivoting around a fulcrum, trading distance for mechanical advantage.