From: Mark <mark@zserve.com>
To: pgsql-sql@postgresql.org
Subject: photos and OID's
Date: 24 May 2001 12:45:53 -0600
Message-ID: <200105241937.f4OJbkW04414@mail.ldssingles.com> (raw)
Hi all,
Thanks for the great product.
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?
Thanks,
Mark
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-sql@postgresql.org
Cc: mark@zserve.com
Subject: Re: photos and OID's
In-Reply-To: <200105241937.f4OJbkW04414@mail.ldssingles.com>
References: <200105241937.f4OJbkW04414@mail.ldssingles.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