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.

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

[Manuel Lemos]

Re: Pear::DB, mysqli Is is Portable?

Hello,

on 09/08/2005 03:43 PM webguynow said the following:[color=blue]
> 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[/color]

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.

[color=blue]
> 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.
>
> executeEmulateQ uery() I'm reading some code to see if this really does
> allow the DB PS API to work with MySQL4. more later ...[/color]

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