Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group