RE: [Zope] Sharing Database connections and/or methods between Zo pes?
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 )
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 )
participants (2)
-
Doug Hellmann -
Schmidt, Allen J.