[Zope] Which PostGreSQL DA should I use?

Cary O'Brien cobrien@Radix.Net
Fri, 7 Jul 2000 08:25:54 -0400 (EDT)


> On Fri, 07 Jul 2000, Eric L. Walstad wrote:
> > OK, I am thinking about going from MySQL to PostgreSQL for its transactions
> > and subqueries.  I am curious which DA I should use and why.  I see that I
> > can choose from:
> > 
> > 1. SQLRelay
> > 2. ZPoPyDA
> > 3. ZPyGreSQLDA
> > 
> > Which are you using and why did you choose it over the others?
> > 
> i have been asking the same Q too.  i am current;y using ZPygreSQLDa, and have
> been from the start.  i think there's no more development done on this  DA (
> imight be wrong though).
> 

I wish there was.  For ZPyGreSQL, I would really like to see:

	1) Thread-safe operation.  I.e., if desired, one database
           connection per thread.  Or better yet a pool of connections,
           allowing m threads, but n (n<m) concurrent PostgreSQL queries.

	2) A bit of introspection, i.e. showing the tables and columns.
 	   We're getting people who simply can't handle a command line,
	   so they can't really run psql in a separate terminal window.
	   Gadfly DA does this.

Any hints/takers.  I've looked over ZPyGreSQL pretty carefully -- it isn't
all that big.

> i wanted to try PoPy, but the last time i checked, i can't get the PoPy tar
> ball.  this is actively maintained, i think
> 
> SQLRelay, i have compiled and installed, but i can't figure out how to use it. 
> i cant start the listener without an error.( can't bind something).  and i'm
> not too sure how how the connect string looks like if i have a user with no
> password.  but i think this may be the best solution, since we can specify the
> connection pool, and have a cache for results too.
> 

Interesting.  Gotta look into this.

-- cary