store image in database or path which better?

There are different pros and cons of saving images file into database.

Saving Image file in Database

Pros:

If you want to save and secure sensitive/confidential Images like employee face images.
Deleting the file will delete the image too.
Database backup will automatically backup the images too.

Cons:

Slow access to the image and require more resources on the server.
The database grows quickly consequently database backup will require more time.

Saving Image  in File System


Pros:

Enable quick access to the image, Webserver easily/quickly provide the file.
Easily viewable on the server through image viewer/browse.

Cons:

Deleting the record will require to delete the file separately.
Low security of image

Ref:


  1. https://teamtreehouse.com/community/storing-image-in-database-compare-with-storing-at-the-folder-server
  2. https://www.quora.com/Difference-in-storing-image-in-database-table-vs-storing-image-in-folder-and-save-its-path-in-database-Which-is-better-and-why-PHP
  3. https://habiletechnologies.com/blog/better-saving-files-database-file-system/

No comments:

Post a Comment