I realize this isn't the answer to your question, but I have a large photo database that I am serving out of zope (1500+ images). I keep the photos indexed by name on the disk and alias the directory with apache. Then I use an external method to hand me back a string of either <IMG SRC='/apache_alias/image_key.jpg'> or a 'No image found' string, depending on the results of the key search. I went this way because from what I understand of postgres, this is much faster than using the large object methods. Plus I can mess with the images directly without having to use postgres to get at them. cheers jim Steen Suder wrote:
Is it possible to store, say, staff pictures in PostgreSQL and then show them on a webpage served by Zope?
Like: PostgreSQL -> DA -> Zope -> webpage
If it is possible; can someone give me a few guidelines or hints on how it is done?
I've never worked with BLOBs, but have done lot of standard SQL stuff, also with Zope.
-- Best regards / Mvh., Steen Suder, sysadm kollegie6400.dk -|- OpenSource --- Sign of the time