Can we save file in database?

Question

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. 8 нояб. 2011 г.

Should we save file in database?

Low Security. Since your files can be saved in a folder where you should have provided write permissions, it is prone to safety issues and invites troubles like hacking. So it is best to avoid saving in fs if you cannot afford to compromise in terms of security.

How can I store documents in database?

Store Files in SQL table1The “RootDirectory” column to store file location.2The “Filename” column to store the name of the file.3The “FileAttribute” column to store File attribute (Raw/Directory.4The “FileCreateDate” column to store file creation time.5The “FileSize” column to store the Size of the file.

Can a file be a database?

A database is generally used for storing related, structured data, with well defined data formats, in an efficient manner for insert, update and/or retrieval (depending on application). On the other hand, a file system is a more unstructured data store for storing arbitrary, probably unrelated data.

Which database is best for storing files?

Notice that these days most DB (and RDBMS such as PostGreSQL or MySQL and non-SQL DBMS such as MongoDB) are storing their data in files (that is, using raw disk partitions for the storage of DB has become out of fashion).

Expert · Answer