pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Mark <mark@zserve.com>
To: pgsql-sql@postgresql.org
Subject: Re: photos and OID's
Date: Fri, 25 May 2001 00:28:39 +0100
Message-ID: <006101c0e4a9$57989fc0$1001a8c0@archonet.com> (raw)
References: <200105241937.f4OJbkW04414@mail.ldssingles.com>

From: "Mark" <mark@zserve.com>

> We store photos in the db and serve them up from web servers.  We're
> using java servlets on separate web server boxes that are load balanced.
> NFS is not an option for us (unless nothing else is available).  This
> works with byte streams using SQL Server from MS.  But, we don't want to
> use SQL Server any more, we want to use PostgreSQL.
>
> We need to get the photo data from the db without any file system
> access.  In other words, we need the bytes, not the OID.
>
> So I read docs and found lo_import/lo_export.  But that would only work
> for us over NFS and would cause major complications.  lo_export won't
> cut it for us unless we make some major changes.  Can I use the standard
> JDBC Blob type to retrieve the photos?  What other options do I have?

I'm no expert on Java, but it looks like the JDBC interface (ch 8.5) takes
InputStream and OutputStream as parameters for lo_import/lo_export. Can you
not then tie them to whatever image class you use?

File access is needed at the database end (it stores the lo's in separate
files) but not on your client webservers.

Hopefully that's what you're after, but you might want to wait around for a
second opinion.

- Richard Huxton




view thread (2+ messages)

Message-ID: <006101c0e4a9$57989fc0$1001a8c0@archonet.com>
Permalink:  ../006101c0e4a9$57989fc0$1001a8c0@archonet.com/
Also on:    postgresql.org/message-id/006101c0e4a9$57989fc0$1001a8c0@archonet.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dev@archonet.com, mark@zserve.com
  Subject: Re: photos and OID's
  In-Reply-To: <006101c0e4a9$57989fc0$1001a8c0@archonet.com>

* 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