What is the best place for storing uploaded images, SQL database or disk file system? [closed]

by

I generally store files on the file-system, since that’s what its there for, though there are exceptions. For files, the file-system is the most flexible and performant solution (usually).

There are a few problems with storing files on a database – files are generally much larger than your average row – result-sets containing many large files will consume a lot of memory. Also, if you use a storage engine that employs table-locks for writes (ISAM for example), your files table might be locked often depending on the size / rate of files you are storing there.

Regarding security – I usually store the files in a directory that is outside of the document root (not accessible through an http request) and serve them through a script that checks for the proper authorization first.

More Related Contents:

  1. Storing Images : DB or File System –
  2. Normalization in database management system
  3. How to perform compound queries with logical OR in Cloud Firestore?
  4. Database development mistakes made by application developers [closed]
  5. Copying PostgreSQL database to another server
  6. Surrogate vs. natural/business keys [closed]
  7. How to upload images into MySQL database using PHP code
  8. Do you use source control for your database items? [closed]
  9. What is NoSQL, how does it work, and what benefits does it provide? [closed]
  10. database vs. flat files
  11. Spring Security:password encoding in DB and in applicationContext
  12. ADO.Net EF – how to define foreign key relation in model first approach?
  13. How to retrieve the last autoincremented ID from a SQLite table?
  14. SQL Server Connection Strings – dot(“.”) or “(local)” or “(localdb)”
  15. Synchronous database queries with Node.js
  16. How can I avoid SQL injection attacks?
  17. Supertype-subtype database design
  18. Why should I use document based database instead of relational database?
  19. Good Free Alternative To MS Access [closed]
  20. SQLite insert speed slows as number of records increases due to an index
  21. What’s wrong with nullable columns in composite primary keys?
  22. wikidata get all properties with labels and values of an item
  23. Convert String ISO-8601 date to oracle’s timestamp datatype
  24. How should you build your database from source control?
  25. Strange behavior in PowerShell function returning DataSet/DataTable
  26. Populating Spinner From SQLite Database Android
  27. SQL DataType – How to store a year?
  28. Maximum number of rows in a sqlite table
  29. Any example of a necessary nullable foreign key?
  30. Mysql service won’t start, InnoDB init function error

Leave a Comment