471,073 Members | 1,362 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Storing images in SQL database?

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:

1) 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.

2) 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
Jul 20 '05 #1
1 1628
Andrew McCall wrote:
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:

1) 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.

2) 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.


(1) is a much better option, otherwise you end up with a massively inflated
database and you create a lot of time overhead (as well as additional
server load) in pulling the images out of the database. I personally would
never store images in a database.

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Benoit St-Jean | last post: by
6 posts views Thread by bissatch | last post: by
3 posts views Thread by bissatch | last post: by
4 posts views Thread by Rednelle | last post: by
4 posts views Thread by IkBenHet | last post: by
9 posts views Thread by Adam J Knight | last post: by
2 posts views Thread by Paulo | last post: by
1 post views Thread by Jonathan Wood | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.