• v0.9.0 9a805ec316

    Release 0.9.0: Automatic Database Migration System

    phil released this 2025-11-20 00:09:01 +01:00

    Implements automatic database migrations for zero-touch deployments.

    Features:

    • Automatic migration execution on application startup
    • Fresh database detection (auto-skip migrations)
    • Legacy database detection (apply pending migrations)
    • Migration tracking table for audit trail
    • Comprehensive test coverage (26 tests, 100% pass rate)
    • Container-friendly automatic initialization

    Technical Details:

    • Fresh databases: Schema detected as current, migrations marked as applied
    • Legacy databases: Pending migrations applied automatically
    • Idempotent: Safe to run multiple times
    • Fail-safe: Application won't start if migrations fail

    Infrastructure:

    • Zero-touch container deployments
    • No manual SQL execution required
    • Clear migration history in database
    • Detailed logging for visibility

    See CHANGELOG.md for full details and ADR-020 for architecture decisions.

    Downloads