Re: DB layer

Quoting Arni Arent <arni@firmanet.is>: > What is the *best* db layer there is for PHP? I've seen ADODB, PHPLIB > and I've seen some discussion about DB.php which I'm not familiar with. > > I want to be able to switch from one SQL server to another easily, and > therefor I want the db layer that supports many sql servers. Well, I don't have any experience with anything except for PEAR (DB.php) and PHPLIB. I vastly prefer PEAR's interface; it's written in a much cleaner, more OO style, and - the biggest point in my opinion - it allows multiple result sets. Also, PEAR is distributed with php4 and should become a fairly standard library of php code; if you're going to have your software depend on something, it's a good bet that users will have PEAR available. We currently have drivers in PEAR for ibase, mssql, msql, mysql, oci8, odbc, pgsql, and sybase. And it's not too complicated to write more. -chuck -- Charles Hagenbuch, <chuck@horde.org> "If you can't stand the heat, get out of the chicken!" - Baby Blues