-
Notifications
You must be signed in to change notification settings - Fork 86
Open
Labels
WalletChanges related to the watch-only walletChanges related to the watch-only walletcode qualityGenerally improves code readability and maintainabilityGenerally improves code readability and maintainabilityenhancementNew feature or requestNew feature or request
Description
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/
- Add a migrations/ folder with versioned SQL (e.g. V1__initial.sql, V2__add_column_xyz.sql).
- Ensure an initial migration reproduces the schema introduced in PR Wallet: move database to sqlite, remove kv and memmory db #804.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
WalletChanges related to the watch-only walletChanges related to the watch-only walletcode qualityGenerally improves code readability and maintainabilityGenerally improves code readability and maintainabilityenhancementNew feature or requestNew feature or request