New PostgreSQL Database Adapters: psycopg and ZpsycopgDA

Federico Di Gregorio fog@mixadlive.com
Wed, 28 Feb 2001 13:31:44 +0100


Hi *,

	the guys here at initd (http://initd.org/) arre happy to announce
the release of psycopg, a Python/PostgreSQL driver module and ZPsycopgDA, 
a Zope Database Adapter based on the psycopg driver. 

Now, I'll answer the questions you asked... (_what_ questions? well... 
follow me...)

Q. Why another postgresql dba? we already have pygres and popy!

A. That's true. We had some ideas about a performant, thread-safe
   driver and we wanted to hack a little bit. the resulting driver is
   slim, fast, with clean code and some nice features (see below.)
   Writing a Zope DBA was a logical consequence only because we use it.

Q. Should I switch to psycopg and zpsycopgda?

A. Not if you are happy with your current driver [and i hope it is popy ;-)]
   The only real reason is if you want the advanced features you can find
   only in psycopg:

       1/ level-2 thread safety
       2/ advanced type-casting system
       3/ automatic management of multiple phisical connections to the DB
          (one per thread) to speed up queries
       4/ extremely clean and maintainable code
   
   also, in a future release (0.5) zpsycopgda will support db and table 
   management from zope management screens.

Q. Hey! you're from MIXAD LIVE, is psycopg a popy fork?

A. No, psycopg is 100% clean code. we had some ideas on how a db driver
   should workin a heavily multithreaded environment and we wanted to
   test them. that's all.

Q. Where can I download it?
A. http://initd.org/Software/psycopg (tarball and precompiled debian packages)


ciao and good hacking,
federico

-- 
Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
  Qu'est ce que la folie? Juste un sentiment de liberté si
   fort qu'on en oublie ce qui nous rattache au monde... -- J. de Loctra