We have been using Zope+PostgreSQL for some time. Started using PoPy, later on PyGRES and currently we run on Psycopg.
...
Question is, in your overall experience what is the best DataBase adaptor to use in Zope for PostgreSQL. ?
Well, you seem to have as much experience with the alternatives as anyone. We use Psycopg and are happy with it.
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.
Many of the products on my current project do this, or something similar. You can do it directly, or use something like http://zope.org/Members/jccooper/extzsql/ for inspiration at the very least. It does get statements from files, but I imagine it could be extended easily. --jcc -- "Code generators follow the 80/20 rule. They solve most of the problems, but not all of the problems. There are always features and edge cases that will need hand-coding. Even if code generation could build 100 percent of the application, there will still be an endless supply of boring meetings about feature design." (http://www.devx.com/java/editorial/15511)