With the removal of sqlite2 from php-5.4, I was just wondering what the eventual plans for SQLite are?
On 05/14/2012 03:57 PM, Michael Orlitzky wrote:
With the removal of sqlite2 from php-5.4, I was just wondering what the eventual plans for SQLite are?
We're using PEAR MDB2 package and there's no official driver for sqlite3. For now we don't plan to work on this. However there is a ticket in our tracker that we could/should use other database abstraction package. We could also write our own library based on PDO. It shouldn't be so hard, because we've got quite small needs, but it has low priority. Also most people use mysql/pgsql.
On 05/15/2012 02:25 AM, A.L.E.C wrote:
On 05/14/2012 03:57 PM, Michael Orlitzky wrote:
With the removal of sqlite2 from php-5.4, I was just wondering what the eventual plans for SQLite are?
We're using PEAR MDB2 package and there's no official driver for sqlite3. For now we don't plan to work on this. However there is a ticket in our tracker that we could/should use other database abstraction package. We could also write our own library based on PDO. It shouldn't be so hard, because we've got quite small needs, but it has low priority. Also most people use mysql/pgsql.
Thanks for the update. We're not using SQLite here (for RC, anyway), but this showed up in a dependency bug on Gentoo. When users ask for SQLite support, they pull in both php-5.3 and php-5.4 due to the lack of sqlite2 in 5.4.
Only 5.3 would work anyway, so I guess the deps will have to be fixed (for better error messages) or sqlite support dropped in the future as users move to 5.4.
On Tue, May 15, 2012 at 8:25 AM, A.L.E.C alec@alec.pl wrote:
On 05/14/2012 03:57 PM, Michael Orlitzky wrote:
With the removal of sqlite2 from php-5.4, I was just wondering what the eventual plans for SQLite are?
We're using PEAR MDB2 package and there's no official driver for sqlite3. For now we don't plan to work on this. However there is a ticket in our tracker that we could/should use other database abstraction package. We could also write our own library based on PDO. It shouldn't be so hard, because we've got quite small needs, but it has low priority. Also most people use mysql/pgsql.
For the sake of completeness, here are the mentioned tickets in both our tracker and the corresponding feature request on the PEAR MDB2 project page: http://trac.roundcube.net/ticket/1488332 http://pear.php.net/bugs/bug.php?id=6907
The latter one even contains an unofficial patch of a PDO+SQlite3 driver for MDB2.
But the best choice, however, would certainly be to replace the use of MDB2 with our own implementation using PDO which is default since PHP 5.1
~Thomas
On 05/15/2012 09:26 AM, Thomas Bruederli wrote:
But the best choice, however, would certainly be to replace the use of MDB2 with our own implementation using PDO which is default since PHP 5.1
I've just pushed pdo branch with DB layer based on PDO. For now only mssql and sqlsrv drivers aren't complete. I've tested already pgsql driver.