Re: Storing images in PG? - Mailing list pgsql-general

From Dr. Evil
Subject Re: Storing images in PG?
Date
Msg-id 20010816204110.17731.qmail@sidereal.kz
Whole thread Raw
In response to Re: Storing images in PG?  ("Joe Conway" <joseph.conway@home.com>)
List 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 by date:

Previous
From: Andrew Gould
Date:
Subject: Killing inactive connections
Next
From: Thomas Lockhart
Date:
Subject: Re: unix timestamp