[Zope] MySQL and/or ZODB

Mitch Pirtle mitchy@spacemonkeylabs.com
10 Oct 2001 12:26:46 +0200


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 )
> >
> 
>