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 263F49FA621 for ; Fri, 15 Sep 2006 15:51:11 -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 26532-01 for ; Fri, 15 Sep 2006 15:51:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from druid.net (druid.net [66.96.28.249]) by postgresql.org (Postfix) with ESMTP id 3C7E39FA0FF for ; Fri, 15 Sep 2006 15:51:07 -0300 (ADT) Received: from dilbert.druid.net (H245.C18.B96.tor.eicat.ca [66.96.18.245]) by druid.net (Postfix) with SMTP id C33D9B4B4; Fri, 15 Sep 2006 14:51:08 -0400 (EDT) Date: Fri, 15 Sep 2006 14:51:40 -0400 From: "D'Arcy J.M. Cain" To: sdavis2@mail.nih.gov Cc: pgsql-interfaces@postgresql.org Subject: Re: Python interfaces Message-Id: <20060915145140.4cb86e12.darcy@druid.net> In-Reply-To: <200609151352.20668.sdavis2@mail.nih.gov> References: <200609151352.20668.sdavis2@mail.nih.gov> X-Mailer: Sylpheed version 2.2.0 (GTK+ 2.8.12; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.219 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/12 X-Sequence-Number: 6257 On Fri, 15 Sep 2006 13:52:20 -0400 Sean Davis 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/. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.