X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8771D11F65AD for ; Wed, 26 Apr 2006 21:52:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19628-09 for ; Wed, 26 Apr 2006 21:52:39 -0300 (ADT) X-Greylist: delayed 00:31:49.832415 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7939111F6282 for ; Wed, 26 Apr 2006 21:52:37 -0300 (ADT) Received: from intranet.squiz.net (extranet.squiz.net [203.222.154.144]) by svr4.postgresql.org (Postfix) with ESMTP id 0C4335B3165 for ; Thu, 27 Apr 2006 00:20:47 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by intranet.squiz.net (Postfix) with ESMTP id 3518A60AC4; Thu, 27 Apr 2006 10:20:41 +1000 (EST) Received: from intranet.squiz.net ([127.0.0.1]) by localhost (intranet [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08337-10; Thu, 27 Apr 2006 10:20:41 +1000 (EST) Received: from [192.168.0.116] (unknown [192.168.0.116]) by intranet.squiz.net (Postfix) with ESMTP id 0DFDB60AC2; Thu, 27 Apr 2006 10:20:41 +1000 (EST) Message-ID: <44500E58.2060007@squiz.net> Date: Thu, 27 Apr 2006 10:20:40 +1000 From: Marc McIntyre User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mitch Pirtle Cc: pgsql-php@postgresql.org Subject: Re: Object/relational mappers for PHP? References: <330532b60604210749n79408d66ha726aa90be7e109f@mail.gmail.com> In-Reply-To: <330532b60604210749n79408d66ha726aa90be7e109f@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at squiz.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/19 X-Sequence-Number: 3489 Propel is a PHP 5 ORM, based on Apache Torque. http://propel.tigris.org/ Mitch Pirtle wrote: >Hi gang, > >We finally have the underpinnings for database drivers in Joomla 1.5, >and now are tackling the thorny issue of all those MySQL-specific SQL >statements littering the core. > >One solution of course is to use Christopher Kings-Lynne's(sp?) MySQL >compatibility goodies, but we are also looking to solve this riddle at >the application layer so we can support more databases in the future. > >We have implemented some basic SQL generating methods in our database >class (to manage LIMIT and LEFT JOIN differences, for example) but are >primarily relying on ANSI SQL to get around most issues. > >I'd like to know if anyone here is already working on a class to >generate SQL at the object level, as opposed to (re)inventing your own >API to generate queries for each database engine. > >Anybody else working on something? > >-- >Mitch Pirtle >Joomla! Core Developer >Open Source Matters > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend > > >