Received: from samson.fire.uni-bremen.de (samson.fire.uni-bremen.de [134.102.100.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f19FNEx38179 for ; Fri, 9 Feb 2001 10:23:14 -0500 (EST) (envelope-from waldmann@samson.fire.uni-bremen.de) Received: (from waldmann@localhost) by samson.fire.uni-bremen.de (8.10.1/8.10.0) id f19FKh920316 for pgsql-interfaces@postgresql.org; Fri, 9 Feb 2001 16:20:43 +0100 Date: Fri, 9 Feb 2001 16:20:43 +0100 From: "Dr. Hans-Christian Waldmann" Message-Id: <200102091520.f19FKh920316@samson.fire.uni-bremen.de> To: pgsql-interfaces@postgresql.org Subject: extracting blobs (jpg) directly to the web woth perl DBI ?? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-MD5: 9kwxjnLOn/4l2xIPeHfc9A== X-Archive-Number: 200102/76 X-Sequence-Number: 1029 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 ---------------------------------------------------------------------