search

mojaloop / design-authority-project

This is the Issue and Decision Log for tracking mojaloop and related Designs
1 stars 2 forks source link

Knex usage discussion #27

Closed NicoDuvenage closed 4 years ago

NicoDuvenage commented 5 years ago

Request:

Knex is great for spinning up new schemas but making changes to schemas in big operational DBs is a different world.

Knex migrations and SQL upgrade scripts.

Discuss some potential issues with knex migrations in production use and discuss alternatives. Now that we have some live, real money, transfer traffic it is critical to address some concerns.

Artifacts:

Decision(s):

Follow-up:

Dependencies:

Accountability:

Notes:

NicoDuvenage commented 4 years ago

The KNEX discussion extended into talking about the possible use of third-party tools to assist in the generation of queries to help migration efforts. This has no direct bearing on the use of KNEX itself and after exploring a bit deeper, it was decided that there was no compelling reason to continue further investigation into the use of KNEX itself, but to keep an open mind and look out for alternative solutions out there as and when they are introduced. Those libraries will be measured against the current implementation to ensure we deploy the right tools for the right purpose. This issue is now closed.