[Zope] Zope + PostgreSQL + BLOBS, how?

[JB]

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