Which is the BEST database abstraction layer?

[Anon]

This is simple. Which is the best? I want the abstraction layer to work with all databases, have excellent handling and reliability.

It should be able to take care of stuff like Oracle not having a LIMIT clause, etc.

Any thoughts?

[Anon]

You can use either PHPLIB or PEAR's Database Abstration Layer.

I don't know how mature PEAR'S DB Layers is but I have used PHPLIB's for Sybase and MySQL and everything has worked great so far.

These Database Abstractions Layers do NOT however automatically change you SQL Statement to fit a certain database.

These DB Layers only wraps the database functions. For example you call $db->query("select foo from bar") instead of database specific functions.

[Anon]

Good question...I know of severaL already PHPdb, PEAR, PHPLIB, or even something like ADODB stuff from

http://php.weblogs.com

Actually, I quite like the last one..(weblogs) because of its neatness but my favorite is PHPDB...I dont remember the link off the bat, but pls send me an email and I could send you a ZIP file (it has copyright and all that info in it, so I dont need to bother I hope).

</Shanx>