From: Justin Long <justinlong@strategicnetwork.org>
To: chriswood@wvda.com
Cc: pgsql-php@postgresql.org
Subject: RE: Question re large objects
Date: Tue, 28 Nov 2000 12:35:14 -0500
Message-ID: <PBEMJIMKFNACLPCNPDEBEEMNEHAA.justinlong@strategicnetwork.org> (raw)
In-Reply-To: <3A23B26E.9056.2942B3@localhost>
Point #1: I've heard rumors that BLOBs have been buggy in the past (I'm
using 7.0 right now...).
Point #2: I would be interested in knowing if you come up with a way to do
this. Right now we have a large web site with databases of over 10GB and
many image files. We are storing them on a single shared directory on one
server as we can't find any way to do what you are saying...
Of course, I've never asked anyone for help, either, so kudos for your
bravery!
:-)
Justin Long
_________________________________________________________________
Justin Long Network for Strategic Missions
1732 South Park Court Never retreat. Never surrender.
Chesapeake, VA 23320, USA Never cut a deal with a dragon.
757-213-2055, ICQ 97269932 http://www.strategicnetwork.org
Monday Morning Reality Check: reality-check-subscribe@egroups.com
-----Original Message-----
From: pgsql-php-owner@postgresql.org
[mailto:pgsql-php-owner@postgresql.org]On Behalf Of chriswood@wvda.com
Sent: Tuesday, November 28, 2000 12:26 PM
To: pgsql-php@postgresql.org
Subject: [PHP] Question re large objects
(Hopefully I'm addressing this to the right list... This is my first time
with BLOBs anywhere.)
I'm working on a web page template system (PHP/PostgreSQL)
which will (in part, other stuff is done) allow users to upload a gif or
jpeg via a form on another site. The image will then slot into a
predetermined place on their template website.
I've considered the alternatives (store files in a directory or in the
db), and I think storing the image files in the database is the way to
go. Unless anybody can think of why I should just upload the files
to a directory on the server instead of storing them as BLOBs.
I can upload a binary file just fine, and retrieve it from the database
just fine. The problem is that the file (using pg_loreadall) just
plunks itself into my test page as text/plain. How do I get a mime
type header associated with this data so my browser will recognize
it as a gif or jpeg? Do I have to export the file to a web-accessible
directory (owned by web server user, I know) and then use an
<img> tag? Or is there a way to get my browser to recognize that
the BLOB is in fact an image when PHP pulls it out of the
PostgreSQL database?
Be gentle if I've asked a stupid question... :-)
--------------------------------------------------------
Christopher Wood, Community Access Technical Coordinator
Western Valley Development Authority
Nova Scotia's Smart Community
Box 251 Bridgetown, Nova Scotia B0S 1C0
tel: (902) 665-4083/ fax: (902) 665-2878
www.wvda.com www.wvcn.ns.ca
--------------------------------------------------------
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-php@postgresql.org
Cc: justinlong@strategicnetwork.org, chriswood@wvda.com
Subject: Re: Question re large objects
In-Reply-To: <PBEMJIMKFNACLPCNPDEBEEMNEHAA.justinlong@strategicnetwork.org>
References: <3A23B26E.9056.2942B3@localhost> <PBEMJIMKFNACLPCNPDEBEEMNEHAA.justinlong@strategicnetwork.org>
* 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