[DB-SIG] psycopg 1.0

Federico Di Gregorio fog@debian.org
14 Nov 2001 02:20:08 +0100

Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

hi *,

i don't usually send announces of psycopg releases to this list, but
this one... well, is 1.0 after all. i'll have some more time in the
future and i hope to follow shortly with the announce of the dbapi test
suite; i am moving that project out of psycopg and switch to use the
default python test classes (too late now to remember the name.) anyway,
if anybody is interested just drop me a note.

and now...

hi everybody and welcome to psycopg 1.0,

after eight months of work Michele and Federico are pleased to release
the 1.0 version of the psycopg Python/PostgreSQL/Zope database
driver. previous releases (especially the 0.99.x series) were already
stable for a lot of people but only now, after plugging every memleak,
after fixing every segfault, after scratching every itch, psycopg is
absolutely ready for the one-dot-oh release. applause, please... :)

psycopg can be downloaded from:


have fun,

what you get with psycopg 1.0

* very fast python/posgresql database driver, optimized for heavy
  multithreaded applications (very fast means that several people have=20
  reported many-fold speedups when switching to psycopg, and in real=20
  world situations, not benchmarks);

* stability. a lot of people have run with it for weeks without a single
  problem. unplug the database or kill the connection, psycopg will just
  raise an exception, rollback and go back to work.

* complete (and we mean 100% complete) DBAPI 2.0 compliance;

* DBAPI extensions: per-cursor commits, isolated cursors, user-defined
  typecast objects (postgresql->python), lastoid() function and other

* complete translation of postgresql date, time, timestamp and
  interval types to eGenix (http://www.egenix.com/) mx DateTime and=20
  DateTimeDelta objects.

* Zope database adapter (ZpsycopgDA);

* stability (have I already said that?)

what is missing from 1.0

* documentation: we are working on two guides, one about DBAPI 2.0
  programming and one about psycopg itself. both will be released in a
  future psycopg release.

* regression test: much needed to be sure the development branch does
  not remove features or introduce new bugs.

* how zpsycopgda should treat intervals is still dubious. until we
  make a decision you'll get strings if using Zope's DatTime or
  DateTimeDelta objects if using mx's.

Federico Di Gregorio
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
INIT.D Developer                                           fog@initd.org
  99.99999999999999999999% still isn't 100% but sometimes suffice. -- Me

Content-Type: application/pgp-signature

Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org