Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:14769
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Message-ID: <20050209185753.53439.qmail@lists.php.net>
To: internals@lists.php.net
Date: Wed, 09 Feb 2005 19:02:31 +0000
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040803
MIME-Version: 1.0
References: <4e89b42605020821554c1ba198@mail.gmail.com>	<20050209083714.12464.qmail@lists.php.net>	<4e89b42605020907043c839b71@mail.gmail.com>	<20050209162402.13541.qmail@lists.php.net>	<4e89b42605020908416598396f@mail.gmail.com>	<420A4557.7060509@lsces.co.uk> <4e89b42605020909254ee032f4@mail.gmail.com>
In-Reply-To: <4e89b42605020909254ee032f4@mail.gmail.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] Re: [PECL-DEV] Re: Announce: PDO beta releases
From: lester@lsces.co.uk (Lester Caine)

Wez Furlong wrote:

> One of the major aims of PDO is to eventually replace the existing
> database extensions in PHP, not to provide total abstraction (which is
> a impossible goal in the opinions of many seasoned developers).

Have not found a problem building cross database packages. As long as 
you avoid STARTING from MySQL, then most things can be transparent. It 
would be nice to link in 'Triggers' but until the other engines support 
them properly ...
Total abstraction does require removing some of the inconsistencies in 
SQL, but it is certainly not impossible. It MAY be 'expensive' in terms 
of processing time, but that is the trade off between single engine code 
and generic anyway.

Lukas - I see little point in trying to get LIMIT into Oracle until the 
preferred method of working is included in SQL2003. MSSQL would need 
convincing to change it as well, but I prefer the more natural SELECT 
FIRST n SKIP x. So LIMIT n OFFSET x is not a 'done deal' ;)
There are a lot more subtle variations which cause a lot more problems 
than that anyway :)

-- 
Lester Caine
-----------------------------
L.S.Caine Electronic Services