Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Pear::DB, mysqli Is is Portable?
September 8, 2005, 6:43 pm
rate this thread
Are there any forums or knowledge base sites on this direct topic ?
I've been using the documentation at:
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
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
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 ...
Re: Pear::DB, mysqli Is is Portable?
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
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.
PHP Classes - Free ready to use OOP components written in PHP
PHP Reviews - Reviews of PHP books and other products
Metastorage - Data object relational mapping layer generator