Infrastructure as code

We manage our infrastructure with Terraform; configs are in a separate repo: https://github.com/quantified-uncertainty/ops

Database

PostgresQL cluster is on Digital Ocean.

We have two databases:

1. Production for the main branch.
2. Preview for everything else.

(These are for Squiggle Hub, other packages don't need a database.)

There are corresponding Github Actions for migrating database schemas:

• Prisma Migrate Preview DB
• Prisma Migrate Production DB
• Reset Preview DB

"Prisma Migrate Preview DB" runs on PRs automatically.

"Prisma Migrate Production DB" should be invoked manually (TODO: will be automated after #2227)

• before the PR that needs a migration is merged, if the migration includes new tables or columns
• after the PR is merged and deployed, if the migration drops old tables or columns