env.dev.example

# .env.dev — Local development environment variables
# Copy this to .env and adjust values for your machine.
# Never commit .env (it is gitignored).
#
# Usage:
#   PowerShell:  Get-Content .env.dev | ForEach-Object { if ($_ -match '^([^#][^=]*)=(.*)$') { [System.Environment]::SetEnvironmentVariable($matches[1].Trim(), $matches[2].Trim(), 'Process') } }
#   bash:        set -a && source .env.dev && set +a

# ── PostgreSQL connection ─────────────────────────────────────────────────────
PGHOST=localhost
PGPORT=5433
PGUSER=postgres
PGPASSWORD=changeme_local_only
PGDATABASE=te_mgmt_dev

# ── API settings ──────────────────────────────────────────────────────────────
# Leave API_KEY empty for local dev (unauthenticated).
# Set a strong random value before deploying anywhere reachable.
API_KEY=

# Schemas
CSV_UPLOADS_SCHEMA=csv_uploads
TE_SCHEMA=te_dev

# CORS — frontend dev server ports
CORS_ORIGINS=http://localhost:5173,http://localhost:3000

# Upload limits
MAX_UPLOAD_BYTES=52428800
API_MAX_ROWS=100000
API_MAX_ROW_ERRORS=200
API_POOL_GETCONN_TIMEOUT=5.0

# Safety guard — keep false in dev; set true only when explicitly needed
API_ALLOW_DESTRUCTIVE=false

# ── Frontend (csv-table-hub-main/.env.local) ──────────────────────────────────
# Create csv-table-hub-main/.env.local with:
#   VITE_API_BASE=http://localhost:8000
#   VITE_API_KEY=