Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

Can you save files in a database?

Contents
  1. Is it possible to store files in database?
  2. Should I store files in a database?
  3. Should you store files in a database or file system?
Yes, generally the best way to store a file in a database is to save the byte array in a BLOB column. You will probably want a couple of columns to additionally store the file's metadata such as name, extension, and so on. 5 апр. 2010 г.


Is it possible to store files in database?

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.

Should I store files in a 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.

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

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours