[Zope] Re: new howto: choosing sql vs ZODB.

[Squishdot]

anthony baxter <anthon-@interlink.com.au> wrote: 
> At http://www.zope.org/Members/anthony/sql_vs_ZODB/ I've started to 
> put together a howto listing some of the things to think about when
> you're deciding whether to put data into the ZODB or an SQL database.
> 
> 
> feedback, additional data points welcome...
> 
> Anthony
> 
> 

One additional point to be raised is whether you have a text field
that you want to be indexed. If you use the ZODB, you automatically
have a platform-independent way of indexing a full text database
by using ZCatalog. If you use a ZCatalog-aware object, it automatically
can index/reindex/unindex itself too.

If you choose to use an SQL RDBMS , you don't have a platform-independent
way of creating a full text search index (i.e. each RDBMS may or may not
have the capability to index a LONG VARCHARS type and each one that
can may do it in a different way).

In fact, this is one of the major reasons why I've chosen to use the ZODB in 
Squishdot, along with the fact that the messages dont get updated that 
often anyway (in accordance with point no. 1 on your how-to).

HTH.

Butch 

=====
Butch Landingin
Squishdot maintainer
http://squishdot.org
squishdot@yahoo.com
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com