Pear::DB, mysqli Is is Portable?

[webguynow]

I'm trying to build a good DB Layer on top of Pear::DB

Are there any forums or knowledge base sites on this direct topic ?

I've been using the documentation at:
http://pear.php.net/package/DB/docs
But since I'm not always online, is there a way I can download this ?

Or if the documentation is derived from the classes, How can I build
it?

related ?: If there are no public hosts supporting MySQL5 and prepared
statements, how long will we have to wait to use this functionality ?
I did see 1 host using MySQL5 -Ensim
http://www.newista.com/ensimhosting.html

I'm wondering how portable/transparent the DB platform is, expecially
if I code using alot of the prepared statement(PS) API and then end up
on a Host only supporting MySQL4.

executeEmulateQuery() I'm reading some code to see if this really does
allow the DB PS API to work with MySQL4. more later ...

[Manuel Lemos]

Hello,

on 09/08/2005 03:43 PM webguynow said the following:

related ?: If there are no public hosts supporting MySQL5 and prepared
statements, how long will we have to wait to use this functionality ?
I did see 1 host using MySQL5 -Ensim
http://www.newista.com/ensimhosting.html
You do not need to use MySQL 5 to use prepared queries. Several database
abstraction packages provide support for prepared queries even with MySQL 3.

I'm wondering how portable/transparent the DB platform is, expecially
if I code using alot of the prepared statement(PS) API and then end up
on a Host only supporting MySQL4.

executeEmulateQuery() I'm reading some code to see if this really does
allow the DB PS API to work with MySQL4. more later ...

Prepared queries are not exactly meant to provide portability. Also PEAR
DB does not provide true portability because it is not aware of
different database data types.

If you are looking for a truly portable database abstraction package,
you may want to try Metabase. It supports prepared queries even for BLOB
types. It is aware of the different data types and performs the
necessary data type conversions between PHP types and the underlying
database types. It supports the types: integer, text, date, time,
timestamp, float, decimal, binary LOBs (AKA BLOBs) and character LOBs.

http://www.phpclasses.org/metabase
--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html