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