[Zope] PostgreSQL data base adapters recommendation.

[Celula Research]

Hi there:

We have been using Zope+PostgreSQL for some time. Started using PoPy,
later on PyGRES and currently we run on Psycopg.

It was recently announced that PyGRES and PoPy will be merged into one
project and, this project will (actually IS) hosted within the
PostgreSQL development.

Question is, in your overall experience what is the best DataBase
adaptor to use in Zope for PostgreSQL. ?

We will start developing our application routines directly in Python as
Zope products, nevertheless, we are interested in accesing a DA
connection created directly within the Zope Management Interface, that
is,  just handling the actual SQL sentences from python sort of like
this :

  myDAConnection.query("select * from... ")

Has any of you done this ? If so, with which DA ?

We are looking into this since  handling the overall db connection, db
opening cursors, reads, db close, etc. etc. within python would add some
extra code and complexity into our application, rather than letting this
to Zope.

Any comments are welcome, thanks in advance and best regards.

Edward.