Is it good to store file 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 it a good idea to store files in DB?

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.

Why is it better to store data in a database rather than in the 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.

What is the most efficient way to store files?

Let's look at some of the best ways you can store your digital files:1Desktop Storage. Despite many external solutions for digital files, some people still store their photos, videos, and content files on their desktop or laptop. ... 2Cold Storage. ... 3Social Media Storage. ... 4Cloud Storage. ... 5Personal Hybrid Cloud Storage.Top Ways to Store Your Digital Files - Amber X

Expert · Answer