[Zope] Zope & Postgres with Images

[kapil thangavelu]

On Wednesday 31 October 2001 11:57 am, Karl Munroe wrote:
> I am trying to develope a db application that uses a postgres backend.
>
> 1) I want to store images in postgres db. Anyone figured how to do this?
> (Postgres does not have a built in type such as BLOB in mysql to store
> binary data)

BLOB support has been in postgres for a while.

if you'd rather not use blob, you can store binary data in bytea field.

> 2) Assuming that I have one figured out....how next do I render the images
> extracted from the db to a webpage through zope?

set the appropiate headers and stream it back, although this is extremely 
inefficient.

kapil