Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Version 3 Overview
(version3.html)
... But BLOBs are stored in TEXT columns as BLOBs because
you cannot in general convert a BLOB into text.
In most other SQL database engines the datatype is associated with
the table column that holds the data - with the data ...
|
|
C API: Setting The Result Of An SQL Function
(c3ref/result_blob.html)
sqlite3_result_blob(), sqlite3_result_blob64(), sqlite3_result_double(), sqlite3_result_error(), sqlite3_result_error16(), sqlite3_result_error_toobig ...
... The sqlite3_result_blob() interface sets the result from
an application-defined function to be the BLOB whose content is pointed
to by the second parameter and which is N bytes long where N is the
third parameter.
The sqlite3_result_zeroblob(C,N ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... CROSS JOIN blob WHERE blob.rid=event.objid AND mtime<=2457647.121412037);
SELECT max(timestamp) FROM timeline;
SELECT julianday('2016-09-24 17:42:43',fromLocal());
SELECT EXISTS (SELECT 1 FROM event CROSS JOIN blob WHERE blob.rid=event ...
|
|
SQL Language Expressions
(lang_expr.html)
... Note that the result from casting any non-BLOB value into a
BLOB and the result from casting any BLOB value into a non-BLOB value
may be different depending on whether the database encoding is UTF-8,
UTF-16be ...
|
|
Implementation Limits For SQLite
(limits.html)
... Maximum length of a string or BLOB
The maximum number of bytes in a string or BLOB in SQLite is defined
by the preprocessor macro SQLITE_MAX_LENGTH. The default value
of this macro is 1 billion (1 thousand million or 1 ...
|
|
Pointer Passing Interfaces
(bindptr.html)
2.1. Upping The Threat Level
Passing around pointers as if they were integers or BLOBs is easy,
effective, and works well in an environment where the application
components are all friendly toward one another. However, passing pointers
as integers and BLOBs allows hostile SQL text ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
2. About Flexible Typing
... Column DatatypeTypes Allowed In That Column
INTEGERINTEGER, REAL, TEXT, BLOB
REALREAL, TEXT, BLOB
TEXTTEXT, BLOB
BLOBINTEGER, REAL, TEXT, BLOB
Note that an INTEGER or REAL value will never end up being stored
in a TEXT column, since an INTEGER or ...
|
|
The Session Extension
(sessionintro.html)
3.1. Capturing a Changeset
... Size of changeset blob in bytes */
void **ppChangeset /* OUT: Pointer to changeset blob */
){
sqlite3_session *pSession = 0;
int rc;
/* Create a new session object */
rc = sqlite3session_create(db, "main", &pSession);
/* Configure the session object to record changes to all tables */
if( rc ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... But many developers are surprised to learn that SQLite can read and
write smaller BLOBs (less than about 100KB in size) from its database
faster than those same blobs can be read or written as separate files
from the filesystem ...
|
|
The Carray() Table-Valued Function
(carray.html)
2. Availability
... The ability to bind an array of struct iovec
objects that are interpreted as BLOBs was added in SQLite version 3.41.0
(2023-02-21).
|
Page generated by FTS5 in about 107.53 ms.