Best PHP DAL (data abstraction layer) so far [closed]

Question

What is the best PHP DAL (data abstraction layer) so far developed under any open source project which we could re-use with good faith?

I am finding it hard to choose a DAL for my application that sufficiently supports abstraction to most common databases systems (MySQL, PostgreSQL, MSSQL, Oracle, etc) and is:

1. widely tested,
2. has good interface (readable method names, good parameter passing strategy),
3. fast,
4. lightweight,
5. providing cache (e.g integrates with Memcache or supports a good caching mechanism),
6. open-source license,
7. should have adapters for at least MySQL/MySQLi (non-PDO based)

Some of the libararies to consider:

• PHPBB DAL http://wiki.phpbb.com/Database_Abstraction_Layer
• Joomla DAL http://api.joomla.org/Joomla-Framework/Database/JDatabase.html
• ADOdb http://phplens.com/adodb/
• Zend_db
• Doctrine (downside only supports PDO_*)
• any other DAL used/developed under any open-source project/branch

Please don't consider:

• PDO
• All ORMs (however, Doctrine seems to have a separate DAL besides ORM)

Answer 1

If you can do with PHP 5.3, I would highly recommend Doctrine DAL, it's built on top of PDO, so you get the same performance plus a great API.

Update: If Doctrine is not good, you can try MDB2. It has drivers for most of the popular RDBMS, a robust API, great docs and a huge user base:

• MySQL
• MySQLi (PHP5 only)
• PostgreSQL
• Oracle
• Frontbase
• Interbase/Firebird (PHP5 only)
• MSSQL
• SQLite

Answer 2

I have been using Zend_Db for my web application for the past 1 year. I think, Zend Framework is the best by far.

Zend was started by folks who were the core contributors of PHP.(1)

widely tested

Yes. It is used by thousands of projects and has a active community of developers.

has good interface (readable method names ,good parameter passing strategy)

Yes. All Components can be easily customized to your needs. Every component in Zend is loosely coupled, meaning you can use any component without any dependency on any other component in the framework.

speed

Yes. Zend_Db using PDO, by default.

lightweight

Yes

providing cache (e.g integrates with memcache or supports a good caching mechanism)

Zend has an extensive caching system.

open-source license

Yes

To access a DB table, all you have to do, is create a class for it by setting the table name and its primary key as its fields.

class User extends Zend_Db_Table {      protected $_name = "users";  //tablename     protected $_primary = "user_key"; //primary key column      function addNewUser($name,$age,$email) {           //Validate input and add Logic to add a new user           //Methods are available to insert data like $this->insert($data)           // where $data is an array of column names and values           // Check links below for documentation     } } 

This is called a model. In this class, you can create all the methods related to 'User' entity like adding a new user, editing user etc.

In your application code, you can use this as,

$u = new User(); $u->addNewUser('Name','Age','email'); 

Must Read this - http://framework.zend.com/manual/en/zend.db.table.html

More reference here. Check this relation question for more information