BLOB
A storage class and column type for raw binary data, such as an image, stored exactly as given.
In more detail
BLOB stands for binary large object. SQLite stores blob values without any conversion. Fetching blob columns you do not need is one reason SELECT * is wasteful in application code.
Related terms
- storage class — In SQLite, the actual kind of a stored value: NULL, INTEGER, REAL, TEXT or BLOB.
- data type — The kind of a value, such as a whole number, text or a date, which decides what you can do with it and how it compares and sorts.
- SELECT * — A select list that asks for every column of the table, in the table's own order.
Taught in
- Data Types And What To Choose — PostgreSQL, Indexing & Relational Data Modeling
- The SELECT Statement And Projection — PostgreSQL, Indexing & Relational Data Modeling