If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 9:38am

#1

Ziycon

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

Join Date: December 2004

Posts: 1614

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