TBD moving from Postgres - v22-appfactory/appfactory-wiki GitHub Wiki

  • Details of Oracle support for JSON columns. What version supports this (for comparison to Oracle versions in customer network)
  • Examples of converting Postrgesql to Oracle procedures. Where do the differences exist.
  • Examples of converting Sequelize to Knex.js.
  • Comparison of Sequelize calling a SQL procedure to Knex calling a procedure.
  • Comparison of Sequelize model queries to Knex model (if it exists)
  • Discussion of where the changes would take place. Are the controllers being replaced? Are the models being replaced and how different would that be? Can the database calls be further modularized so that the controllers only need to make calls to a layer that gets replaced rather than touching every controller?

NOTE: I wouldn't try to do this in one page. I would create an overview page with links to discussions of each of the bullets above.