@resturant-webtool/db-main-prisma

Intro

Basic demo of a shared package using prisma to handle database access, part of the nextjs-monorepo-example

Quick start

Start the database with docker-compose up database then run

cd packages/db-main-prisma
yarn prisma-db-push
yarn prisma-db-seed
yarn prisma-migrate dev
yarn prisma-migrate-reset

See the .env(.local|.production|.development) file to edit the connection. Curious about the setup ?, we use dotenv-flow under the hood read this and see the script section of ./package.json

Install

Database

Option 1: Postgresql local

The default env for PRISMA_DATABASE_URL is defined in the main .env file. By default, it connects to the postgresql service defined in ../../docker-compose.yml.

Ensure you have docker and docker-compose and run

# In the root folder
docker-compose up database
# Alternatively, from any folder
yarn docker:up

Option 2: An hosted postgres instance

To quick start, you can use a free tier at supabase.io, but all providers will work.

As an example, simply create an .env.local and set the supabase pgbouncer url:

PRISMA_DATABASE_URL=postgresql://postgres:[PASSWORD]@[HOST]:[PORT]/postgres?schema=public&pgbouncer=true&sslmode=require&sslaccept=strict&sslcert=../config/certs/supabase-prod-ca-2021.crt

You can append &connection_limit=1 if deploying on a serverless/lambda provider (ie: vercel, netlify...)

DB creation

To create the database, simply run

yarn prisma-db-push

DB Seeding

Create and seed the database the first time or after a change.

yarn prisma-db-seed

DB type generation

Create or update the types. This is generally automatically done in a postinstall from any app, see script section of ../../apps/nextjs-app/package.json or try it out with yarn workspace web-app postinstall

yarn prisma generate