X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 905A411F61C9 for ; Fri, 21 Apr 2006 11:49:50 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[none] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id JJk8WpndZPmA for ; Fri, 21 Apr 2006 11:49:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id 1F01011F6640 for ; Fri, 21 Apr 2006 11:49:43 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id i32so397253wra for ; Fri, 21 Apr 2006 07:49:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=I7pvSLXA0GUnQ0PtaNNAstcNLMSeXe7p26DexNQJoMPJ/G/5n8LNgZLyN70XOW0HD7q7BBN64HWLoAQrKmEjBAKlX9R4JsOk7psqYc2EVF7gbVVwsK8BlrRt8cSKOooH6sSH4laqtrH61iJaPU70HV789SIlaJvq4RLi3R2FcJw= Received: by 10.54.106.17 with SMTP id e17mr1826776wrc; Fri, 21 Apr 2006 07:49:44 -0700 (PDT) Received: by 10.54.107.7 with HTTP; Fri, 21 Apr 2006 07:49:44 -0700 (PDT) Message-ID: <330532b60604210749n79408d66ha726aa90be7e109f@mail.gmail.com> Date: Fri, 21 Apr 2006 10:49:44 -0400 From: "Mitch Pirtle" To: pgsql-php@postgresql.org Subject: Object/relational mappers for PHP? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Archive-Number: 200604/16 X-Sequence-Number: 3486 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