Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id AE786634739 for ; Fri, 22 May 2009 07:33:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91250-02 for ; Fri, 22 May 2009 07:33:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from relay.pcl-ipout01.plus.net (relay.pcl-ipout01.plus.net [212.159.7.99]) by mail.postgresql.org (Postfix) with ESMTP id 898CA6346BC for ; Fri, 22 May 2009 07:33:39 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApoEADwcFkrUnw6T/2dsb2JhbADSDYQLBQ Received: from ptb-relay03.plus.net ([212.159.14.147]) by relay.pcl-ipout01.plus.net with ESMTP; 22 May 2009 11:33:37 +0100 Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay03.plus.net with esmtp (Exim) id 1M7S4G-0003GU-L8; Fri, 22 May 2009 11:33:36 +0100 Received: from dell36.office.archonet.com (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id E203C274058; Fri, 22 May 2009 11:33:35 +0100 (BST) Message-ID: <4A167F7F.6000509@archonet.com> Date: Fri, 22 May 2009 11:33:35 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.21 (X11/20090320) MIME-Version: 1.0 To: Frank Joerdens CC: pgsql-sql@postgresql.org, Nic Ferrier , Edward George , Seb Potter , Hannu Krosing Subject: Re: Make the planner smarter about idiosyncratic (or broken) ORM behaviour References: <7d10d2df0905220233v3e54ab34lb9c3530fe3543a5c@mail.gmail.com> <4A1676E1.6010102@archonet.com> <7d10d2df0905220318w3e69e112v42eee46b88d9f284@mail.gmail.com> In-Reply-To: <7d10d2df0905220318w3e69e112v42eee46b88d9f284@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 72f590e0637d008f4e9f6c0404f5e620 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200905/90 X-Sequence-Number: 32582 Frank Joerdens wrote: > On Fri, May 22, 2009 at 10:56 AM, Richard Huxton wrote: > [...] >> Are you sure it wouldn't be easier to hire a Python guru for a couple of >> days and have him/her hack the ORM to make it less, um, "simplistic"? > > Not sure. :) Your arguments make eminent sense to me. I am not exactly > a fan of ORMs, they make my job much harder ... but there seems to be > no avoiding them these days. I either like: 1. Really simple, clean ORM but makes it simple to override with custom SQL when you need to. 2. Very clever, sophisticated ORM but makes it simple to override with custom SQL when you need to. Unfortunately I'm not a Python guy so I can't comment on Django's ORM. -- Richard Huxton Archonet Ltd