.env.example

# Database provider: "postgres" (default) or "supabase"
DB_PROVIDER=postgres

# --- PostgreSQL (default) ---
PG_USER=p-stream_user
# Use a strong password
PG_PASSWORD=password
PG_DB=p-stream_backend
DATABASE_URL="postgresql://${PG_USER}:${PG_PASSWORD}@localhost:5432/${PG_DB}?schema=public"
DATABASE_URL_DOCKER="postgresql://${PG_USER}:${PG_PASSWORD}@postgres:5432/${PG_DB}?schema=public"

# --- Supabase (set DB_PROVIDER=supabase to use) ---
# DATABASE_URL is the direct connection (port 5432) — used for migrations
# DATABASE_URL_SUPABASE is the pooler connection (port 6543) — used at runtime
# Both are found in your Supabase project under Settings > Database > Connection string
# DATABASE_URL="postgresql://postgres.[ref]:[password]@aws-0-[region].pooler.supabase.com:5432/postgres"
# DATABASE_URL_SUPABASE="postgresql://postgres.[ref]:[password]@aws-0-[region].pooler.supabase.com:6543/postgres"

# App metadata
META_NAME=''
META_DESCRIPTION=''

# Required: Security secret (generate with `openssl rand -base64 24` or use https://bitwarden.com/password-generator/)
CRYPTO_SECRET='' 

# API Keys
# From https://www.themoviedb.org/settings/api
TMDB_API_KEY=''
# From https://trakt.tv/oauth/applications
# Click New Application after you've logged in, enter the name of the app, which doesnt matter, and for redirect url, just do https://google.com, it doesnt matter
# Now it will show you those keys
TRAKT_CLIENT_ID=''
TRAKT_SECRET_ID=''

# Optional: connection pool size (default: 30 for postgres, 10 for supabase)
# When DB_PROVIDER=supabase, keep this at or below 15 on the free tier to avoid connection refusals.
DB_POOL_MAX=

# Optional: Captcha
CAPTCHA=false
CAPTCHA_CLIENT_KEY=''