Re: [Zope3-dev] relational data

[Cliff Ford]

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.

Cliff
Achim Domma (Procoders) wrote:
Hi,
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.

regards,
Achim
_______________________________________________
Zope3-dev mailing list
Zope3-dev@zope.org
Unsub: http://mail.zope.org/mailman/options/zope3-dev/cliff.ford%40ed.ac.uk
_______________________________________________
Zope3-dev mailing list
Zope3-dev@zope.org
Unsub: http://mail.zope.org/mailman/options/zope3-dev/archive%40mail-archive.com