Draft 1: In PHP 5.0, SQLite 2 support was built-in. Due to the advent of SQLite 3 and PHP Data Objects, the SQLite engine is no longer statically built into PHP by default. The PDO_SQLITE driver communicates with the SQLite 3 engine, and the sqlite extension remains in place only for reasons of back compatibility. Note that the sqlite extension is now reliant on PDO under win32. The intention is to allow support for legacy SQLite 2 code alongside newly written SQLite 3 code; the PDO, sqlite and PDO_SQLITE extensions should all be enabled.
Somewhere between Draft 1 and Draft 2, I picked up the info that you can write SQLite 2 code for PDO via DSN = sqlite2. I've no idea why anyone would want to do that, but it's there... ----- Original Message ----- From: "Wez Furlong" <[EMAIL PROTECTED]> To: "Steph Fox" <[EMAIL PROTECTED]> Cc: "internals" <internals@lists.php.net> Sent: Tuesday, November 15, 2005 4:52 PM Subject: Re: [PHP-DEV] Upgrade notes for 5.1 I wouldn't "strongly" recommend the use of PDO when upgrading; that's sending the wrong message. I'd "warmly" recommend that the use of PDO be considered for new projects. The sqlite information is wrong. This is the way it is: ext/sqlite bundles sqlite version 2. The extension provides the "good old" ext/sqlite API and also implements the 'sqlite2' driver for PDO. If you need to access SQLite version 2 databases, you need this extension. Use of sqlite version 2 should be avoided in new projects, as sqlite version 3 is vastly superior. ext/pdo_sqlite bundles sqlite version 3. It provides the 'sqlite' PDO driver. It's use is recommended for all new projects that want to use SQLite. --Wez. On 11/15/05, Steph Fox <[EMAIL PROTECTED]> wrote: > Hi all, > > I've already canvassed Ilia and Stas - can anyone else think of anything > I've missed/mis-explained here? > > Thanks guys/guyess, > > - Steph > > > -- > PHP Internals - PHP Runtime Development Mailing List > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php
