.env.example

# === Database ===
# Local dev defaults to SQLite (no external service needed).
# For Postgres (docker-compose / production), use a postgresql+psycopg URL, e.g.:
#   postgresql+psycopg://techapi:techapi@db:5432/techapi
DATABASE_URL=sqlite:///./techapi.db
DATABASE_POOL_SIZE=10

# === Supabase (production Postgres host) ===
SUPABASE_URL=https://xxx.supabase.co
SUPABASE_ANON_KEY=eyJ...
SUPABASE_SERVICE_KEY=eyJ...   # secret, never expose to clients

# === API ===
API_HOST=0.0.0.0
API_PORT=8000
API_ENV=development           # development | staging | production
API_BASE_URL=http://localhost:8000

# === Security ===
SECRET_KEY=change-me          # JWT/session (Phase 4+)
CORS_ORIGINS=http://localhost:3000,https://techpicks.app

# === Logging ===
LOG_LEVEL=INFO
SENTRY_DSN=https://...        # optional

# === External Services ===
REDIS_URL=redis://localhost:6379    # optional (Phase 2+)

# === Scoring ===
SCORING_CONFIG_PATH=./config/scoring.yaml