Saving images: files or blobs?

by

I usually go with storing them as files, and store the path in the database. To me, it’s a much easier and more natural approach than pushing them into the database as blobs.

One argument for storing them in the database: much easier to do full backups, but that depends on your needs. If you need to be able to easily take full snapshots of your database (including the images), then storing them as blobs in the database is probably the way to go. Otherwise you have to pair your database backup with a file backup, and somehow try to associate the two, so that if you have to do a restore, you know which pair to restore.

More Related Contents:

  1. Storing Images in DB – Yea or Nay?
  2. To Do or Not to Do: Store Images in a Database [duplicate]
  3. Storing a small number of images: blob or fs?
  4. Display dynamic image from database or remote source with p:graphicImage and StreamedContent
  5. Keep PostgreSQL from sometimes choosing a bad query plan
  6. What are the performance characteristics of sqlite with very large database files? [closed]
  7. When and why are database joins expensive?
  8. What is the optimal length for an email address in a database?
  9. Storing Images : DB or File System –
  10. In what way does denormalization improve database performance?
  11. How to store images in your filesystem
  12. How does database indexing work? [closed]
  13. Should each and every table have a primary key?
  14. Database, Table and Column Naming Conventions? [closed]
  15. Can HTML5 databases and localStorage be shared across subdomains?
  16. What is a database transaction?
  17. Relational table naming convention [closed]
  18. When I should use one to one relationship?
  19. What’s the difference between findAndModify and update in MongoDB?
  20. Efficiently color cycling an image in Java
  21. Database optimization orders
  22. What is database pooling?
  23. What is it exactly a BLOB in a DBMS context
  24. have address columns in each table or an address table that is referenced by the other tables?
  25. Minimum no of tables that exists after decomposing relation R into 1NF?
  26. Creating test data in a database [closed]
  27. When we need to use 1-to-1 relationship in database design?
  28. How to get item count from DynamoDB?
  29. How to find SQLITE database file version
  30. Oracle: How do I convert hex to decimal in Oracle SQL?

Leave a Comment