All geek questions in one place

Difference Between Blob and File

What is the difference between saving a file (e.g. AVI) as a Blob in the data store to save it as a regular AVI file on a web server?

Thank!

Joel

+3
source share
3 answers

A file stored on the server will be a regular file file. But databases have tables for storing data. So, when you want to save the file in the database, there is a special field, which is a field Binary Large Objects (BLOB). This allows you to store a stream of bytes in the database just like any other field. It does not save the file type and any other attributes that the file system can support. You must know the type of file when reading from the database. It is usually stored in another text field in the same table.

+4
source

eg. it can be easily removed or replaced if it is placed in FS. On the other hand, storing and retrieving it from the database may not be acceptable in certain scenarios.

, , . , .

0

Here is an article from Microsoft Research on storing large objects in a database and storing them in a file system. Since 2006, but maybe a starting point?

http://research.microsoft.com/apps/pubs/default.aspx?id=64525

0
source

Source: https://habr.com/ru/post/1757788/

More articles:


All Articles