Database cleanup & updates #3277
Closed
CGoodwin90
started this conversation in
Roadmap
Replies: 2 comments
-
Knex looks promising - the ability to handle versioned migrations, save migration state, and selective rollback are all large positives for me. We should look into how their migration cli operates to figure how best to drive this out of the API image as well, to enhance flexibility. |
Beta Was this translation helpful? Give feedback.
0 replies
-
implemented knex in #3318 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
The current database schema contains a number of legacy tables and inconsistent rows which would benefit from a cleanup.
After internal discussion we decided to simultaneously update how the DB is built and how schema migrations are managed.
Possible options for running DB schema migrations and versioning for Core:
Initial discussion and investigation has Knex.js as the most suitable option - it's already being utilized throughtout the Lagoon API & the Knex Migration CLI should require little integrration work.
Beta Was this translation helpful? Give feedback.
All reactions