Re: some MDB2 questions

Andreas Korthaus wrote:

Lukas Smith wrote:

$stmt->bindParam(':foo', $bar);

As for the bindParam(). Look here: http://de.php.net/manual/en/function.pdostatement-bindparam.php

Thanks but I meant ':'...

Neither do I: http://marc.theaimsgroup.com/?t=110802989700003&r=1&w=2 Feel free to comment that post on pecl-dev.

Do you know which drivers of MDB2 are used in production by now?

I am using MySQL in production. I have an older project that uses a very old version of the Oracle driver. Aside from that I think Lorenzo is using the ibase driver in production. And I think a few people are using the postgresql driver in production. Aside from that I am quite confident that the sqlite driver is quite stable too.

I like that MDB2 API will be in sync with PDO. In which parts of the MDB2 API do you expect changes before stable release?

The stuff I mentioned before and alot of little details. For example I dont require the ":" in bindParam() ... yet.

In future I would like to use PDO and only a very, very thin SQL-abstraction layer above. As I can see for now, I only need numRows(), LIMIT-abstraction, sequences and autoExecute() in such a layer, everything(!) else is provided by PDO! numRows() seems to be the most difficult one, because I cannot use the native functions since they are not provided bei PDO. Perhaps it must be done the way you suggested above, using query(). Also if I would implement all the functions provided by MDB2 (not Metadata/DDL... this I would like to use as an extra package, which is in sync), isn't MDB2 itself to heavy for use with PDO? Because mdb2.php itself implements a lot of things which are implemented by PDO, too! Perhaps one could create such a thin abstraction based on MDB2 (also same API) which uses PDO and PHP5 as efficient as possible as PEAR::DB2, and the metadata-part of MDB2 as PEAR::DB2_Manager... Only some thoughts... I think I'd like to work on something like that... ;-)

Thats the plan for 2006. Now the goal is to provide a PHP4/PHP5 PDO compatible API. Drivers will be based on both the old extensions as well as PDO. In terms of speed those PDO drivers will probably be quite fast, especially if you use a bytecode cache. http://sourceforge.net/mailarchive/message.php?msg_id=10269486 regards, Lukas regards, Lukas