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