Skip to content

Adding Relational Database Support #2

Description

@dkoch84

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions