Issues

ZF-3006: Zend_Cache SQLite backend creates SQLite 2.x databases

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:

Description

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?

Comments

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

Hi,

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.

Copyright

© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.

Contacts