.env.example

# Database configuration
DATABASE_URL=postgresql://admin:root@postgresql:5432/pypistats

# Redis configuration
REDIS_URL=redis://redis:6379/0

# Google BigQuery service account JSON
# Download from Google Cloud Console and paste the entire JSON as a single line
GOOGLE_SERVICE_ACCOUNT_JSON='{"type":"service_account","project_id":"your-project-id","private_key_id":"...","private_key":"-----BEGIN PRIVATE KEY-----\n...\n-----END PRIVATE KEY-----\n","client_email":"...@...iam.gserviceaccount.com","client_id":"...","auth_uri":"https://accounts.google.com/o/oauth2/auth","token_uri":"https://oauth2.googleapis.com/token","auth_provider_x509_cert_url":"https://www.googleapis.com/oauth2/v1/certs","client_x509_cert_url":"..."}'

# Admin panel authentication
BASIC_AUTH_USER=admin
BASIC_AUTH_PASSWORD=changeme

# Flask secret key (generate a random one for production)
PYPISTATS_SECRET=dev-secret-key-change-in-production

# Optional: GitHub OAuth for user authentication
# GITHUB_CLIENT_ID=your-github-oauth-app-id
# GITHUB_CLIENT_SECRET=your-github-oauth-app-secret

# Optional: Override default ports for local development
# Leave commented to use docker-compose defaults
# DATABASE_URL=postgresql://admin:root@localhost:5433/pypistats
# REDIS_URL=redis://localhost:6379/0