Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:45588 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 98628 invoked from network); 17 Sep 2009 14:14:46 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 17 Sep 2009 14:14:46 -0000 Authentication-Results: pb1.pair.com header.from=mls@pooteeweet.org; sender-id=unknown Authentication-Results: pb1.pair.com smtp.mail=mls@pooteeweet.org; spf=permerror; sender-id=unknown Received-SPF: error (pb1.pair.com: domain pooteeweet.org from 88.198.8.16 cause and error) X-PHP-List-Original-Sender: mls@pooteeweet.org X-Host-Fingerprint: 88.198.8.16 bigtime.backendmedia.com Linux 2.6 Received: from [88.198.8.16] ([88.198.8.16:40926] helo=bigtime.backendmedia.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id CA/73-13341-55442BA4 for ; Thu, 17 Sep 2009 10:14:45 -0400 Received: from localhost (unknown [127.0.0.1]) by bigtime.backendmedia.com (Postfix) with ESMTP id 94DFC4144057; Thu, 17 Sep 2009 14:15:14 +0000 (UTC) X-Virus-Scanned: amavisd-new at backendmedia.com Received: from bigtime.backendmedia.com ([127.0.0.1]) by localhost (bigtime.backendmedia.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id fQtu63XeoTdk; Thu, 17 Sep 2009 16:15:10 +0200 (CEST) Received: from [192.168.80.162] (unknown [195.226.16.50]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: mls@pooteeweet.org) by bigtime.backendmedia.com (Postfix) with ESMTP id 826574144009; Thu, 17 Sep 2009 16:15:10 +0200 (CEST) Cc: internals@lists.php.net Message-ID: To: Lester Caine In-Reply-To: <4AAF3C82.7000500@lsces.co.uk> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v936) Date: Thu, 17 Sep 2009 16:14:37 +0200 References: <4AAF3C82.7000500@lsces.co.uk> X-Mailer: Apple Mail (2.936) Subject: Re: [PHP-DEV] Status PDO drivers in general From: mls@pooteeweet.org (Lukas Kahwe Smith) On 15.09.2009, at 09:04, Lester Caine wrote: > I have no doubt that PDO works fine for many people, but since the > limited target that it had was for data abstraction IS this actually > achieved currently? Which drivers ARE fully functional, and what > outstanding bugs remain on each? The list of bugs is long, the number of people looking after them and their time is small. This is a real problem. Some things are not easily wrapped without a lot of assumptions and limitations. PDO only tried to unify the really simple stuff but make it possible to t least do the complex. However blob/clob handling is a bit unwiedly in some ways (requiring the bind API and type parameters) it does make a few things nicer (mainly returning a stream). > What is really needed is a wrapper like ADOdb that gets things under > control, rather than every project creating their own > implementation. This is the nice thing about ADOdb - it may be > 'heavy' but it 'abstracts' the data in a way PDO seems unable to do. However it does make the code necessary to handle RDBMS differences a lot smaller, thought it of course does not compete with MDB2, Doctrine or ADOdb. Anyways it all boils down to having developers care. It mostly works for MySQL and SQLite I guess. PostgreSQL has seem some love recently. IBM seems to not care anymore. Oracle certainly doesnt. Microsoft never did. A really bad situation for such a core technology. regards, Lukas Kahwe Smith mls@pooteeweet.org