[Zope] ZODB vs Relational Databases

[Michael Long]

Thanks to everyone for all of the feedback. I am going to start by
getting a product built to manage the metadata. By that time I should
know zope well enough to determine which approach will be best for the
OLTP data. Right now it seems like the RDBMS is the way to go however.

Cheers,
Mike

> I would agree, since you seem to know RDBMS already. Use ZODB for metadata
> and other types of objects. This approach also allows access to the data
> from other, external applications. Or go with whatever gives you the
> "cleanest" application design.
> 
> One of the things Python & Zope emphasize is that it's not about the raw
> numbers, it's all about ease of use, rate of development/deployment,
> application of logic, etc.
> 
> Samir.
> 
> And this is of course, just my $0.02.
> 
> 
> -----Original Message-----
> From: Dieter Maurer [mailto:dieter@handshake.de]
> Sent: Tuesday, March 11, 2003 01:33
> To: mlong@datalong.com
> Cc: Zope
> Subject: Re: [Zope] ZODB vs Relational Databases
> 
> 
> Michael Long wrote at 2003-3-10 09:05 -0500:
>  > Please forgive me if this is in a FAQ somewhere. I am writting an
>  > application that will be capturing financial information. If I use the
>  > ZODB and create expense and income objects to capture this information
>  > there will over a 1000 objects added a week. I will be tracking
history,
>  > archiving data, etc. Is Zope the right tool for this type of
application
>  > or am I better off creating the objects that this data is associated
>  > (companies, people, properties, etc) within the ZODB and using a
>  > relational database such as PostgreSQL to track the higher volume
>  > financial data.
> 
> If I have lots of highly structured data, I would go for
> a relational database and not store them in the ZODB.
> 
> 
> Dieter
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
> 
>