Re: Displaying Image BLOBs

From: Fabrice Scemama <fabrice(dot)scemama(at)gesnet(dot)net>
To: pgsql-general(at)hub(dot)org
Subject: Re: Displaying Image BLOBs
Date: 1999-01-26 16:01:03
Message-ID: 36ADE6BF.793AB72A@gesnet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
(zip)
> In short, you should have a cgi whose URL may look something like:
>
> http://my.domain.com/cgi-bin/lo-dumper.cgi?oid=NNNNN&mime=image/jpeg
>
> When you have one, you can use it as your image source. Just write your
> image output with the above URL as its source:
>
> <IMG SRC="/cgi-bin/lo-dumper(dot)cgi?oid=123456(at)mime=image/jpeg"
> WIDTH=100 HEIGHT=40 ALT="Image of a bear">
>
> How did all the parameters get there? Well, I assume that anybody holding
> an image database will have an image table, which has fields for the image
> name or details (which can be used in the ALT), its width and height, and
> if there are several image types, also its type (jpeg, gif, png).

Keeping information about sizes of images might be embarrassing,
though I think there's on CPAN Perl modules to learn from an image
it's size, jpeg or gif alike (not sure).

But people might prefer using only the WIDTH *or* the HEIGHT
parameter; Netscape and Explorer will then keep the image ratio
when displaying the image.

My 2 cents ;)
Fabrice

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Ramsey 1999-01-26 18:32:41 Using SELECT to get table info.
Previous Message Mauricio C. de Oliveira 1999-01-26 11:45:49 Re: Re: Bad column offset?