yet another image: db or filesystem ? question - Mailing list pgsql-general

From Rick Schumeyer
Subject yet another image: db or filesystem ? question
Date
Msg-id 469CDBAD.1010502@ieee.org
Whole thread Raw
Responses Re: yet another image: db or filesystem ? question  (Richard Huxton <dev@archonet.com>)
Re: yet another image: db or filesystem ? question  (Steve Atkins <steve@blighty.com>)
Re: yet another image: db or filesystem ? question  (PFC <lists@peufeu.com>)
List 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?



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Update of table lags execution of statement by >1 minute?
Next
From: mljv@planwerk6.de
Date:
Subject: Re: createing indexes on large tables and int8