[Zope] BLOB from PotgreSQL on web page

Federico Di Gregorio fog@mixadlive.com
30 Jun 2001 01:30:30 +0200


i think i cross posted here from the psycopg ml something on the
argument a week ago... looking at the mailing lists... ok. found. you'll
find a little example in how to save a jpg image to postgresql here:

    http://lists.initd.org/pipermail/psycopg/2001-June/000201.html

if you need more help, don't esitate to write again,
federico

On 29 Jun 2001 09:07:48 -0700, Vid B wrote:
> > > 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.
> > >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
> > 
> 
> Hi Federico,
> 
> I am glad to hear that python solution for publishing
> the files (especially images) from database to web
> pages exists.  I found ASP, PHP, Perl solutions, but
> it did not help me.  Can you give me more details how
> python solution looks like or if you have working 
> example?
> 
> Thanks
> 
> Vid
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/



-- 
Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
  Try the Joy of TeX [http://www.tug.org]
                                      -- brought to you by One Line Spam