Z Object Publishing Environment

Search | Download | Documentation | Resources | Members




Join Zope.org
Log in

 Zope Exits

Zope Newbies

page served by app2

Software Product: psycopg

psycopg is a PostgreSQL database adapter for the Python programming language (just like pygresql and popy.) It was written from scratch with the aim of being very small and fast, and stable as a rock. The main advantages of psycopg are that it supports (well... *will* support) the full Python DBAPI-2.0 and being thread safe at level 2. ZPsycopgDA is a Zope Database Adapter based on psycopg and included in the psycopg package.

psycopg is different from the other database adapter because it was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a conspicuous number of concurrent INSERTs or UPDATEs. Every open Python connection keeps a pool of real (UNIX or TCP/IP) connections to the database. Every time a new cursor is created, a new connection does not need to be opened; instead one of the unused connections from the pool is used. That makes psycopg very fast in tipical client-server applications that create a servicing thread every time a client request arrives.

Contact: psycopg@lists.initd.org

Release Information

License: ZPL


psycopg-0.4.2.tar.gz () 2001/03/05
psycopg-0.4.1.tar.gz 0.4.1 (Development) 2001/03/02
psycopg-0.4.tar.gz 0.4 (Development) 2001/02/28
Privacy policy       Printable Page       Feedback to this page's author      Feedback about Zope.org