[Zope] PostgreSQL data base adapters recommendation.

[Jerry Westrick]

I use the the ODBC connector
to access the postgres database....

I've  lisenced the EGenix version
although I doun't know if this was necesary,
I simply didn't have the time to investigate
the alternatives...

It's worked as advertised.


Jerry


On Tue, 2003-09-02 at 04:01, Celula Research wrote:
> 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.
> 
> 
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>