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 -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php
