.env.example

# Copy this file to .env and fill in your actual values.
# NEVER commit the real .env file to git!

# ─────────────────────────────────────────────────────────────
# REDIS (Required for both Oracle and PostgreSQL setups)
# Get yours at: https://upstash.com (free tier available)
# ─────────────────────────────────────────────────────────────
REDIS_URL=redis://default:YOUR_PASSWORD@YOUR_HOST.upstash.io:6379

# ─────────────────────────────────────────────────────────────
# DATABASE — Uncomment ONE of the two options below:
# ─────────────────────────────────────────────────────────────

# OPTION A: Oracle (for local development)
# Format: oracle+oracledb://username:password@host:port/?service_name=service
DATABASE_URL=oracle+oracledb://YOUR_USER:YOUR_PASSWORD@YOUR_HOST:1521/?service_name=YOUR_SERVICE

# OPTION B: PostgreSQL (for Render, Supabase, Neon, etc.)
# Format: postgresql+asyncpg://username:password@host:port/database_name
# DATABASE_URL=postgresql+asyncpg://YOUR_USER:YOUR_PASSWORD@YOUR_HOST:5432/YOUR_DB_NAME

# ─────────────────────────────────────────────────────────────
# SWITCHING BETWEEN DATABASES:
# 1. Comment out the active DATABASE_URL line above
# 2. Uncomment the other one
# 3. That's it! No code changes needed.
# ─────────────────────────────────────────────────────────────