Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Image Storage, File in DB or File Reference in DB

Ziycon · 2013-10-11 09:38:15

Looking for advice on storage of images, there's a website I'm working and each registered user will have a profile picture but there can also be numerous other images associated to the one account. As there is the potential for a large amount of images which would be a better plan for storage, store the image as a BLOB…

11-10-2013 10:38AM

#1

Ziycon

Registered Users, Registered Users 2 Posts: 1,991 ✭✭✭

Join Date: December 2004

Posts: 1618

Looking for advice on storage of images, there's a website I'm working and each registered user will have a profile picture but there can also be numerous other images associated to the one account.
As there is the potential for a large amount of images which would be a better plan for storage, store the image as a BLOB and the related information like mime type, file name in three database columns respectively or store the image in a directory and store it's location in one column in the database?

I'm also trying to think for down the road as the data gets bigger how easy would it be and how reliable if I was to store images as flat files and not in the database, if everything was in the database it's an easier backup/restore process.

Any advice greatly appreciated, thanks.

0