User images – database vs. filesystem storage [duplicate]

by

In general, it is better to store files on the file system. File systems are already tuned for storing files. However, this does have its drawbacks, particularly in terms of management, backup, restore and it is somewhat of a flimsy tie between a varchar file path field in the database and a file in the file system. What database system are you using? I think if you are using SQL Server 2008, that the new FileStream type gives a very good method for storing files in that database.

Edit: Note I’m really talking about more generally about storing files in the database. There is some extra complexity involved in trying to store images you intend to display on HTML pages in the database.

More Related Contents:

  1. Storing Images : DB or File System –
  2. Storing Images in DB – Yea or Nay?
  3. Entity Framework and Connection Pooling
  4. LINQ to SQL Left Outer Join
  5. Storing a file in a database as opposed to the file system?
  6. store image in database or in a system file? [closed]
  7. My images are blurry! Why isn’t WPF’s SnapsToDevicePixels working?
  8. how to use views in code first entity framework [closed]
  9. Determine file type of an image
  10. Extracting files from an Attachment field in an Access database
  11. Directory.EnumerateFiles => UnauthorizedAccessException
  12. MS Access (MDB) concurrency
  13. Cannot attach the file *.mdf as database
  14. Data Access Layer design patterns
  15. Analyze colors of an Image
  16. How to cancel a long-running Database operation?
  17. How can I create database tables from XSD files?
  18. How to edit EXIF data in .NET [closed]
  19. How do I reliably get an image dimensions in .NET without loading the image?
  20. Implementing transactions over multiple databases
  21. How can I determine if a file is an image file in .NET?
  22. How do I bind a Byte array to an Image in WPF with a value converter?
  23. What is the alternative of service broker in azure to get notification on insert or update db?
  24. Best Practices for uploading files to database
  25. is it safe to keep database connections open for long time
  26. How to Consume WCF Service with Android
  27. Why can’t DateTime.ParseExact() parse “9/1/2009” using “M/d/yyyy”
  28. How to dispose a class in .net?
  29. .net implementation of bcrypt
  30. Drawing Pixels in WPF

Leave a Comment