Cache

A minimalist SQLite based caching system for Laravel applications, with an option for encryption at rest.

Create the Database

Generate the SQLite database for caching.

php artisan sql-cache:make:database

This will also create the cache table by default.

When adding this you will need to update the cache configuration to use the SQLite cache driver.

'sqlite' => [
    'driver' => 'sqlite',
    'table' => 'cache',
    'database' => env('CACHE_DATABASE', database_path('cache.sqlite')),
    'prefix' => '',
    'encrypted' => false,
],

Create the Cache Locks Table

php artisan sql-cache:make:locks-table

Purge the Cache Locks

Clear all existing cache locks to prevent stale locks from affecting your application.

php artisan sql-cache:purge:locks