kodus/db-cache

PSR-16 cache-implementation for SQL databases

2.1.0 2025-01-13 10:16 UTC

Requires

• php: >= 8.0
• ext-pdo: *
• psr/simple-cache: ^2||^3

Requires (Dev)

• phpunit/phpunit: ^9.5

Provides

• psr/simple-cache-implementation: 1.0

MIT

• Rasmus Schultz

README

PSR-16 cache implementation for PostgreSQL (9.5+) and MySQL.

Tuned for fast, precise SQL - all operations (including multiple get/set/delete) are fully transactional and complete in a single round-trip.

No dependencies beyond the PSR-16 interface.

Installation

Install via Composer:

composer require kodus/db-cache

Usage

The constructor will automatically detect PostgreSQL or MySQL and use the appropriate adapter - all you need to do is open a PDO connection and specify a table-name and default TTL:

$pdo = new PDO("pgsql:host=localhost;port=5432;dbname=test", "root", "root");

$cache = new DatabaseCache($pdo, "my_cache_table", 24*60*60);

Tables are automatically created with the first database operation.

Please refer to PSR-16 documentation for general usage.