Best PHP DB Abstraction layer?

From: Mike Harrison 
------------------------------------------------------

It's a religious question, I know
but if I were to pick a PHP database abstraction connection layer..
Which one actually works in the real world?

I'm looking at: 
http://www.php.net/manual/en/refs.database.abstract.php
http://www.greaterscope.net/documentation/php

=============================================================== From: Dave Brockman ------------------------------------------------------ -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

=============================================================== From: Rip Linton ------------------------------------------------------ I use PEAR MDB2 from here: http://pear.php.net/package/MDB2 and have not r= un into any tasks that I could not accomplish with it. I work with a mix of= MSSQL, MySQL, Postgresql, Firebird and some others on occasion. Works grea= t with any ODBC databases. The documentation is very good and the learning curve seems to be short if = you have any experience with other abstractions. I first started using it because I needed to map some data sources that spa= nned several DBs on different servers and using different databases. I coul= d not find anything else that would map the connections and relationships p= roperly on mixed systems. I wrote one with PEAR and had the job finished 48= hours after I installed the MDB2 packages. =20 =20 -----Original Message----- From: Mike Harrison To: chugalug Sent: Tue, Feb 26, 2013 9:06 pm Subject: [Chugalug] Best PHP DB Abstraction layer? It's a religious question, I know but if I were to pick a PHP database abstraction connection layer.. Which one actually works in the real world? I'm looking at:=20 http://www.php.net/manual/en/refs.database.abstract.php http://www.greaterscope.net/documentation/php

=============================================================== From: Jason Brown ------------------------------------------------------ +1000 for Doctrine: http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/index.html --Jason

=============================================================== From: Mike Harrison ------------------------------------------------------ Ok. I'll admit that it's first time I've really looked hard at Doctrine. It's lines like: ..."it provides the access point to the complete lifecycle management of your entities and transforms entities from and back to persistence".. and the abstraction of what is really going in their examples like: $bugs = $entityManager->getRepository('Bug')->findBy(array('status' => 'CLOSED')); Which to me is something like: "select * from Bug where status = 'CLOSED'" that makes my head spin and hackles raised. Too abstract for me. If I were building something big, it might be worth the cognitive load, but I think PDO might be closer to what I was looking for. What I have now is similar functions for MySQL and Oracle10/11 I'll see if I can get PDO to talk to the Oracle system.. I'm using OCI now.

=============================================================== From: Lisa Ridley ------------------------------------------------------ +1 Doctrine too Lisa Ridley lhridley@gmail.com http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/index.htm= l http://www.php.net/manual/en/refs.database.abstract.php http://www.greaterscope.net/documentation/php

=============================================================== From: Micah Breedlove ------------------------------------------------------ +1 Doctrine

=============================================================== From: Ed King ------------------------------------------------------ Never even heard of Doctrine until this thread came up, now I have been in-= Doctrine-nated.=A0=A0=A0 Behold the power of Chugalug and users-helping-use= rs.=A0=A0 Thanks :)=20 --- On Thu, 2/28/13, Micah Breedlove wrote: From: Micah Breedlove Subject: Re: [Chugalug] Best PHP DB Abstraction layer? To: "Chattanooga Unix Gnu Android Linux Users Group" Date: Thursday, February 28, 2013, 9:57 AM +1 Doctrine=A0 =0A=0A+1 Doctrine too =0A=0A=0ALisa Ridleylhridley@gmail.com =0A=0A +1000 for Doctrine: http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/index.html =0A=0A --Jason It's a religious question, I know but if I were to pick a PHP database abstraction connection layer.. =0A=0AWhich one actually works in the real world? I'm looking at: http://www.php.net/manual/en/refs.database.abstract.php =0A=0Ahttp://www.greaterscope.net/documentation/php