SQLite 3 cache engine for Zend Framework 1 (native driver)

Purposes

1. add SQLite 3-based cache engine to Zend Framework 1, besides the default SQLite 2 engine
2. provide it as Composer package, with specific requirements and fully automated installation
3. integrate with the official Zend Framework 1 package

How to use

1. add this package to your project dependencies:

   composer require francescozanoni/zend-cache-sqlite3-native

2. customize application.ini file:

   resources.cachemanager.<cache_name>.backend.name = Sqlite3
   resources.cachemanager.<cache_name>.backend.options.cache_db_complete_path = "/path/to/cache.sqlite"

3. create cache database file and make it writable by web user (tables are created automatically by the engine itself):

   touch /path/to/cache.sqlite
   chmod 777 /path/to/cache.sqlite

How to test

• on Unix/Linux:

  cd /path/to/zend-cache-sqlite3-native
  vendor/bin/phpunit test

• on Windows:

  cd \path\to\zend-cache-sqlite3-native
  vendor\bin\phpunit.bat test

History

1. gencer/zend-cache-sqlite3 started the project, with instructions on how to manually copy and paste the code to the suitable Zend Framework's subfolder. PDO and native driver versions are provided together.
2. tttptd/zend-cache-sqlite3 added a basic Composer-compliant structure, but left the manual installation and the two versions together.
3. I've added the official Zend Framework 1 package as requirement and split the original package into two different packages: this one and francescozanoni/zend-cache-sqlite3-pdo, in order to let the final user choose and handle requirements accordingly. The engine code (src/Zend/Cache/Backend/Sqlite3.php) was taken as-is from the mentioned repositories, I've only wrapped it into a Composer-compliant file/folder structure.

References

• https://framework.zend.com/manual/1.12/en/zend.cache.html
• https://github.com/gencer/zend-cache-sqlite3
• https://github.com/tttptd/zend-cache-sqlite3
• https://github.com/francescozanoni/zend-cache-sqlite3-pdo