Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:20009 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 23233 invoked by uid 1010); 15 Nov 2005 17:02:59 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 23214 invoked from network); 15 Nov 2005 17:02:59 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 15 Nov 2005 17:02:59 -0000 X-Host-Fingerprint: 192.38.9.232 gw2.emini.dk Linux 2.4/2.6 Received: from ([192.38.9.232:9213] helo=gw2.emini.dk) by pb1.pair.com (ecelerity 2.0 beta r(6323M)) with SMTP id 85/70-07637-0C41A734 for ; Tue, 15 Nov 2005 12:02:57 -0500 Received: from foxbox (client-349-p-2-lns.glfd.dial.virgin.net [81.101.65.92]) by gw2.emini.dk (Postfix) with ESMTP id 62BCE8EA0F; Tue, 15 Nov 2005 18:02:49 +0100 (CET) Message-ID: <0ab001c5ea06$6277aa00$52906751@foxbox> Reply-To: "Steph Fox" To: "Wez Furlong" Cc: "internals" References: <099001c5ea00$3eecc0d0$52906751@foxbox> <4e89b4260511150852p2de5dd76h105b0aaa77f2f6f2@mail.gmail.com> Date: Tue, 15 Nov 2005 17:02:37 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Subject: Re: [PHP-DEV] Upgrade notes for 5.1 From: steph@zend.com ("Steph Fox") 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" To: "Steph Fox" Cc: "internals" 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 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