X-Original-To: pgsql-interfaces-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 2EF289FA3B1 for ; Mon, 18 Sep 2006 07:03:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 26427-08 for ; Mon, 18 Sep 2006 10:03:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 569C19FA100 for ; Mon, 18 Sep 2006 07:03:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from lambchop.rdu.rpath.com (rdu-nat.rpath.com [66.192.95.194]) by svr4.postgresql.org (Postfix) with ESMTP id 0D9395AF5CE for ; Mon, 18 Sep 2006 10:03:27 +0000 (GMT) Received: from alienpad.rpath.com (gafton.rdu-vpn.rpath.com [172.16.65.33]) by lambchop.rdu.rpath.com (8.13.6/8.13.4) with ESMTP id k8IA2uxK017682 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 18 Sep 2006 06:03:00 -0400 Received: from alienpad.rpath.com (alienpad.rpath.com [127.0.0.1]) by alienpad.rpath.com (8.13.7/8.13.7) with ESMTP id k8IA2s7v016655; Mon, 18 Sep 2006 06:02:55 -0400 Received: from localhost (gafton@localhost) by alienpad.rpath.com (8.13.7/8.13.7/Submit) with ESMTP id k8IA2rM2016652; Mon, 18 Sep 2006 06:02:53 -0400 X-Authentication-Warning: alienpad.rpath.com: gafton owned process doing -bs Date: Mon, 18 Sep 2006 06:02:52 -0400 (EDT) From: Cristian Gafton To: pgsql-interfaces@postgresql.org Cc: sdavis2@mail.nih.gov Subject: Re: Python interfaces In-Reply-To: <20060915145140.4cb86e12.darcy@druid.net> Message-ID: References: <200609151352.20668.sdavis2@mail.nih.gov> <20060915145140.4cb86e12.darcy@druid.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/16 X-Sequence-Number: 6261 On Fri, 15 Sep 2006, D'Arcy J.M. Cain wrote: >> 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? > > I maintain PyGreSQL which used to be the one shipped with PostgreSQL > before we split it off into a separate project. http://PyGreSQL.org/. I maintain a further split from PyGreSQL that supports native bind parameters and prepared statements at: http://cheeseshop.python.org/pypi/python-pgsql (using bind parameters eliminates many worries about escape quoting...) Cristian -- Cristian Gafton rPath, Inc.