Should you store files in a database or file system?

Question

Files will be in sync with the database so cannot be orphaned from it which gives you an upper hand in tracking transactions. Backups automatically include file binaries. More Secure than saving in a File System. 28 февр. 2017 г.

Should I store files in database or filesystem?

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).

Why is it better to store data in a database rather than in the file system?

Easy recovery: Since database systems keeps the backup of data, it is easier to do a full recovery of data in case of a failure. Flexible: Database systems are more flexible than file processing systems.

Is it good to store file in database?

Then why store files in DB ? DB provides ACID compliance(Atomicity, Consistency, Isolation, Durability) for each row. DB provides data integrity between the file and its metadata. Database Security is available by default.

Is it bad to store files in database?

Storing files in the database slows down overall query performance simply because there is more data transmitted between the application and the database. Additionally, files use up RAM which is used internally by the database to improve performance.

Expert · Answer