Relational database support

[jyecusch]

Support deployment of Relational SQL databases in Nitric apps. Initial support will focus on Postgres databases.

[chimon2000]

Would this integration also have a mechanism for migrations?

[tjholm]

Current preview implementation for AWS available at: nitrictech/nitric#613

@chimon2000 This does include a migration mechanism at the moment. This comes in two flavors.

1. Simple migrations directory, this can be specified as part of your IfC database definition:

import { sql } from "@nitric/sdk";

const myDatabase = sql("my-db", {
  // Use a migrations folder relative to the nitric.yaml
  migrations: "file:///migrations/"
});

2. Custom dockerfile, this will allow the use of existing migration tooling, that may come as part of an existing ORM that is being used (e.g. Prisma/Drizzle etc)

import { sql } from "@nitric/sdk";

const myDatabase = sql("my-db", {
  // Use a dockerfile relative to the nitric.yaml
  migrations: "dockerfile:///migrations.dockerfile"
});

[chimon2000]

migrations

In the case of Option 1, how would Nitric use the migrations folder?

[tjholm]

@chimon2000 apologies for the late reply. The migrations folder uses https://github.com/golang-migrate/migrate by default in our preview release, we'll build a default migration image in the case where a migrations directory is given using that tool.