Re: [PDO] wiki clean up and potential in person meeting

[email protected] (Lester Caine) Tue, 29 Dec 2009 12:05:55 +0000
Newsgroups php.pdo
Message-ID <[email protected]>
Matteo Beccati wrote:
>> Without a GROUP of people who are interested in developing PDO, I am of
>> the opinion that it should actually be pulled back out of the core since
>> the generic drivers ARE being developed further, but some projects ARE
>> also converting to PDO in the believe that it already provides a cross
>> database compatibility which is not really the case?
> 
> I respectfully disagree: you're just biased because you are frustrated 
> by the status of PDO_Firebird. Other drivers (SQLite, MySQL, PgSQL, OCI, 
> DB2 maybe?) work pretty well and apart from some issues (e.g. CLOBs 
> support in PDO_OCI) I still think that PDO should be core. It's 
> PDO_Firebird that should be pulled out until someone can really start 
> taking care of it.

Along with OCI and DB2? and what about MSSQL. The CLOB problem is fundamental to 
all of these databases .... if there was a way to get around it, then I might be 
able to get somewhat further on using pdo_firebird.

The oracle drive is currently suffering from the same problems as firebird, and 
it's apparently a generic problem with the way PDO has be straight jacketed to 
provide an unrealistically limited set of facilities. It is this which is 
preventing PDO being viewed currently as a complete replacement for the generic 
drivers, so rather than just stripping out more databases - should we not simply 
put PDO back into PECL until such time as it has better support?

As far as I can see, ONLY sqlite, mysql and postgresql drivers actually work to 
a level that they can be used transparently ( with some fairly major 
restrictions on the SQL ). Adding any of the other drivers requires even more 
restrictions on what can be done cross database ..... We need a base that will 
allow data types to be used transparently, rather than having to re-engineer 
databases depending on the driver being used? Having to hand write each schema 
for each driver is a major drawback.

-- 
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