Would you store binary data in database or in file system? [closed]

by

The advantage of storing data in the DB is taking advantage of DB security mechanisms and reducing maintanence cost (backups, …). The disadvantage of it is increasing DB load and consuming connections (which might be expensive for per-connection licensed database servers). If you are using SQL Server 2008, FILESTREAM might be a nice alternative.

By the way, for Web apps (or any other apps that might need streaming the data), it’s usually more sensible to store data outside DB.

More Related Contents:

  1. Difference between partition key, composite key and clustering key in Cassandra?
  2. To Do or Not to Do: Store Images in a Database [duplicate]
  3. Can I have multiple primary keys in a single table?
  4. Android Pre-Populated Database [duplicate]
  5. How to handle authentication/authorization with users in a database?
  6. How to use mongoimport to import csv
  7. What is the difference between an entity relationship model and a relational model?
  8. Best practices for storing postal addresses in a database (RDBMS)?
  9. Best way to test a MS Access application?
  10. How to backup sqlite database?
  11. What are the advantages of using a single database for EACH client?
  12. Is it possible to generate django models from the database?
  13. Run a single Maven plugin execution?
  14. How to create an auto delete mechanism for firestore? (deleting data after time period) [closed]
  15. Do stored procedures run in database transaction in Postgres?
  16. What is a View in Oracle?
  17. Normal forms – 2nd vs 3rd – is the difference just composite keys? non trivial dependency?
  18. Is there any NoSQL data store that is ACID compliant?
  19. Convert SQLITE SQL dump file to POSTGRESQL
  20. How to think in data stores instead of databases?
  21. Alternatives to Entity-Attribute-Value (EAV)?
  22. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  23. Spring Batch Framework – Auto create Batch Table
  24. Connect to a heroku database with pgadmin
  25. What are the main differences between Redis Pub/Sub and Redis Stream?
  26. Does anyone know of a good library for mapping a person’s name to his or her gender? [closed]
  27. Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)
  28. Should OLAP databases be denormalized for read performance? [closed]
  29. “Cannot drop database because it is currently in use”. How to fix?
  30. Is writing server log files to a database a good idea?

Leave a Comment