[Zope] Alternate storage for ZODB

[Thierry Florac]

On Thu, 2002-07-04 at 13:31, Max M wrote:
> Thierry Florac wrote:
> 
> >I've seen here and there several articles about a replacement of the
> >ZODB storage via an SQL backend, to store every Zope objects.
> >Actually, I would like to test with a PostgreSQL storage, but I can't
> >find any link anywhere to these kind of informations.
> >
> >Any link, advise or experimentation reports would be greatly
> >appreciated...
> >  
> >
> 
> Please be aware of the common misunderstanding that Python objects are 
> in some way converted to sql tables in this way.
> 
> What happens is that Python objects has their pickled representation 
> stored in a text field in the relational db. So it is not so that you 
> can pull out data from Zope via the db.

Absolutely...

I don't want to execute queries on Zope's database, but what I'd like to
be able to do is to use an external storage, which could provide
advanced functions such as :
 - replication (also available with ZEO),
 - partitionning,
 - handling of very high volumes,
 - and so on...

In fact, I'm a little bit afraid by the ZODB FileStorage, and by it's
potential ability to handle very big data files correctly... We have a
lot of big files to publish and index, and our ZODB will probably have a
size of 10 GB quite rapidly... Any advise ??

Thanks,

  Thierry