.env.example

# ===========================================
# Java API - Environment Configuration
# ===========================================
# Copy this file to .env and update values for your environment.
# Note: Spring Boot doesn't load .env files by default. 
# Use: spring-dotenv dependency, or load via shell before running.
#
# PowerShell: Get-Content .env | ForEach-Object { if ($_ -match '^([^#].+?)=(.*)$') { [System.Environment]::SetEnvironmentVariable($matches[1], $matches[2]) } }
# Bash: export $(grep -v '^#' .env | xargs)

# ===========================================
# Server Configuration
# ===========================================
SERVER_PORT=8080
SERVER_MAX_THREADS=200
SERVER_MIN_THREADS=10

# ===========================================
# Default Database (Primary)
# ===========================================
# H2 (Development)
DEFAULT_DB_URL=jdbc:h2:mem:defaultdb;DB_CLOSE_DELAY=-1
DEFAULT_DB_USERNAME=sa
DEFAULT_DB_PASSWORD=
DEFAULT_DB_DRIVER=org.h2.Driver

# PostgreSQL Example:
# DEFAULT_DB_URL=jdbc:postgresql://localhost:5432/myapp
# DEFAULT_DB_USERNAME=postgres
# DEFAULT_DB_PASSWORD=your_password
# DEFAULT_DB_DRIVER=org.postgresql.Driver

# MySQL Example:
# DEFAULT_DB_URL=jdbc:mysql://localhost:3306/myapp
# DEFAULT_DB_USERNAME=root
# DEFAULT_DB_PASSWORD=your_password
# DEFAULT_DB_DRIVER=com.mysql.cj.jdbc.Driver

# ===========================================
# Additional Databases (Add as needed)
# ===========================================
# Configure additional databases in application.yml under app.datasources
# Or add environment variables and reference them in application.yml:
#
# INVENTORY_DB_URL=jdbc:postgresql://localhost:5432/inventory
# INVENTORY_DB_USERNAME=postgres
# INVENTORY_DB_PASSWORD=secret
#
# ORDERS_DB_URL=jdbc:mysql://localhost:3306/orders
# ORDERS_DB_USERNAME=root  
# ORDERS_DB_PASSWORD=secret

# ===========================================
# Redis Configuration (Optional)
# ===========================================
REDIS_HOST=localhost
REDIS_PORT=6379
REDIS_PASSWORD=
REDIS_TIMEOUT=2000

# ===========================================
# Cache Configuration
# ===========================================
# Options: simple (in-memory), redis (distributed)
CACHE_TYPE=simple

# ===========================================
# H2 Console (Development Only)
# ===========================================
H2_CONSOLE_ENABLED=true

# ===========================================
# Async Processing
# ===========================================
ASYNC_CORE_POOL_SIZE=5
ASYNC_MAX_POOL_SIZE=10
ASYNC_QUEUE_CAPACITY=25

# ===========================================
# Pagination
# ===========================================
DEFAULT_PAGE_SIZE=20
MAX_PAGE_SIZE=100

# ===========================================
# External API Configuration
# ===========================================
EXTERNAL_API_TIMEOUT=5000
EXTERNAL_API_RETRY=3