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

    WalletChanges related to the watch-only walletcode qualityGenerally improves code readability and maintainabilityenhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions