struct sqlite3_blob

An instance of this object represents an open BLOB on which incremental BLOB I/O can be performed. Objects of this type are created by sqlite3_blob_open() and destroyed by sqlite3_blob_close(). The sqlite3_blob_read() and sqlite3_blob_write() interfaces can be used to read ... 

sqlite3_blob_bytes()

Returns the size in bytes of the BLOB accessible via the successfully opened BLOB handle in its only argument. The incremental blob I/O routines can only read or overwriting existing blob content; they cannot change the size of a ... 

sqlite3_blob_close()

This function closes an open BLOB handle. The BLOB handle is closed unconditionally. Even if this routine returns an error code, the handle is still closed. If the blob handle being closed was opened for read-write access, and if ... 

sqlite3_blob_reopen()

This function is used to move an existing BLOB handle so that it points to a different row of the same database table. The new row is identified by the rowid value passed as the second argument. Only the row ... 

sqlite3_blob_read()

This function is used to read data from an open BLOB handle into a caller-supplied buffer. N bytes of data are copied into buffer Z from the open BLOB, starting at offset iOffset. If offset iOffset is less than ... 

sqlite3_blob_write()

This function is used to write data into an open BLOB handle from a caller-supplied buffer. N bytes of data are copied from the buffer Z into the open BLOB, starting at offset iOffset. On success, sqlite3_blob_write() returns SQLITE_OK ... 

Internal Versus External BLOBs in SQLite If you have a database of large BLOBs, do you get better read performance when you store the complete BLOB content directly in the database or is it faster to store each BLOB in ... 

sqlite3_blob_open()

This interfaces opens a handle to the BLOB located in row iRow, column zColumn, table zTable in database zDb; in other words, the same BLOB that would be selected by: SELECT zColumn FROM zDb.zTable WHERE rowid = iRow; Parameter zDb ... 

SQLITE_INTEGER, SQLITE_FLOAT, SQLITE_BLOB, SQLITE_NULL

 ... 64-bit signed integer 64-bit IEEE floating point number string BLOB NULL These constants are codes for each of those types. Note that the SQLITE_TEXT constant was also used in SQLite version 2 for a completely different meaning. Software ... 

2.1. Read Performance Measurements  ... Then for each blob, the blob key value is bound to the ?1 parameter and the statement is evaluated to extract the blob content. The chart shows that on Windows10, content can be read from the SQLite database about 5 ...