pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dr. Hans-Christian Waldmann <waldmann@samson.fire.uni-bremen.de>
To: pgsql-interfaces@postgresql.org
Subject: extracting blobs (jpg) directly to the web woth perl DBI ??
Date: Fri, 9 Feb 2001 16:20:43 +0100
Message-ID: <200102091520.f19FKh920316@samson.fire.uni-bremen.de> (raw)


Dear List,

I have a table with several string columns (defining product properties)
and one blob-column of type "oid" (actually showing the product in jpg-
Format). Currently I am using postgresql 7.0.2 along with perl 5.6 and
the perl DBI 1.14 in order to query the table from a cgi-form. The
jpg is first exported to the filesystem, with a url pointing to it
in the html-response (query-results from non-oid columns). This works
fine assuming a rather low query rate. But you have to give unique names
to the jpg-files, (f)lock them, delete them, and concurrent hits
for the same picture are hard to handle, etc. What I would like to learn 
about is a way to read contents of a blob-column (known type: jpg)
_directly_ out to the webserver (apache) and into the response page.
Is it possible ? Or am I asking something absurd ? If it is not possible,
could someone point me to a secure method of assuring result integrity when
reading out the same picture to the fs upon multiple queries (referencing the
same picture)? There must be a method since there quite a lot of online
catalogues around. To be true I am a statistics/math programmer with very
little experience in the web domain. Please let me know if have any ideas.  

Thank you


---------------------------------------------------------------------
PD Dr. Hans C Waldmann              
Methodology & Applied Statistics in Psychology & the Health Sciences

ZFRF / University of Bremen / Grazer Str 6 / 28359 Bremen / Germany 
waldmann@samson.fire.uni-bremen.de / http://samson.fire.uni-bremen.de

friend of: AIX PERL POSTGRES ADABAS SAS SPSS TEX 
---------------------------------------------------------------------




Message-ID: <200102091520.f19FKh920316@samson.fire.uni-bremen.de>
Permalink:  ../200102091520.f19FKh920316@samson.fire.uni-bremen.de/
Also on:    postgresql.org/message-id/200102091520.f19FKh920316@samson.fire.uni-bremen.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-interfaces@postgresql.org
  Cc: waldmann@samson.fire.uni-bremen.de
  Subject: Re: extracting blobs (jpg) directly to the web woth perl DBI ??
  In-Reply-To: <200102091520.f19FKh920316@samson.fire.uni-bremen.de>
  References: <200102091520.f19FKh920316@samson.fire.uni-bremen.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox