I should not be answering questions on this list because this is the place where the Zope core developers talk to each other, and I only started working with Zope 3 as a user a few weeks ago. However, as this question sometimes comes up on the Zope 2 lists and last night I installed MySQL and had it working with Zope 3, all in less than half an hour:

If you want to use relational data, use a relational database to store the data. It is very easy to access and manage such data from Zope. Adapters are available for Zope 3 to MySQL and Postgres. I use Oracle with Zope 2 and I guess an Oracle adapter will be available for Zope 3 soon, others too.


Achim Domma (Procoders) wrote:

I'm evaluating ZOPE for some projects we might have to implement. ZODB looks very nice for storing object hierarchies but I don't understand how to store relational data.

For example, f I store people and qualified realations between them, I usally have a table 'person' which hold the person records, 'relation_type' which hold the possible relations and 'person_person_relation' which holds the ids of the related persons and the id of the type of the relation.

I don't see how I would store something like this in ZODB and I want to understand if it's better to stick with a relational database for such a case. Or is there a solution, which I might not see at the moment?

This should be no criticism, I only want to understand what Zope is good for and where something else might suite my needs better.


Zope3-dev mailing list
Unsub: http://mail.zope.org/mailman/options/zope3-dev/cliff.ford%40ed.ac.uk

Zope3-dev mailing list
Unsub: http://mail.zope.org/mailman/options/zope3-dev/archive%40mail-archive.com

Reply via email to