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
---------------------------------------------------------------------
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