.env.example

# EXAMPLE ENV FILE

# replace EXAMPLE-PASSWORD and DOCKER-HOST-IP. 
# SUPABASE-GENERATED-STRING is just a placeholder to show you how the url should look. This portion is generated by supabase. see supabase docs

# RESOURCES

# prisma database connection strings
# https://pris.ly/d/connection-strings

# supabase connection pooling for serverless environment. ie. Netlify, Vercel
# https://supabase.com/docs/guides/integrations/prisma



# EXAMPLE ENV VARS

# SQLITE
DATABASE_URL=file:./server/db/dev.db


# POSTGRES IN DOCKER CONTAINER
DATABASE_URL="postgresql://postgres:postgres@DOCKER-HOST-IP/nuxt-trpc?schema=public"

# SUPABASE DEV (local)
DATABASE_URL="postgresql://postgres:EXAMPLE-PASSWORD@db.SUPABASE-GENERATED-STRING.supabase.co:5432/postgres"
SHADOW_DATABASE_URL="postgresql://postgres:EXAMPLE-PASSWORD@db.SUPABASE-GENERATED-STRING.supabase.co:5432/postgres_shadow"

# SUPABASE PROD (connection pooling)
# (uses pgbouncer and connection limit) - SET THIS IN NETLIFY OR VERCEL UI ** WITHOUT QUOTES !!! **
# Dev doesn't use this. Migrates will not work with this url. 
DATABASE_URL="postgresql://postgres:EXAMPLE-PASSWORD@db.SUPABASE-GENERATED-STRING.supabase.co:5432/postgres?pgbouncer=true&connection_limit=1"