Description: ------------ Could you please let us know, whether it is the intention to support version 3 of SQLite within the DB package, together with version 2 obviously, and by when? With the bundled availability of SQLite Version 3 within PHP 5.x it would be a big advantage to have this support within PEAR, allowing developers to move to the latest (and better) version of SQLite easily. Many thanks.

This would require writing a PDO based driver. An important task in its own right.

DB is in maintenance mode, new features should go into MDB2 and we can consider then if its feasible to backport this.

What is the status of PDO drivers in MDB2? Are you planning to replace existing drivers with the versions that will use PDO?

No plan to replace anything, no. Sure, PDO drivers would be nice, but I don't have time to write them. There are talks and even some code drafts about a new PDO-based DBAL: http://thread.gmane.org/gmane.comp.php.pear.devel/43942

There's now a SQLite3 extension in pecl, I guess you could make a driver against that http://pecl.php.net/package/sqlite3 Not bundled by default but well, perhaps a better approach compared to doing a PDO thing

I have written a driver (PDO + Sqlite3). http://downloads.metala.org/pear/MDB2/MDB2_Driver_pdoSqlite.tar.bz2 But it's considered unstable. I haven't tested it much. I wrote it for a night a day ago, and today I added a workaround for the "database is locked" problem. So far, there were no major problems, I think It can be used for testing, but not for production purposes. Here is the main driver part: http://downloads.metala.org/pear/MDB2/Driver/pdoSqlite.php.txt

Seeing as how SQLite 2 is no longer supported upstream, this package has very little use until it is updated to support PDO or SQLite 3. For example, the Roundcube package can no longer use SQLite for a backend. http://trac.roundcube.net/ticket/1488332