Re: Storing images in PG?

Поиск
Список
Период
Сортировка
От Dr. Evil
Тема Re: Storing images in PG?
Дата
Msg-id 20010816204110.17731.qmail@sidereal.kz
обсуждение исходный текст
Ответ на Re: Storing images in PG?  ("Joe Conway" <joseph.conway@home.com>)
Список pgsql-general
Well, thanks for the sugestions to all who responded to my question.
After reading all the sugestions, I have come to the conclusion that
I'm going to store everything as base64 encoded TEXT.  The main reason
for this is that all the images are going to be be small icons or
things which can display on WAP phones.  I looked at them in PNG and
WBPM format, and the images end up between 1k and 3k.  For images this
small, PG should be able to handle it with no difficulty.  There is
some CPU cost in doing the base64 conversion on the fly, but CPU is
cheap and I'm expensive, so we'll buy CPU.  In fact, they may be
stored as PNGs and even converted on the fly to WBPM as needed.

I guess if I were storing 1mb images, I might consider using the FS
instead of PG, but in this case, it seems reasonable to use PG, just
for simplicity.

Thanks

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

Предыдущее
От: Andrew Gould
Дата:
Сообщение: Killing inactive connections
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: unix timestamp