RE: [Zope] Which PostGreSQL DA should I use?

2000-07-07 Thread kedai



-
> 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.

please share some hints/tips on getting it working, would you?

-- cary


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Which PostGreSQL DA should I use?

2000-07-07 Thread Oleg Broytmann

On Fri, 7 Jul 2000, Cary O'Brien wrote:
>allowing m threads, but n (nhttp://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Which PostGreSQL DA should I use?

2000-07-07 Thread Cary O'Brien

> 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 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

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Which PostGreSQL DA should I use?

2000-07-07 Thread J. Atwood

I have been using ZPyGreSQLDA on two sites (6.5.3, 7.0) for over 4 
months and besides a few glitches in the install it has been very 
stable and easy to work with (Mostly Zope's fault of course).

I have not had time to play and or benchmark what ZPoPyDA can do.

J

>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?
>
>Thanks for your time.
>

___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




Re: [Zope] Which PostGreSQL DA should I use?

2000-07-06 Thread Bak @ kedai

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 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.

> Thanks for your time.
> 
> Eric.

what are the rest using?  has anybody successfully use SQLRelay?  how 'bout a
how to? :)

thanks > 
> 
> ___
> Zope maillist  -  [EMAIL PROTECTED]
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
-- 
--
http://www.kedai.com.my/kk
Am I Evil?


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )




[Zope] Which PostGreSQL DA should I use?

2000-07-06 Thread Eric L. Walstad

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?

Thanks for your time.

Eric.


___
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )