Where should I store photos? File system or the database? [duplicate]

by

Filesystem, of course, unless you’re aiming for a story on thedailywtf. The easiest way is to have the photos organized by a property you can derive from the file itself, such as its SHA-1 hash. Then just store the hash in the database, attached to the photo’s primary key and other attributes (who uploaded it, upload date, etc).

It’s also a good idea to divvy up the photos on the filesystem, so you don’t end up with millions of files in a single directory. So you’ll have something like this:

storage/00/e4/f56c0de1c61fdb926e79e8a0a65bd12930c9.jpg
storage/25/9a/ec1c55bfb660548a6770238668c4b117d92f.jpg
storage/5d/d5/4b01d98f17a9ad9dd1526b49ba39b5aa37a1.jpg
storage/63/49/6f740b6c284ce6685dc17d473a7360ace249.jpg
storage/b1/75/066d178188dde110149a8422ab651b0ee615.jpg
storage/b1/20/a2b7d02b7b0c43530677ab06235382a37e20.jpg
storage/da/39/a3ee5e6b4b0d3255bfef95601890afd80709.jpg

This is also easy to port if you ever move to sharded storage.

More Related Contents:

  1. Logout: GET or POST?
  2. What’s the difference between “Layers” and “Tiers”?
  3. Component based game engine design [closed]
  4. Domain Driven Design: Domain Service, Application Service [closed]
  5. Why do stacks typically grow downwards?
  6. What is N-Tier architecture?
  7. Servicestack – architecture & reusing POCOs for everything
  8. what is a store buffer?
  9. When are you truly forced to use UUID as part of the design?
  10. On 32-bit CPUs, is an ‘integer’ type more efficient than a ‘short’ type?
  11. What am I not understanding about REST?
  12. Microservices – best practices to retrieve the related data to specific user from the other micro services with the minimal memory/time loss
  13. Best way to store Badge criteria?
  14. How do you organize your small reusable cffunctions?
  15. dma vs interrupt-driven i/o
  16. Difference between a “coroutine” and a “thread”?
  17. How to list supported target architectures in clang?
  18. What is opinionated software?
  19. What is a “feature flag”?
  20. How to detect target architecture using CMake?
  21. CMake Multiarchitecture Compilation
  22. DDD, Anti Corruption layer, how-to?
  23. What’s the difference between REST & RESTful
  24. When to Redis? When to MongoDB? [closed]
  25. Is it bad practice to have a constructor function return a Promise?
  26. What is a Data Transfer Object (DTO)?
  27. C state-machine design [closed]
  28. Transactions across REST microservices?
  29. Why is IoC / DI not common in Python?
  30. What is the right way to use spring MVC with Hibernate in DAO, service layer architecture

Leave a Comment