There was a discussion on the Zope-DB list about this, and I vaguely remember that ZODB was really good for objects, and that's it. The debate really turned into a MySQL-vs-PostgreSQL debate, which although slightly off-topic, proved that we all agreed that ZODB was not suited for heavy data use (although we couldn't agree on the DBMS) -;^>= On Tue, 2001-10-09 at 10:52, Douwe Osinga wrote:
Hi Everyone,
It is an interesting question, when to use a relational data store and when to use ZODB. If you're data is organized in objects, ZODB is usually a lot easier. In a SQL environment you'll find you're self assembling the objects from different tables all the time. However, if you want to be able to project your data along different axes, SQL is easier. ZODB works well with strictly hierarchical data, but so well if you want your data organized in two or more different ways (ie view animals by location in the zoo, but also alphabetical or by species).
I suppose that MySQL is also better when you want to store a large amount of data, but I'm not so sure. Anybody else has an idea how far you can go with ZODB?
Douwe
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Mitch Pirtle Sent: Tuesday, October 09, 2001 09:22 AM To: Dirk Datzert Cc: zope@zope.org Subject: Re: [Zope] MySQL and/or ZODB
Hi Dirk,
ZODB is used for Zope objects (DTML, ZSQL, User Folders, etc.) and probably should not be removed... MySQL (and Postgres -;^>=) is really good for relational data, and should be used in that regard.
I would say that a good practice is using ZODB for the Zope-specific stuff, and a RDBMS for pure data.
- mitchy
On Mon, 2001-10-08 at 22:32, Dirk Datzert wrote:
Hi All,
I'm a little confused about the use of ZODB or MySQL. Can the ZODB completely removed by an MySQL database or can the MySQL database only be used for dynamic form data and the ZODB ist for more static objects like DTML-Documents or ZClasses ?
Where is a good HOWTO for removing ZODB by MySQL ?
Regards, Dirk
_______________________________________________ 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 )