Issue Type: Improvement Created: 2008-03-31T23:57:09.000+0000 Last Updated: 2012-01-28T10:28:29.000+0000 Status: Open Fix version(s): - Next Major Release ()
Reporter: Shekar Reddy (zendfw) Assignee: Marc Bennewitz (private) (mabe) Tags: - Zend_Cache
Related issues: Attachments:
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?
Posted by Shekar Reddy (zendfw) on 2008-04-01T12:19:11.000+0000
Zend_Cache_SQLite is creating sqlite2 databases probably because it is using the library: http://www.php.net/manual/en/ref.sqlite.php
To create sqlite3 databases, it may have to use: http://www.php.net/manual/en/ref.pdo-sqlite.php
Posted by Wil Sinclair (wil) on 2008-04-18T15:53:09.000+0000
Please evaluate and categorize/assign as necessary.
Posted by Fabien MARTY (fab) on 2008-04-19T03:29:00.000+0000
I agree with you, this could be an option of the Sqlite backend
Posted by thing2b (thing2b) on 2008-11-04T13:45:14.000+0000
It would be great to use SQLite 3.x databases.
What I can not understand is why Zend_Cache_Backend_Sqlite makes native database calls when calls could be made through Zend_Db_Adapter_Pdo_Sqlite. If I am correct, Zend_Db_Adapter_Pdo_Sqlite supports SQLite2 and SQLite3 databases. Surely making calls on a Zend_Db_Adapter would make things more flexable?
I think Zend_Cache_Backend_Sqlite should be able to be constructed with a path to a Sqlite file OR a Zend_Db_Adapter. Although it might not be wise to use many other Zend_Db_Adapter types, the choice should be mine.
Posted by Marc Bennewitz (private) (mabe) on 2009-06-22T23:31:01.000+0000
I'm working on a Zend_Cache refactoring proposal. This would handle all SQLite versions and php adapters.
Please take a look and tell your opinions.
PS: A native sqlite call is much faster and some sql's ( e.g. CREATE ) are not same on all databases ;)
Posted by Fabien MARTY (fab) on 2009-07-17T11:03:33.000+0000
change Assignee because I'm inactive now
Posted by Marc Bennewitz (private) (mabe) on 2010-04-16T11:02:20.000+0000
This will be fixed in ZF 2.0 on using one of the installed extensions sqlite3, pdo_sqlite or sqlite and/or based on Pádraic's Zend_Cache_Backend_Database proposal.
Posted by Ame Nomade (ame_nomade) on 2011-10-26T13:38:59.000+0000
Hi, did you noticed that in Ubuntu 11.10, support of Sqlite 2.x has been dropped down? It is true for the desktop version, and also for the server one. See, the issue in Launchpad: https://bugs.launchpad.net/ubuntu/+source/…
Posted by Gencer (gencer) on 2012-01-28T10:28:29.000+0000
For who want to use Zend_Cache with SQLite3 support on v1x follow this link: http://gencergenc.wordpress.com/2012/01/…
Have you found an issue?
See the Overview section for more details.