Re: Database Abstraction Class
| From: | Micah Gersten | Date: | Mon, 09 Mar 2009 01:33:56 +0000 |
| Subject: | Re: Database Abstraction Class | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-289615@lists.php.net to get a copy of this message | ||
Shawn McKenzie wrote:
> Micah Gersten wrote:
>> Michael A. Peters wrote:
>>
>>> Anywhoo, that being said, does anyone have a suggestion for a good
>>> database abstraction class?
>>>
>>> Preferably one that already has decent support for several open source
>>> databases?
>> Try Doctrine:
>> http://www.doctrine-project.org/
>>
>> From the website:
>> What is Doctrine?
>> Doctrine is an object relational mapper (ORM) for PHP 5.2.3+ that sits
>> on top of a powerful database abstraction layer (DBAL). One of its key
>> features is the option to write database queries in a proprietary object
>> oriented SQL dialect called Doctrine Query Language (DQL), inspired by
>> Hibernates HQL. This provides developers with a powerful alternative to
>> SQL that maintains flexibility without requiring unnecessary code
>> duplication.
>>
>
> Wow, a proprietary language that I get to learn on top of the two that
> do the job and that I already know! Bonus!
>
> Not trying to be an ass, I haven't used doctrine, but they need some
> marketing help. My point is that the ability to write queries in a
> "proprietary dialect" is not really a "feature".
>
I think the point is, that you can use a DB engine neutral query
language which improves portability.
--
Micah