MDB3 (was Re: [PEAR-DEV] Master List Package Dependencies For PHP 5/6)

Pierre wrote:

On 7/12/06, Raphaël Gertz <rapsys@free.fr> wrote: Le mardi 11 juillet 2006 20:44, Alexey Borzov a écrit: 18) MDB2 (MDB2_Driver_fbsql, MDB2_Driver_ibase, MDB2_Driver_mssql, MDB2_Driver_mysql, MDB2_Driver_mysqli, MDB2_Driver_oci8,MDB2_Driver_pgsql, MDB2_Driver_querysim, MDB2_Driver_sqlite, MDB2_Schema, Structures_DataGrid_DataSource_MDB2) 19) MIME_Type (File_Archive, Gtk2_FileDrop, Gtk_FileDrop) 20) Net_Socket (HTTP_Request, HTTP_SessionServer, Net_Cyrus, Net_Dict, Net_Finger, Net_IMAP, Net_LMTP, Net_NNTP, Net_POP3, Net_Sieve, Net_SMPP_Client, Net_SMTP) Should be deprecated? Thus, of these 31 packages 3 already have released PHP5 versions, (at least) 2 are in process and (at least) 5 are either irrelevant or deprecated. So we have about 20 packages to rewrite... Of these I think the

following

have top priority: * A new caching package * HTTP_Request2 * Log2 * MDB3 (?) * XML_Parser2 (PHP5 has some cool XML thingies, but SAX parser is still sometimes the best solution)

For me the MDB{1,2,3} should be deprecated, a better idea whould be to use (and merge) pdo to support every feature of MDB Or at least merge all supported function of db in pdo and add the port and charset(utf-8/etc) support in pdo.

Can you please get more info about what is PDO and what is MDB2 (with _Schema)? Also what can be added to PDO and what will never be added? PDO is merelly a DB wrapper, MDB2+ (schema incl.) tends to be a full abstraction layer.

PDO was intentionally left as simple as it is in terms of abstraction/emulation. Anyways the amount of input that was accepted by Wez from PEAR is small. I pointed out several flaws in their API design. All of which were ignored. There are several other internals developers that left PDO development due to the lack of cooperation. This is one of the reasons why I have not yet really embraced PDO. Another one is that PDO does not provide anything really for MDB2 users. Its slower than the native extensions in most cases. It does not provide the same features that are required to make a full MDB2 driver either. That being said, eventually PDO will become a solid foundation that would simplify the code needed to write up something like MDB3.

But keep the usefull function in MDB package (like getOne, getAll, etc...)

These are not what I find useful in MDB2 but maybe handy.

Yes those are trivial wrapper functions. Thats easy to add to PDO with less than a half day of coding. The real point of MDB2 has been to give people a solid way to work with data types, information schema and writing DDL statements in a portable way. Anyways .. MDB3 only makes sense if you deprecate MDB2 or atleast find a way to reuse all the modules in MDB3. MDB2 has so many lines of code, that I do not think we would have the necessary ressources to maintain two packages of this size (well MDB3 would have less lines of code, since PDO does handle a number of things internally, that currently MDB2 needs to deal with). So personally I would skip PHP5 and ready a successor for PHP6 in 2 years. regards, Lukas