[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 at zope.org
> Unsub: http://mail.zope.org/mailman/options/zope3-dev/cliff.ford%40ed.ac.uk
>