New PostgreSQL Database Adapters: psycopg and ZpsycopgDA
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
Do you have any plans to get psycopg to work on Win32? On Wed, Feb 28, 2001 at 01:31:44PM +0100, Federico Di Gregorio wrote:
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.
-- Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
Scavenging the mail folder uncovered Fred Yankowski's letter:
Do you have any plans to get psycopg to work on Win32?
we don't use any win32 machine. while we will be glad to accept patches, we won't fix any win32-related bug ourselves (we can't!) or make a worse program only to be compatible with a non-free OS. sorry, federico
On Wed, Feb 28, 2001 at 01:31:44PM +0100, Federico Di Gregorio wrote:
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.
-- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog@mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog@debian.org Put a GNOME on your desktop! [http://www.gnome.org] -- brought to you by One Line Spam
participants (2)
-
Federico Di Gregorio -
Fred Yankowski