.env.example

# Environment Variables Configuration

This file lists all environment variables used by the application.

## Required Environment Variables

### Database Configuration
- `SPRING_DATASOURCE_URL` - Full JDBC connection string (default: `jdbc:mysql://localhost:3306/world`)
- `DB_USER` - Database username (default: `root`)
- `DB_PASSWORD` - Database password (default: `root`)

## Optional Environment Variables

### Database Connection Pool
- `DB_POOL_SIZE` - Maximum database connection pool size (default: `10`)
- `DB_POOL_MIN_IDLE` - Minimum idle connections (default: `2`)

### Server Configuration
- `SERVER_PORT` - Application server port (default: `8080`)

### Logging
- `LOG_LEVEL` - Root log level: TRACE, DEBUG, INFO, WARN, ERROR (default: `INFO`)
- `APP_LOG_LEVEL` - Application-specific log level (default: `INFO`)
- `SHOW_SQL` - Show SQL queries in logs: true/false (default: `false`)

## Local Development

For local development, you can create a `.env` file (not committed to git):

```env
# Local Development Settings
DB_USER=root
DB_PASSWORD=root
SPRING_DATASOURCE_URL=jdbc:mysql://localhost:3306/world
SHOW_SQL=true
LOG_LEVEL=DEBUG
```

## Docker/Docker Compose

Environment variables are configured in `docker-compose.yml`.

## AWS Deployment

For AWS deployment (ECS/EKS/App Runner):
- Store secrets in **AWS Secrets Manager** or **Parameter Store**
- Set environment variables in task definition or deployment configuration
- Use RDS endpoint for `SPRING_DATASOURCE_URL`

Example for AWS RDS:
```
SPRING_DATASOURCE_URL=jdbc:mysql://world-db.xxxxx.us-east-1.rds.amazonaws.com:3306/world
```