Database Backup System#

Overview#

Daily compressed backups of the SQLite database with manual controls in Settings > Diagnostic.

Configuration#

Backups are disabled by default. To enable:

1. Open Settings > Core
2. Set backupDir to your desired backup location (e.g., ~/sync/peek-backups)
3. Backups will run automatically on app startup (daily)

Behavior#

• Trigger: On app startup, if >24 hours since last backup
• Format: ZIP archive containing datastore.sqlite and manifest.json
• Filename: peek-backup-{profile}-{YYYY-MM-DD-HHmmss}.zip
• Retention: Keeps 7 most recent backups (configurable)
• Method: Uses SQLite's VACUUM INTO for consistent copies without locking

Architecture#

Files#

• backend/electron/backup.ts - Core backup logic
• app/config.js - backupDir preference in core settings schema
• app/diagnostic.html - Manual backup UI

IPC Handlers#

• backup-get-config - Get current backup configuration
• backup-set-config - Update backup settings (retentionCount, lastBackupTime)
• backup-create - Trigger manual backup
• backup-list - List existing backups

Settings Storage#

• backupDir is stored in core settings (extension_settings table, extensionId=core, key=prefs)
• lastBackupTime and retentionCount stored separately (extensionId=backup)

Manual Controls#

Available in Settings > Diagnostic > Backup Tools:

• Backup Now - Create immediate backup
• List Backups - Show existing backups with sizes and dates
• Open Backup Folder - Open backup directory in Finder

Archive Contents#

peek-backup-default-2026-01-19-143022.zip
├── datastore.sqlite     # VACUUM'd copy of database
└── manifest.json        # Metadata: version, timestamp, profile, table row counts