Choosing between ZODB and relational database/filesystem storage
Hi- general question... How do you know when to go with a relational database such as Mysql and when zope is ok for data storage? I am thinking of doing a product/zclass that will store contact information and related information (and either photos, or path to file system photo location) and want to be comfortable on choosing Zope for the full implementation. The traffic would not be huge...less than a few thousand visitors a day if i was lucky. Also, if Zope becomes a problem down the road...how easy is it's data to export to something which can be imported into something like mysql? -- Sean Kelley
On Tue, 22 May 2001, Sean Kelley wrote:
How do you know when to go with a relational database such as Mysql and when zope is ok for data storage?
Check out http://www.zope.org/Members/anthony/sql_vs_ZODB -Tim -- Tim Wilson | Visit Sibley online: | Check out: Henry Sibley HS | http://www.isd197.org | http://www.zope.org W. St. Paul, MN | | http://slashdot.org wilson@visi.com | <dtml-var pithy_quote> | http://linux.com
* Timothy Wilson <wilson@visi.com> [010523 03:49]:
On Tue, 22 May 2001, Sean Kelley wrote:
How do you know when to go with a relational database such as Mysql and when zope is ok for data storage?
I'd add that IMO you need a very good reason *not* to use the ZODB. I think I might start a Use ZODB campaign, in fact :) It's fast, it's stable, and it's *convenient*. Why bother with ZSQL and the administrative overheads of running an extra server when you can keep all your application needs in a single problem space? The only needs for using a RDBMS are: - _massive_ indexing requirements - when you want external access to data (e.g. ldap user database) seb.
Hi Sean, these links provide some general, theoretical information on usage of Object Databases. Have fun! http://www.databasetrends.com/99.december/12.per.thechanging.html http://www.grandus.com/info/Demo/info/database/odbms/ObjectsVSRelational.htm... Antwan. At 07:27 PM 5/22/01 -0700, you wrote:
Hi- general question...
How do you know when to go with a relational database such as Mysql and when zope is ok for data storage? I am thinking of doing a product/zclass that will store contact information and related information (and either photos, or path to file system photo location) and want to be comfortable on choosing Zope for the full implementation. The traffic would not be huge...less than a few thousand visitors a day if i was lucky.
Also, if Zope becomes a problem down the road...how easy is it's data to export to something which can be imported into something like mysql? -- Sean Kelley
_______________________________________________ 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 )
You may want to check out: http://www.zope.org/Members/pje/ZPatterns and http://www.zope.org/Members/sspickle/DumbZPatternsExample One of the neat features of ZPatterns is that you don't need to decide. I usually *start* with ZODB, then move to a relational solution only if necessary. -steve On Tuesday, May 22, 2001, at 09:27 PM, Sean Kelley wrote:
Hi- general question...
How do you know when to go with a relational database such as Mysql and when zope is ok for data storage? I am thinking of doing a product/zclass that will store contact information and related information (and either photos, or path to file system photo location) and want to be comfortable on choosing Zope for the full implementation. The traffic would not be huge...less than a few thousand visitors a day if i was lucky.
Also, if Zope becomes a problem down the road...how easy is it's data to export to something which can be imported into something like mysql? -- Sean Kelley
_______________________________________________ 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 (6)
-
Antwan Reijnen -
magnus/Websys＠websys.no -
Sean Kelley -
seb bacon -
Steve Spicklemire -
Timothy Wilson