# Orchbase Environment Variables
# Copy this file to .env and customize the values
#
# ⚠️  NOTE: This is a PostgreSQL fork of PocketBase.
#     SQLite is NOT supported by this codebase.
#     Use the original PocketBase for SQLite support.

# ============================================================
# DATABASE CONFIGURATION (PostgreSQL Only)
# ============================================================
# Database type: "sqlite", "postgres" or "mysql"
DB_TYPE=postgres
# PostgreSQL connection URL (REQUIRED)
# Format: postgres://user:password@host:port/database?sslmode=disable
POSTGRES_URL=postgres://user:pass@127.0.0.1:6432/postgres?sslmode=disable

# PostgreSQL database names
# These databases will be created automatically if they don't exist
POSTGRES_DATA_DB=pb-data
POSTGRES_AUX_DB=pb-auxiliary

# MySQL Configuration (used when DB_TYPE=mysql)
MYSQL_DSN="root:password@tcp(127.0.0.1:3306)/"
MYSQL_DATA_DB=pb_data
MYSQL_AUX_DB=pb_auxiliary

# Data directory for file storage (also used for SQLite db files)
#PB_DATA_DIR=./pb_data

# ============================================================
# SECURITY CONFIGURATION
# ============================================================

# Encryption key for app settings (including S3 credentials)
# IMPORTANT: This must be EXACTLY 32 characters for AES-256 encryption
# 
# To generate a secure key, run one of these commands:
#   openssl rand -base64 32 | head -c 32
#   head -c 32 /dev/urandom | base64 | head -c 32
#
# WARNING: 
# - Keep this key secret and never commit it to version control
# - If you lose this key, you will not be able to decrypt your settings
# - Changing this key will require re-entering all encrypted settings
#
# Example (DO NOT use this in production):
# PB_ENCRYPTION_KEY=your-32-character-secret-key123

# ============================================================
# OPTIONAL CONFIGURATION
# ============================================================

# Data directory path for file storage (default: ./pb_data)
# Note: Even with PostgreSQL, files are still stored locally
PB_DATA_DIR=./pb_data

# Public directory for static files (default: ./pb_public)
# PB_PUBLIC_DIR=./pb_public

# Hooks directory for JavaScript hooks (default: ./pb_hooks)
# PB_HOOKS_DIR=./pb_hooks

# Enable realtime bridge for horizontal scaling (default: true)
# PB_REALTIME_BRIDGE=true

# Debug mode - prints database configuration on startup
# PB_DEBUG=true

# Set to false to disable the admin UI dashboard
# PB_ADMIN_UI_ENABLED=true