Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:23591
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
To: internals@lists.php.net
Content-Type: text/plain
Date: Sat, 20 May 2006 10:48:12 -0400
Message-ID: <1148136492.17236.14.camel@localhost>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: PDO and SQLite Compatibility
From: abaker@php.net (Al Baker)

Hi,

While working on a large embedded project using PHP and SQLite, I ran
into some compatibility issues where the sqlite guys broke file
compatibility on a dot release. 

The SQLite situation is:
- SQLite 3.3.x can read and write any SQLite 3.x file
- SQLite 3.2.x cannot work with SQLite 3.3.0+ files, as they broke
compatibility between 3.2.8 and 3.3.0
- Of course, SQLite 2.x is incompatible with 3.x

The PHP situation is:
- the sqlite extension is used for Sqlite 2.x (that's fine)
- PDO's sqlite driver uses SQLite 3.2.8

This begs the question on should the PDO driver be upgraded to 3.3.x or
not, and what is the strategy for backwards compatibility.  Certainly,
upgrades will be straight forward as apps written today will have a
backwards compatible sqlite.  However downgrades (moving from sqlite
3.3.x to 3.2.x) will not work.

Are there any plans for upgrading the SQLite driver?

On a side topic: I noticed the Fedora Core 5 developers are trying to
package a PHP5.1+ RPM with an external sqlite RPM dependency.  This
doesn't appear to make any sense as their sqlite RPM is 3.3, and
upgrading the sqlite3 driver in PDO doesn't appear to be as easy as
replacing the sqlite directory under the driver, and there doesn't
appear to be anyway to compile the driver against an existing sqlite
installation (e.g. --with-pdo-sqlite=[DIR]).  

Will the PDO driver builds be updated to support this type of build
configuration?

Thanks,
Al