[Zope] advice needed

[Martin Gebert]

Have you thought about storing the images as BLOBs in MySQL? I must 
admit I lack every experience how MySQL behaves under the load of many 
Long Objects, but in a small scale I've made good experiences till now 
with that (the concerning small application will go online the next days).
Concerning the access restrictions, IMHO this would be handled the 
easiest way by roles and (in case of externel files or ZODB storage) 
different folders, if your special problem admits such an architecture.

Martin

gabecker@indiana.edu schrieb:

>I am relatively new to Zope, but I plan to use it for an image database
>system that I need to make for scientific purposes.  What I have in mind
>is to store the actual images externally in files (since there will be
>many and large files), and the info about the image (where collected,
>owner, codes etc etc) in a database like MySQL. Zope would form the
>interface.
>
>My first question is what would be a suitable way to go from here: use
>LocalFS or ExtImage for storage of many files (think of 50,000 or so)? I
>will need to be able to differentiate between users: ie not every user
>should have access to all files.
>
>Furthermore: if there are people that have already done something similar
>I would appreciate to learn from their experience. Through a web search I
>haven't been able to find such projects, at least not based on Zope.
>
>All best,
>Gabriel
>
>  
>