Re: [Zope] Zope & Postgres with Images

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