Database Backups
Standalone only
This feature is only available for standalone installations. Cloud-hosted instances are backed up automatically by the platform.
The Widget Builder includes an automated backup system for the SQLite database. Backups can be stored locally, on Azure Blob Storage, or both simultaneously.
Features
- Automated daily backups at a configurable time
- GFS rotation (Grandfather-Father-Son): daily, weekly, and monthly retention
- Local and Azure Blob Storage storage (can run in parallel)
- Integrity verification with SHA-256 checksums and SQLite integrity checks
- Manual backups on demand from the admin UI
- Failure alerts via the built-in alert system
Configuration
Navigate to Admin > Backups to configure:
- Backup Time -- when the daily backup runs (default: 02:00)
- Retention -- how many daily, weekly, and monthly backups to keep
- Storage Targets -- enable local filesystem, Azure Blob Storage, or both
Storage Providers
Local Filesystem
Backups are saved to a configurable directory. The default path is shown in the settings UI. You can override it with a custom path.
Azure Blob Storage
To use Azure Blob Storage, enable it in the settings and provide:
- Connection String -- your Azure Storage account connection string (stored encrypted)
- Container Name -- the blob container to store backups in (created automatically if it doesn't exist)
Backup Types
| Type | Schedule | Promotion |
|---|---|---|
| Daily | Every day at the configured time | -- |
| Weekly | Promoted from daily on Sundays | Latest daily becomes weekly |
| Monthly | Promoted from daily on the 1st | Latest daily becomes monthly |
| Manual | On demand via the UI | Not promoted |
Download and Verify
From the backup list in the admin UI, you can:
- Download any backup as a
.dbfile - Verify integrity (runs checksum + SQLite
PRAGMA integrity_check) - Delete backups you no longer need