X-Original-To: pgsql-interfaces-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 77CA89FA081 for ; Fri, 15 Sep 2006 14:52:18 -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 13911-02 for ; Fri, 15 Sep 2006 14:52:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from nihrelayxway2.hub.nih.gov (mailfwd.nih.gov [128.231.90.107]) by postgresql.org (Postfix) with ESMTP id 663639FA2CA for ; Fri, 15 Sep 2006 14:52:12 -0300 (ADT) Received: from pressa.nci.nih.gov ([128.231.140.84]) by nihrelayxway2.hub.nih.gov with ESMTP; 15 Sep 2006 13:52:11 -0400 X-IronPortListener: NIH_Relay X-SBRS: None X-IronPort-AV: i="4.09,171,1157342400"; d="scan'208"; a="193698133:sNHT13340588" From: Sean Davis Reply-To: sdavis2@mail.nih.gov Organization: NIH/NCI To: pgsql-interfaces@postgresql.org Subject: Python interfaces Date: Fri, 15 Sep 2006 13:52:20 -0400 User-Agent: KMail/1.9.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200609151352.20668.sdavis2@mail.nih.gov> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.088 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200609/10 X-Sequence-Number: 6255 I am in the process of moving development from perl to python. Under perl, there was DBI, the be-all-end-all of database interfaces. Under python, there is a plethora of options. Is there a recommended one for postgres? It will be mainly used in a web environment, so the ability to work asynchronously is not that important. I am interested in maintaining database introspection (which the DB-API 2.0 is conspicuously short on) tools, as well as niceties such as automatic escape-quoting, etc, that are pretty standard in perl. Any suggestions? Thanks, Sean