LEAD UP: I've got a site that I need to develop and it's a natural and obvious decision that I use zope and plone as they are what I'm familiar with and what I prefer to other CMS/Portal-wares out there. The site will have several counter parts around the globe being administered by various individuals, not all of whom are enlightened enough to realize the folly of using anything other than zope. MEAT OF THE ISSUE: The sites will be tracking dance clubs. We'll be building Types in plone (Using Archetypes) to track information about clubs locally. Each site will potentially have different database technology from the other sites. I know of 3 admins who are planning on using PHP-* + MySQL and a few others who want to use Postgress and some other front end. We want to be able to integrate the information from any one site into any other site with respect to the "club objects" in the disparate databases. I'd like to leverage the simplicity of zope's application/database model and not use SQL storage if possible but don't know how I can be able to "share" with my counterparts who are bent on using relational databases. We do not intend to leave open connections to each other's database servers. The consensus is to do scheduled dumps and push the files to the other admins who would have their own routines for integrating the data into their site. I really don't want to have to set up an SQL server. Any help/suggestions would be greatly appreciated. --Cliff
Not a zope question, but... why don't you create a mutually agreed upon XML DTD (document type definition) that represents the content of a database record. Then each party can implement the XML data extraction/upload to their own db technology as they please. Each db operator will send/receive data in the agreed upon XML format (that's what its for!). Jonathan ----- Original Message ----- From: "Cliff Williams" <gcw-python@rezidew.net> To: <zope@zope.org> Sent: Wednesday, January 25, 2006 11:23 AM Subject: [Zope] zodb queries, importing and exporting
LEAD UP: I've got a site that I need to develop and it's a natural and obvious decision that I use zope and plone as they are what I'm familiar with and what I prefer to other CMS/Portal-wares out there. The site will have several counter parts around the globe being administered by various individuals, not all of whom are enlightened enough to realize the folly of using anything other than zope.
MEAT OF THE ISSUE: The sites will be tracking dance clubs. We'll be building Types in plone (Using Archetypes) to track information about clubs locally. Each site will potentially have different database technology from the other sites. I know of 3 admins who are planning on using PHP-* + MySQL and a few others who want to use Postgress and some other front end.
We want to be able to integrate the information from any one site into any other site with respect to the "club objects" in the disparate databases. I'd like to leverage the simplicity of zope's application/database model and not use SQL storage if possible but don't know how I can be able to "share" with my counterparts who are bent on using relational databases.
We do not intend to leave open connections to each other's database servers. The consensus is to do scheduled dumps and push the files to the other admins who would have their own routines for integrating the data into their site. I really don't want to have to set up an SQL server.
Any help/suggestions would be greatly appreciated.
--Cliff
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Jonathan wrote:
Not a zope question, but... why don't you create a mutually agreed upon XML DTD (document type definition) that represents the content of a database record. Then each party can implement the XML data extraction/upload to their own db technology as they please.
Each db operator will send/receive data in the agreed upon XML format (that's what its for!).
If you use ATXML (see the Marshall product) you can even marshall/demarshall the files directly to/from your objects via FTP/WebDAV. No intermediate representation. --jcc
----- Original Message ----- From: "Cliff Williams" <gcw-python@rezidew.net> To: <zope@zope.org> Sent: Wednesday, January 25, 2006 11:23 AM Subject: [Zope] zodb queries, importing and exporting
LEAD UP: I've got a site that I need to develop and it's a natural and obvious decision that I use zope and plone as they are what I'm familiar with and what I prefer to other CMS/Portal-wares out there. The site will have several counter parts around the globe being administered by various individuals, not all of whom are enlightened enough to realize the folly of using anything other than zope.
MEAT OF THE ISSUE: The sites will be tracking dance clubs. We'll be building Types in plone (Using Archetypes) to track information about clubs locally. Each site will potentially have different database technology from the other sites. I know of 3 admins who are planning on using PHP-* + MySQL and a few others who want to use Postgress and some other front end.
We want to be able to integrate the information from any one site into any other site with respect to the "club objects" in the disparate databases. I'd like to leverage the simplicity of zope's application/database model and not use SQL storage if possible but don't know how I can be able to "share" with my counterparts who are bent on using relational databases.
We do not intend to leave open connections to each other's database servers. The consensus is to do scheduled dumps and push the files to the other admins who would have their own routines for integrating the data into their site. I really don't want to have to set up an SQL server.
Any help/suggestions would be greatly appreciated.
--Cliff
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- "Building Websites with Plone" http://plonebook.packtpub.com/ Enfold Systems, LLC http://www.enfoldsystems.com
Cliff Williams wrote at 2006-1-25 10:23 -0600:
... We want to be able to integrate the information from any one site into any other site with respect to the "club objects" in the disparate databases. I'd like to leverage the simplicity of zope's application/database model and not use SQL storage if possible but don't know how I can be able to "share" with my counterparts who are bent on using relational databases.
Many sites use RSS to exchange summary information about their objects. RSS entries contain URLs for the detail view. -- Dieter
participants (4)
-
Cliff Williams -
Dieter Maurer -
J Cameron Cooper -
Jonathan