.env.example

# pgsqlite Configuration Example
# Copy this file to .env and adjust values as needed

# Basic Configuration
PGSQLITE_PORT=5432
PGSQLITE_DATABASE=sqlite.db
PGSQLITE_LOG_LEVEL=info
PGSQLITE_IN_MEMORY=false
PGSQLITE_SOCKET_DIR=/tmp
PGSQLITE_NO_TCP=false

# Cache Configuration
PGSQLITE_ROW_DESC_CACHE_SIZE=1000
PGSQLITE_ROW_DESC_CACHE_TTL_MINUTES=10
PGSQLITE_PARAM_CACHE_SIZE=500
PGSQLITE_PARAM_CACHE_TTL_MINUTES=30
PGSQLITE_QUERY_CACHE_SIZE=1000
PGSQLITE_QUERY_CACHE_TTL=600
PGSQLITE_EXECUTION_CACHE_TTL=300
PGSQLITE_RESULT_CACHE_SIZE=100
PGSQLITE_RESULT_CACHE_TTL=60
PGSQLITE_STATEMENT_POOL_SIZE=100
PGSQLITE_CACHE_METRICS_INTERVAL=300
PGSQLITE_SCHEMA_CACHE_TTL=300

# Buffer Pool Configuration
PGSQLITE_BUFFER_MONITORING=0
PGSQLITE_BUFFER_POOL_SIZE=50
PGSQLITE_BUFFER_INITIAL_CAPACITY=4096
PGSQLITE_BUFFER_MAX_CAPACITY=65536

# Memory Monitor Configuration
PGSQLITE_AUTO_CLEANUP=0
PGSQLITE_MEMORY_MONITORING=0
PGSQLITE_MEMORY_THRESHOLD=67108864
PGSQLITE_HIGH_MEMORY_THRESHOLD=134217728
PGSQLITE_MEMORY_CHECK_INTERVAL=10

# Memory Mapping Configuration
PGSQLITE_ENABLE_MMAP=0
PGSQLITE_MMAP_MIN_SIZE=65536
PGSQLITE_MMAP_MAX_MEMORY=1048576
# PGSQLITE_TEMP_DIR=/tmp

# SQLite PRAGMA Settings
PGSQLITE_JOURNAL_MODE=WAL
PGSQLITE_SYNCHRONOUS=NORMAL
PGSQLITE_CACHE_SIZE=-64000
PGSQLITE_MMAP_SIZE=268435456