Switching From Knex to Sequelize: Part 1

[klondikemarlen]

In progress at https://github.com/icefoganalytics/elcc-data-management/compare/main...icefoganalytics:elcc-data-management:issue-12/switching-from-knex-to-sequelize

Context

Knex is a straight sql generator and as such has limited capabilities, and requires manual optimization around multi-table queries. Sequelize is a Object-relational mapping (ORM) tool and as such handles everything that Knex does, plus supporting easy and efficient multi-table queries.

https://sequelize.org/ https://knexjs.org/

Examples of things that Knex does poorly but Sequelize does well

• src/api/services/funding-requests-service.ts
• src/api/services/portal/students/student-application-student-persons-service.ts

[klondikemarlen]

Switching to working on Add Relative Path Support To Api Typescript #14 first as it will make this much easier.