Storing images in a db (for web/midlet access)

From: Assad Jarrahian <jarraa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Storing images in a db (for web/midlet access)
Date: 2005-12-28 08:23:21
Message-ID: 4bd3e1480512280023p40bf0db0m838c55f4462e4dd9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,
So I am trying to store images in the db which will be accessed from
a midlet and website.
So I looked into generating temp files, such as the one done here
using servlets (http://fdegrelle.over-blog.com/categorie-275139.html).
What I am confused about is that this may not be very efficient.
When one browses a website, the pages (and hence the images) are
basically cached in the browser, but with this method, it seems that
every access to an image (that has already been viewed in a web
session) is going to cause a re-query to the database. Not that
efficient, no?
Is there another way around that will help me take advantage of
caching etc, just like it would with storing images on fs?
Much thanks in advance!

-Assad

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-12-28 09:00:47 Re: Detaching database
Previous Message Robby Russell 2005-12-28 07:13:06 Re: sending mail from Postgres