Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The UNION Virtual Table
(unionvtab.html)
... added at a later
time, but writing is not a part of the initial implementation.
Nota bene:
The sqlite3_blob_open() interface does not work for a union-vtab.
BLOB content must be read from the union-vtab using ordinary SQL statements.
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.29. The incrblob method
This method opens a TCL channel that can be used to read or write
into a preexisting BLOB in the database. The syntax is like this:
dbcmd incrblob ?-readonly?
?DB? TABLE ...
|
|
C API: Obtaining SQL Values
(c3ref/value_blob.html)
sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ...
... The returned value is one of SQLITE_INTEGER,
SQLITE_FLOAT, SQLITE_TEXT, SQLITE_BLOB, or SQLITE_NULL.
Other interfaces might change the datatype for an sqlite3_value object.
For example, if the datatype is initially SQLITE_INTEGER and
sqlite3_value_text(V) is called to extract a text value ...
|
|
Floating Point Numbers
(floatingpoint.html)
2.1.3. The ieee754_from_blob() and ieee754_to_blob() functions
The ieee754_to_blob(F) SQL function converts the floating point number F
into an 8-byte BLOB that is the big-endian binary64 encoding of that number.
The ieee754_from_blob(B) function goes the other way, converting an 8-byte
blob into ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... SQLite understands the column type
of "VARCHAR(N)" to be the same as "TEXT", regardless of the value
of N.
(10) Does SQLite support a BLOB type?
SQLite allows you to store BLOB data in any
column, even columns that ...
|
|
C API: The pre-update hook.
(c3ref/preupdate_blobwrite.html)
sqlite3_preupdate_hook(), sqlite3_preupdate_old(), sqlite3_preupdate_count(), sqlite3_preupdate_depth(), sqlite3_preupdate_new(), sqlite3_preupdate_blobwrite()
... When the sqlite3_blob_write() API is used to update a blob column,
the pre-update hook is invoked with SQLITE_DELETE. This is because the
in this case the new values are not available. In this case, when a
callback made with ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... BLOB values
are rendered using SQL-standard hexadecimal BLOB notation. The
use of the quote() function ensures that the SQL statements used to
undo and redo are always safe from SQL injection.
Automatic Creation Of Triggers
Triggers such as the ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... New changeset iterator handle */
int nChangeset, /* Size of changeset blob in bytes */
void *pChangeset /* Pointer to blob containing changeset */
);
int sqlite3changeset_start_v2(
sqlite3_changeset_iter **pp, /* OUT: New changeset iterator handle */
int nChangeset, /* Size of changeset blob in bytes */
void *pChangeset, /* Pointer to ...
|
|
Compile-time Options
(compile.html)
2. Recommended Compile-time Options
... Historically, SQLite has allowed BLOB operands to the LIKE and GLOB
operators. But having a BLOB as an operand of LIKE or GLOB complicates
and slows the LIKE optimization. When this option is set, it means that
the LIKE and ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
4.1. Computing and controlling parameters M and n
... If the database
does contain large strings or BLOBs, they should be read using
incremental BLOB I/O and rows that contain the
large strings or BLOBs should never be update by any means other
than incremental BLOB I/O ...
|
Page generated by FTS5 in about 103.23 ms.