ZF-3006: Zend_Cache SQLite backend creates SQLite 2.x databases
Apparently, Zend_Cache SQLite backend creates SQLite 2.x databases that most GUI tools fail to open them because they support only SQLite 3.x databases. Need an option to specify which version of SQLite database files to create (2.x, 3.x). Maybe, use PDO sqlite while creating the database file?
Further, under unix, the sqlite db file is created as a unix executable with the following privileges:
_www : Read & Write staff : Read & Write everyone : Read & Write
Is this an issue with not being able to open the file in sqlite GUI tools?