pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mitch Vincent <mitch@venux.net>
To: chriswood@wvda.com
To: pgsql-php@postgresql.org
Subject: Re: Question re large objects
Date: Tue, 28 Nov 2000 10:50:17 -0800
Message-ID: <00d101c0596c$0d339c00$0200000a@windows> (raw)
References: <3A23B26E.9056.2942B3@localhost>

> (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.

In 7.0.X there is a limit on the size of tuples, 32k, and some images could
easily be bigger than that (though it depends on your images I guess). 7.1
will be out shortly after the first of the year and will take care of this
though.

Depending on the use of these images, I'd think up a naming scheme and store
them as flat-files and perhaps store the image name or something in the
database... You could still display a link to the images but the link would
have to be to a PHP (or other) script that would grab the image from the
database, set the MIME type and display it to the browser -- you couldn't
have it in an HTML document without first writing it to a flat file (at
least I don't know of a way you could display it in an HTML document) .

> 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?

The MIME type is image/jpeg for jpegs and image/gif for gifs. Use PHP's
header() function.

> Be gentle if I've asked a stupid question... :-)

There are no stupid questions, only stupid answers!

-Mitch





view thread (16+ messages)  latest in thread

Message-ID: <00d101c0596c$0d339c00$0200000a@windows>
Permalink:  ../00d101c0596c$0d339c00$0200000a@windows/
Also on:    postgresql.org/message-id/00d101c0596c$0d339c00$0200000a@windows

 · 

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 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: mitch@venux.net, chriswood@wvda.com
  Subject: Re: Question re large objects
  In-Reply-To: <00d101c0596c$0d339c00$0200000a@windows>
  References: <3A23B26E.9056.2942B3@localhost> <00d101c0596c$0d339c00$0200000a@windows>

* 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