yet another image: db or filesystem ? question

From: Rick Schumeyer <rschumeyer(at)ieee(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: yet another image: db or filesystem ? question
Date: 2007-07-17 15:09:33
Message-ID: 469CDBAD.1010502@ieee.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've read the earlier threads on whether to store images in the database
or filesystem. I think I understand the pros and cons of each method,
but I have a question on a specific use case.

Let's say I have a web app, and I want to display the images in a web page.

a) if the images are in the filesystem (and also under the web root), no
problem. Just use <img src="filename.jpg" />

b) if the images are in the database...do I need to create a temporary
file first in order to use the <img> tag? Or is there some other HTML
way of doing this?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-07-17 15:31:34 Re: yet another image: db or filesystem ? question
Previous Message Tom Lane 2007-07-17 14:54:31 Re: Update of table lags execution of statement by >1 minute?