> 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.
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -