LastBackup v0.2.0 - Scheduled Backups & SQLite Support

Release Date: February 2, 2026

🎉 Overview

LastBackup v0.2.0 delivers the most requested features: scheduled backups with cron-based automation and SQLite database support. This release also introduces official storage integration, making it easier than ever to get started with automated backups.

Key Highlights:

• 🚧 Scheduled backups with cron expressions (UI ready, scheduler pending)
• ✅ SQLite database backup support
• ✅ Official storage integration (BYOS simplified)
• 🚧 Retention policies (count-based and time-based, cleanup pending)
• ✅ Timezone-aware scheduling
• ✅ Revamped pricing plans for backup SaaS
• ✅ Improved backup creation UX with modal refactoring

🚀 Major Features

⏰ Scheduled Backups (UI Ready, Scheduler Pending)

Note: The schedule configuration UI is complete, but the background scheduler service that executes scheduled backups is not yet implemented. Schedules can be created and managed, but will not auto-execute until v0.3.0.

Automate your backup workflow with flexible cron-based scheduling:

• Preset Schedules: Hourly, Daily (2 AM), Weekly (Sunday), Monthly (1st day)
• Custom Cron: Full cron expression support for advanced users
• Timezone Support: Schedule in your local timezone (UTC, Asia/Shanghai, America/New_York, etc.)
• Real-time Preview: See next execution time before saving
• Enable/Disable Toggle: Pause schedules without deleting them

Retention Policies:

• Count-based: Keep last N backups (e.g., retain 7 most recent)
• Time-based: Keep backups within N days (e.g., retain 30 days)
• Combined: Use both policies for maximum flexibility

🗄️ SQLite Backup Support

Full SQLite database backup support is now available:

• Safe Online Backups: Uses SQLite's .backup command for consistent backups
• WAL Mode Compatible: Works with Write-Ahead Logging enabled databases
• Docker Ready: sqlite3 CLI included in production containers
• File-based Configuration: Simple path-based database setup

📦 Official Storage Integration

Simplified storage setup with official storage support:

• One-Click Setup: Use storageId: "official" to auto-configure storage
• BYOS Friendly: Still supports custom S3/R2/MinIO configurations
• Auto-Creation: Storage records created automatically from OFFICIAL_STORAGE_URL
• Space Isolation: Each workspace gets its own storage record
• Connection Testing: Test official storage before creating backups

💰 Updated Pricing Plans

New pricing structure optimized for backup SaaS:

• Overage: $0.045/GB/month
• Annual billing: 17% discount
• Plus+ plans support custom storage (S3/R2/GCS/MinIO)

🔧 Technical Improvements

Database Schema Updates

• Added backup_schedules table with cron, timezone, and retention fields
• Added is_scheduled flag to backups table
• Added is_official flag to storages table
• Fixed migration ordering for backup_runs table
• Consolidated databases table schema

API Enhancements

New Endpoints:

• backupSchedules.list - List schedules with filters
• backupSchedules.get - Get schedule by ID
• backupSchedules.create - Create new schedule
• backupSchedules.update - Update schedule (recalculates nextRunAt)
• backupSchedules.toggle - Enable/disable schedule
• backupSchedules.delete - Remove schedule

Updated Endpoints:

• backup.create - Now supports storageId: "official" and inline storageConfig
• storages.list - Added with_official and isOfficial filter parameters
• storages.testConnection - Supports testing official storage

UI/UX Improvements

• CreateBackupModal Refactoring: Reduced ~236 lines of duplicate code
• ScheduleConfigSection: New component for schedule configuration
• Collapsible Schedule UI: Clean interface that expands when needed
• Real-time Cron Description: Instant feedback on schedule timing
• About Page Update: Reflects actual product positioning

🧪 Testing

Test Coverage

• All existing tests pass
• New schedule CRUD operations tested
• SQLite backup functionality verified
• Official storage integration tested
• TypeScript strict mode compliance maintained

🐛 Bug Fixes

• Fixed database schema migration issues for new columns
• Fixed migration ordering conflicts
• Fixed database list query compatibility
• Added graceful fallback for missing tables

🌍 Internationalization

All new features fully translated:

• Schedule configuration labels and descriptions
• Cron preset names
• Retention policy labels
• Error messages and validation hints

🐛 Known Issues

1. Scheduler Service: Background job processor not yet implemented (schedules are stored but not auto-executed)
2. Retention Cleanup: Automatic cleanup of old backups pending implementation
3. MongoDB: Connection testing still not implemented
4. Restore: Database restore functionality coming in v0.3.0

🎯 What's Next (v0.3.0)

Scheduled for Week of Feb 3-9, 2026

🔄 One-Click Restore

• Restore from any backup with one click
• Target database selection
• Progress tracking with real-time status
• Automatic rollback on failure

⚙️ Scheduler Service

• Background job processor for scheduled backups
• Automatic execution when nextRunAt <= current time
• Retry logic for failed backups
• Email notifications on success/failure

🧹 Retention Cleanup

• Automatic deletion of backups exceeding retentionCount
• Time-based cleanup for retentionDays policy
• Storage space reclamation

🧪 Sandock Sandbox Mode

• Privacy-first isolated backup execution
• Zero data exposure testing
• Safe configuration validation

Target Release: v0.3.0 - February 9, 2026