> ## Documentation Index > Fetch the complete documentation index at: https://mintlify.com/charlietyn/rest-generic-class/llms.txt > Use this file to discover all available pages before exploring further. # Environment Variables > Complete reference of all environment variables used by Rest Generic Class The Rest Generic Class package reads all configuration values from `config/rest-generic-class.php`, which in turn reads environment variables. This design is safe for Laravel's configuration caching. ## Logging Variables ### LOG\_LEVEL Sets the minimum log level for the package's logging channel. **Valid values:** `emergency`, `alert`, `critical`, `error`, `warning`, `notice`, `info`, `debug` **Example:** ```env theme={null} LOG_LEVEL=error ``` ### LOG\_QUERY When enabled, logs all query operations to `storage/logs/query.log` for debugging. **Use case:** Debugging API filtering and query generation **Example:** ```env theme={null} LOG_QUERY=true ``` Enabling `LOG_QUERY` in production can significantly increase log file sizes and I/O overhead. Use only for troubleshooting. ## Filtering Variables ### REST\_VALIDATE\_COLUMNS Validates that column names in filter conditions exist in the database table before executing queries. **Security:** Prevents SQL injection and information disclosure **Example:** ```env theme={null} REST_VALIDATE_COLUMNS=true ``` ### REST\_STRICT\_COLUMNS Enforces strict column validation, rejecting requests with invalid column names. **When false:** Invalid columns are silently ignored **When true:** Invalid columns cause validation errors **Example:** ```env theme={null} REST_STRICT_COLUMNS=true ``` Both `REST_VALIDATE_COLUMNS` and `REST_STRICT_COLUMNS` should be `true` in production for security. Disabling these allows potentially unsafe column names in queries. ## Cache Variables ### REST\_CACHE\_ENABLED Master switch for response caching in `BaseService` read operations. **When enabled:** `list_all` and `get_one` methods cache responses **Example:** ```env theme={null} REST_CACHE_ENABLED=true ``` ### REST\_CACHE\_STORE Specifies which Laravel cache store to use for caching responses. **Valid values:** Any Laravel cache driver (`redis`, `database`, `file`, `memcached`, `dynamodb`, `array`) **Example:** ```env theme={null} REST_CACHE_STORE=redis ``` ### REST\_CACHE\_TTL Default time-to-live (in seconds) for cached responses. **Used when:** Method-specific TTL is not defined **Example:** ```env theme={null} REST_CACHE_TTL=300 ``` ### REST\_CACHE\_TTL\_LIST Time-to-live (in seconds) for `list_all` method responses. **Use case:** Cache list/index endpoints longer or shorter than single-item reads **Example:** ```env theme={null} REST_CACHE_TTL_LIST=120 ``` ### REST\_CACHE\_TTL\_ONE Time-to-live (in seconds) for `get_one` method responses. **Use case:** Cache single-item reads with different TTL than lists **Example:** ```env theme={null} REST_CACHE_TTL_ONE=60 ``` ## Validation Cache Variables ### REST\_VALIDATION\_CACHE\_ENABLED Enables caching for database existence validation queries used by the `ValidatesExistenceInDatabase` trait. **Performance impact:** Significantly reduces database load for validation **Example:** ```env theme={null} REST_VALIDATION_CACHE_ENABLED=true ``` ### REST\_VALIDATION\_CACHE\_TTL Time-to-live (in seconds) for cached validation query results. **Recommendation:** Use longer TTL (1+ hours) since table schemas rarely change **Example:** ```env theme={null} REST_VALIDATION_CACHE_TTL=7200 ``` ### REST\_VALIDATION\_CACHE\_PREFIX Prefix for validation cache keys, helping organize and identify validation-related cache entries. **Example:** ```env theme={null} REST_VALIDATION_CACHE_PREFIX=rest_validation ``` ### REST\_VALIDATION\_CONNECTION Database connection name used for validation queries. **Use case:** Use a read replica for validation queries to reduce primary database load **Example:** ```env theme={null} REST_VALIDATION_CONNECTION=mysql_read ``` ## Example Configurations ### Development Environment ```env theme={null} # Logging LOG_LEVEL=debug LOG_QUERY=true # Filtering REST_VALIDATE_COLUMNS=true REST_STRICT_COLUMNS=true # Cache (disabled for development) REST_CACHE_ENABLED=false # Validation cache REST_VALIDATION_CACHE_ENABLED=true REST_VALIDATION_CACHE_TTL=3600 ``` ### Production Environment ```env theme={null} # Logging LOG_LEVEL=error LOG_QUERY=false # Filtering REST_VALIDATE_COLUMNS=true REST_STRICT_COLUMNS=true # Cache (Redis for production) REST_CACHE_ENABLED=true REST_CACHE_STORE=redis REST_CACHE_TTL=300 REST_CACHE_TTL_LIST=300 REST_CACHE_TTL_ONE=600 # Validation cache REST_VALIDATION_CACHE_ENABLED=true REST_VALIDATION_CACHE_TTL=7200 REST_VALIDATION_CACHE_PREFIX=validation REST_VALIDATION_CONNECTION=mysql_read ``` ### Staging Environment ```env theme={null} # Logging LOG_LEVEL=info LOG_QUERY=false # Filtering REST_VALIDATE_COLUMNS=true REST_STRICT_COLUMNS=true # Cache (file-based for simple staging) REST_CACHE_ENABLED=true REST_CACHE_STORE=file REST_CACHE_TTL=120 REST_CACHE_TTL_LIST=120 REST_CACHE_TTL_ONE=180 # Validation cache REST_VALIDATION_CACHE_ENABLED=true REST_VALIDATION_CACHE_TTL=3600 ``` ## Configuration Caching Behavior When you run `php artisan config:cache`, Laravel caches all configuration values. After caching, changes to `.env` files are **ignored** until you clear the cache with `php artisan config:clear` or re-cache. This is why the package reads environment variables **only** from the config file, not directly via `env()` calls in service code. This pattern ensures compatibility with Laravel's configuration caching. ## Related Topics Learn about cache stores, TTL strategies, and invalidation Configure validation caching behavior