Is it better to store files in database or filesystem?

Question

Advantage of the File System over Data base Management System is: When handling small data sets with arbitrary, probably unrelated data, file is more efficient than database. For simple operations, read, write, file operations are faster and simple. You can find n number of difference over internet. 30 июн. 2016 г.

Is it good idea to store files 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.

Why is database better than file system?

Privacy: Limited access means privacy of data. Easy access to data – Database systems manages data in such a way so that the data is easily accessible with fast response times. 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.

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.

Which database is best for storing files?

There are basically two types SQL and NoSQL. I would suggest go for NoSQL for storing large data of videos and images. Encrypt these data and save in database and since NoSQL is much faster than SQL, so data is fetched very fast. So mongodb is best according to me.

Expert · Answer