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