Re: [PDO] Asynchronous requests

[email protected] (Lester Caine) Tue, 03 Nov 2009 13:25:17 +0000
Newsgroups php.pdo
Message-ID <[email protected]>
Lukas Kahwe Smith wrote:
> 
> On 03.11.2009, at 11:49, Johannes Schlüter wrote:
> 
>> And even then PDO should be generic and do stuff the same way with as
>> many drivers as possible. That's the point of abstraction. Different
>> databases, client-server protocols, client libraries, ... offer
>> different functionality which sometimes can't be emulated properly. The
>> aim of abstraction is that I can - as simple as possible - switch over
>> from one database to another, now consider having use async switching
>> from psotgresql to sqlite (for whatever reason) - you have to change the
>> whole architecture[1].
> 
> I am still not clear what you mean here. Do you think its impossible to 
> abstract async? or do you want to limit PDO to functionality that is 
> available on all drivers?

Part of the current problems with PDO relate more to how it is used 
rather than PDO itself. But the presence of driver specific stuff in one 
or other drivers - while possibly useful - then causes problems when 
porting between databases and finding that the original use of PDO is 
actually driver specific. Taking an ADOdb application and switching 
databases will flag differences, but allows many things to work because 
they have been abstracted, but currently trying to do the same with PDO 
is a major problem simply because there is no easy way to flag - 'driver 
does not support this' ?

If something is added for a specific driver, then there needs to be a 
core function that provides the abstraction and says 'not available' or 
alternatively provides an alternative solution to the function.

Most databases will allow metadata to be viewed, but via different 
routes, but the core needs to have an agreed standard, and map things 
that are not part of the standard to the base standard.

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php