Database

PostgreSQL


This project uses PostgreSQL as the primary database management system, tested with Postgres v14.1, v13.4, and v13.5.

Prisma


This project uses Prisma as Next-generation Node.js and TypeScript ORM.

The database schema is defined in packages/db/prisma/schema.prisma. You can read more about how the Prisma schema works in prisma.io/docs/concepts/components/prisma-schema.

Database Environment Variable

All the services expect the same shared environment variable "DATABASE_URL", which follows the official PostgreSQLI format, extended by the Prisma database connector.

An expected database connection url re-using the test local database should look something like this:

DATABASE_URL=postgresql://postgres:postgres@localhost:5789/postgres

And in the root of the cloned Git of the project, a .env file should start looking like this:

Database environment variable file