Automated database backups #15
Description
Problem
Single SQLite file on a single droplet. No automated backup. One disk failure or bad migration = total data loss for all users. Only backup mechanism is manual `/api/admin/db/download`.
Solution
- Daily automated backup of the SQLite DB (or Postgres after migration)
- Upload to DigitalOcean Spaces or S3
- Retain last 30 days of backups
- Alert if backup fails
Acceptance Criteria
- Daily automated backup running
- Backups stored off-server
- Retention policy (30 days)
- Alert on backup failure