Update sqlite support to version 3 instead of unmaintained version 2

[rcubetrac]

Reported by soren on 28 Jan 2012 04:33 UTC as Trac ticket #1488332

Roundcube currently depends on version 2 of sqlite if users choose to use that database. Version 2 is no longer supported by upstream. Debian has just removed support for version 2 from their testing line and it will not appear in their next stable release. It is likely that other distributions have all ready removed support for version 2 or will do so shortly. For existing installations of Roundcube, this does not leave an upgrade path until Roundcube supports sqlite version 3.

Information on the Debian bug report can be found at http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=657092.

Migrated-From: http://trac.roundcube.net/ticket/1488332

[rcubetrac]

Comment by @alecpl on 28 Jan 2012 08:03 UTC

We're using PEAR::MDB2 package an sqlite3 must be implemented there first (http://pear.php.net/bugs/bug.php?id=6907). Another option would be to use different database abstraction, there's already a ticket for this.

[rcubetrac]

Comment by galapogos01 on 26 Apr 2012 11:51 UTC

Pear supports Sqlite 3.

http://pear.php.net/package/MDB2/download/2.4.1

[rcubetrac]

Comment by @alecpl on 26 Apr 2012 11:54 UTC

No, there's no official SQLite 3 driver for MDB2.

[rcubetrac]

Comment by @alecpl on 19 Jun 2012 09:36 UTC

There's a new branch 'pdo' in git with new DB abstraction layer supporting SQLite3.

[rcubetrac]

Milestone changed by @alecpl on 19 Jun 2012 09:36 UTC

later => 0.9-beta

[rcubetrac]

Comment by @alecpl on 8 Aug 2012 06:31 UTC

PDO-based layer merged with git master.

[rcubetrac]

Status changed by @alecpl on 8 Aug 2012 06:31 UTC

new => closed