Re: Storing images in PG?

From: "Dr(dot) Evil" <drevil(at)sidereal(dot)kz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Storing images in PG?
Date: 2001-08-16 20:41:10
Message-ID: 20010816204110.17731.qmail@sidereal.kz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hugh Mandeville 2001-08-16 21:01:00 Re: unix timestamp
Previous Message Thomas Lockhart 2001-08-16 20:39:36 Re: unix timestamp