Adding Relational Database Support #2
Description
To make these APIs really useful, we need to have them use a relational database. The cool part is that the first example of this has already been done in the JS Express API, so you can use the existing DB to create models automagically.
The requirement is that the API should support Azure SQL and SQLite. An ORM should make that pretty trivial, plus give us Oracle SQL, Postgres and MySQL support too.
The Azure SQL Server that can be used to create your models is here.
- Generate Models from existing DB
- Initialize DB tables if they don't exist
- Update API endpoints to use DB Models to access and update data