Storing a small number of images: blob or fs?

by

To answer parts of your question:

How do clients go with caching images from the DB vs from the filesystem?

For a database: Have a last_modified field in your database. Use the Last-Modified HTTP header so the client’s browser can cache properly. Be sure to send the appropriate responses when the browser requests for an image “if newer” (can’t recall what it’s called; some HTTP request header).

For a filesystem: Do the same thing, but with the file’s modified time.

If BLOBs stored in the DB are the way to go – is there anything I should know about where to store them? Since I imagine that a majority of my users won’t be uploading a picture, should I create a user_pics table to (outer) join to the regular users table when needed?

I would put the BLOB and related metadata in its own table, with some kind of relation between it and your user table. Doing this will make it easier to optimize the table storage method for your data, makes things tidier, and leaves room for expandability (e.g. a general “files” table).

More Related Contents:

  1. Storing Images in DB – Yea or Nay?
  2. Saving images: files or blobs?
  3. Display dynamic image from database or remote source with p:graphicImage and StreamedContent
  4. To Do or Not to Do: Store Images in a Database [duplicate]
  5. Storing Images : DB or File System –
  6. How to store images in your filesystem
  7. Should each and every table have a primary key?
  8. Database, Table and Column Naming Conventions? [closed]
  9. When and why are database joins expensive?
  10. Normalization: What does “repeating groups” mean?
  11. I need my PHP page to show my BLOB image from mysql database
  12. Difference Between Firestore Set with {merge: true} and Update
  13. Can HTML5 databases and localStorage be shared across subdomains?
  14. What is a database transaction?
  15. Relational table naming convention [closed]
  16. When I should use one to one relationship?
  17. What’s the difference between findAndModify and update in MongoDB?
  18. How SID is different from Service name in Oracle tnsnames.ora
  19. Database of common name aliases / nicknames of people
  20. Storing an image into an Attachment field in an Access database
  21. Best representation of an ordered list in a database?
  22. What is it exactly a BLOB in a DBMS context
  23. have address columns in each table or an address table that is referenced by the other tables?
  24. Minimum no of tables that exists after decomposing relation R into 1NF?
  25. Populate Android Database From CSV file?
  26. Creating test data in a database [closed]
  27. When we need to use 1-to-1 relationship in database design?
  28. Does anyone know of a good library for mapping a person’s name to his or her gender? [closed]
  29. Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)
  30. Is writing server log files to a database a good idea?

Leave a Comment