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