[Zope] Sharing Database connections and/or methods between Zo pes?
Doug Hellmann
doughellmann@bigfoot.com
Sun, 10 Jun 2001 11:48:59 -0400
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 )