Can you store files in database?

Question

Reasons in favor of storing files in the database: Having the files and database in sync and able to participate in transactions can be very useful. Files go with the database and cannot be orphaned from it. Backups automatically include the file binaries. 29 мая 2012 г.

Is storing files in database good idea?

Also, keep in mind that Web servers are cheap and you can easily add more to balance the load, whereas the database is the most expensive and hardest to scale part of a web architecture usually. There are some opposite examples (e.g., Microsoft Sharepoint), but usually, storing files in the database is not a good idea.

Should you store files in a database or file system?

Database provides a proper data recovery process while file system did not. In terms of security the database is more secure then the file system (usually). The migration process is very easy in File system just copy and paste into the target while for database this task is not as simple.

Why is it bad to store files in a database?

Storing files in the database slows down overall query performance simply because there is more data transmitted between the application and the database. ... Data that isn't stored in RAM has to be read from disk which is always much slower than RAM.

Expert · Answer