Storing images in SQL database?

From: Andrew McCall <andrew.mccall_at_gmail.com>
Date: 4 Oct 2004 07:48:34 -0700
Message-ID: <4aa50a46.0410040648.64cacb6a@posting.google.com>

Hi Folks,

I am about to start on a project where I will need to store a large amount of images and details about images. SQL seemed a natural choice for this, but I was a little unsure about how to store the image itself.

From reading around I have found that there are two techniques that people normally chose for this sort of work:

To store everything about the image within the SQL database, and the image itself on a file system. A link to the image in the file system is also stored within the SQL database.
To store the everything, including the image within the database.

I was wondering what people thought about these two techniques, and which they would use. Ideally I would like to store everything within the database as this seems a tidy solution, but I have read that this may not be the best way to go.

Thanks,

Andrew McCall Received on Mon Oct 04 2004 - 09:48:34 CDT