Storing Images within Blob types

 
Post new topic   Reply to topic    34SP.com Forum Index // Database Support
View previous topic :: View next topic  
Author Message
Mimicry
34SP Newbie
34SP Newbie


Joined: 04 Feb 2010
Posts: 2

PostPosted: Thu Feb 04, 2010 11:05 pm    Post subject: Storing Images within Blob types Reply with quote
This seems to be a contentious issue within many coding communities. So it would be interesting to hear the opinions of the administrators behind the scenes that have experience with this issue (or similar).

Do you think it is a good idea to store images within a database? If used correctly.

Incorrect use of such a storage method, as pointed out in the MySQL documentation, would be calling ill-thought-out queries like SELECT * FROM images_table.

I'm in two minds about this. I can certainly see the pitfalls being incorrect queries and possible overhead.
But from personal experience if I was to incorporate this method into 2 of my current projects I would decrease the amount of code dramatically , make backing up/sorting 100% easier and also offer slight security benefits.

I'd love to hear people's opinions...
Back to top
View user's profile Send private message
Post new topic   Reply to topic    34SP.com Forum Index // Database Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Powered by phpBB © 2001, 2002 phpBB Group