Re: Displaying Image BLOBs

Поиск
Список
Период
Сортировка
От Fabrice Scemama
Тема Re: Displaying Image BLOBs
Дата
Msg-id 36ADE6BF.793AB72A@gesnet.net
обсуждение исходный текст
Ответы Re: [GENERAL] Re: Displaying Image BLOBs  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Список pgsql-general
> From: Herouth Maoz <herouth@oumail.openu.ac.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.cgi?oid=123456@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



В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Crawford
Дата:
Сообщение: Does PostgreSQL use mmap()?
Следующее
От: Charles Hornberger
Дата:
Сообщение: nested loops in joins, ambiguous rewrite rules