Skip to content

[Enhancement] Add DB migrations for SQLite #856

@moisesPompilio

Description

@moisesPompilio

Describe the enhancement
After PR #804 introduced SQLite into Floresta, the schema is currently created via static DDL. Replace that with a versioned migrations system so schema changes are applied incrementally and safely instead of requiring destructive changes / hardforks.

Use case

  • Evolve tables (add/remove columns) without breaking existing installations.
  • Automatically apply only pending migrations on startup or via a controlled migration step.
  • Make schema changes auditable and reversible.

Additional context
Recommend using refinery for migrations: https://docs.rs/refinery/latest/refinery/

Metadata

Metadata

Assignees

No one assigned

    Labels

    reliabilityRelated to runtime reliability, stability and production readiness

    Type

    Projects

    Status

    Done

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions