photos and OID's - Mailing list pgsql-sql

From Mark
Subject photos and OID's
Date
Msg-id 200105241937.f4OJbkW04414@mail.ldssingles.com
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Daniel Wickstrom
Date:
Subject: Recursive select
Next
From: "postgresql"
Date:
Subject: ports in use question