.env.example

#DATABASE Configuration
DB_HOST=localhost
DB_PORT=5432
DB_NAME=myapp
DB_USER=postgres
DB_PASSWORD=password

#TEST DATABASE Configuration
TEST_DB_HOST=localhost
TEST_DB_PORT=5432
TEST_DB_NAME=myapp_test
TEST_DB_USER=postgres
TEST_DB_PASSWORD=password

#Connection Pooling
DB_CONNECTION_TIMEOUT=20000
DB_ACQUIRE_TIMEOUT=20000
DB_MAX_CONNECTIONS=20
DB_MIN_CONNECTIONS=5
DB_IDLE_TIMEOUT=30000

#LOGGING
DB_LOGGING=true
LOG_LEVEL=info

#Environment
NODE_ENV=development

#Cache Warming Service
CACHE_WARMING_PORT=3021
CACHE_WARMING_DB_NAME=cache_warming_db
CACHE_WARMING_SCHEDULER_ENABLED=true
CACHE_WARMING_SEED_DEFAULTS=true
CACHE_WARM_ON_STARTUP=true
CACHE_WARMING_LIMIT=50
CACHE_ADAPTIVE_WARMING_LIMIT=30
CACHE_HIT_RATE_TARGET=0.85
REDIS_PASSWORD=redis123

#CDN Delivery
CDN_BASE_URL=https://cdn.example.com
CDN_FALLBACK_URL=https://storage.example.com
CDN_PROVIDER=generic
CDN_PURGE_URL=
CDN_PURGE_TOKEN=
CDN_DEFAULT_TTL_SECONDS=86400
CDN_STALE_WHILE_REVALIDATE_SECONDS=3600

#Backup Configuration
BACKUP_PATH=./backups
BACKUP_RETENTION_DAYS=30

#Google OAuth
GOOGLE_CLIENT_ID=your-google-client-id
GOOGLE_CLIENT_SECRET=your-google-client-secret
GOOGLE_CALLBACK_URL=http://localhost:3000/auth/google/callback

#Discord Integration
DISCORD_WEBHOOK_URL=https://discord.com/api/webhooks/your-webhook-url
DISCORD_BOT_NAME=Quest Service Bot
DISCORD_PUBLIC_KEY=your-discord-public-key

#Twitter/X Integration
TWITTER_CLIENT_ID=your-twitter-client-id
TWITTER_CLIENT_SECRET=your-twitter-client-secret
APP_URL=http://localhost:3000