[Zope] BLOB from PotgreSQL on web page

Federico Di Gregorio fog@mixadlive.com
29 Jun 2001 10:02:03 +0200


> I am using Zope 2.3 and PSQL 7.1  After installing the
> adapters Popy and ZPopyDA it has been working very
> well.  But I have one concern and one problem.
> 
> Problem
> 
> I am storing BLOBs in PSQL using lo_import, and
> exporting them to the file system using lo_export. But
> I cannot figure out how to
> display them directly from the database to the web
> page.
> 
> Concern
> 
> What is more efficient? To store files as BLOBs in
> PSQL or to store the files to Zope and store link to
> the file in PSQL.  Files will be
> of different format: jpg, gif, pdf, wpd, doc, ...

postgresql 7.1 does not have any limit on row size. just call a python
method that squeezes the data into a text column and retrieve it.

hope this helps,
federico

-- 
Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
                      The number of the beast: vi vi vi. -- Delexa Jones