[Zope] Sharing Database connections and/or methods between Zo pes?

[Schmidt, Allen J.]

Thanks Doug. 

We had looked at this a while ago for some other things but had not really
implemented it. Do you have to create and use only Python scripts to make it
work? If I have existing ZSQL and DTML methods, can I access them and the
data returned by them directly?

-----Original Message-----
From: Doug Hellmann [mailto:doughellmann@bigfoot.com]
Sent: Sunday, June 10, 2001 11:49 AM
To: Schmidt, Allen J.; zope@zope.org
Subject: Re: [Zope] Sharing Database connections and/or methods between
Zo pes?


Allen,

If you're still trying to share that database among multiple Zope servers, 
you should check out the XMLRPCProxy product (available on Zope.org at 
http://www.zope.org/Members/dshaw/XMLRPCProxy).  It hooks two Zope servers 
together in a way that lets you call methods of an object that lives on a 
remote server as though the object was local.

You could set up one server to host the database, and share it by passing 
your calls through the proxy.

Doug

On Tuesday 05 June 2001 13:14, Schmidt, Allen J. wrote:
> Well, with my limited Python, that is easier said than done. Something to
> shoot for though.
>
> Thanks Andy!!!
>
> Allen
>
> -----Original Message-----
> From: Andy McKay [mailto:andym@ActiveState.com]
> Sent: Tuesday, June 05, 2001 1:19 PM
> To: Schmidt, Allen J.; zope@zope.org
> Subject: Re: [Zope] Sharing Database connections and/or methods between
> Zopes?
>
>
> Here's how I would do it: Write a python script that calls your SQL and
> transfer the results into a list of dicts and returns that. You can then
> call the python script through xml-rpc and can hence parse the results.
>
> Cheers.
> --
>   Andy McKay.
>
>
> ----- Original Message -----
> From: "Schmidt, Allen J." <aschmidt@nv.cc.va.us>
> To: "'Andy McKay'" <andym@ActiveState.com>; "Schmidt, Allen J."
> <aschmidt@nv.cc.va.us>; <zope@zope.org>
> Sent: Tuesday, June 05, 2001 10:05 AM
> Subject: RE: [Zope] Sharing Database connections and/or methods between
> Zopes?
>
> > Don't even care about slow at this point! Just the functionality....
> >
> > So I can assume then that remote access of ZSQL methods is not
possible??
> >
> >
> > Seems like ZEO is the answer for everything! <8^)
> >
> > If anyone can think of a reason why this would not work, please drop a
>
> note.
>
> > If this is considered OT then jsut email me directly.
> >
> > -----Original Message-----
> > From: Andy McKay [mailto:andym@ActiveState.com]
> > Sent: Tuesday, June 05, 2001 1:09 PM
> > To: Schmidt, Allen J.; zope@zope.org
> > Subject: Re: [Zope] Sharing Database connections and/or methods between
> > Zopes?
> >
> >
> > Ah well thats the point of a database of course, is you can share it.
You
> > could concont some other solution with other stuff but you might find it
> > slow.
> >
> > This sound like a perfect job for ZEO.
> >
> > Cheers.
> > --
> >   Andy McKay.
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> 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 maillist  -  Zope@zope.org
> 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 )