DB abstraction library like codeigniter

Question

Does any one know of a light weight DB abstraction library like the one codeigniter has. I had a look at Pear:MDB but its not what I am looking for.

I am looking for chaining features. For eg:

$this->db->get_where('table_name', 'condition')->row()->'column_name' ;

This makes syntax very compact.

TIA,

NB : I am not at all looking for an ORM as might be inferred from the discussion or otherwise.

Answer 1

If you need external libraries, then these are very good:

1) http://adodb.sourceforge.net/

2) http://www.doctrine-project.org/projects/dbal

3) http://www.phpclasses.org/package/4222-PHP-SQL-database-abstraction-layer.html

4) http://www.phpclasses.org/package/3915-PHP-Database-abstraction-layer-similar-to-PDO.html

Answer 2

doctrine and propel(http://www.propelorm.org/) are my favorites both competing to be leading orms.

personally I'd prefer propel if you do not need doctrine:migrations(particularly if you don't need to version your database)

still keep in mind u'll need versioning one day, so it might be convenient to start with doctrine.

Answer 3

One more to the list:

https://open-mv.googlecode.com/svn/trunk/classes/database/