Posted by Manuel Lemos on 09/09/05 05:03

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

[Back to original message]