blobbinaryfilesbinary-data

Difference between binary file and BLOB


Watching this video about how to design Tinder, at 06:50 a point is being made about files vs BLOBS.

I wonder what the difference is between a large binary file and a BLOB (binary large object).

Do they differ by

What is the origin of difference? They sound quite similar to me.


Solution

  • When the video refers to BLOB (binary large object), it doesn't refer to any old collection of binary information (file). According to this wikipedia article, it specifically means

    collection of binary data stored as a single entity in a database management system.

    The distinction lies in the "database management system". A BLOB is managed by the DBMS, although it might still be stored in a file system. However, other files are stored directly stored in the file system, and often only a URI is stored in the database.