Small. Fast. Reliable.
Choose any three.
Choose any three.
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
6. Binding Parameters and Reusing Prepared Statements
... SQLite allows a parameter wherever a string literal,
blob literal, numeric constant, or NULL is allowed
in queries or data modification statements. (DQL or DML)
(Parameters may not be used for column or table names,
or as values for constraints ...
|
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... String and BLOB values that do not look like numbers are
interpreted as 0.
The result of avg() is always a floating point value whenever
there is at least one non-NULL input even if all
inputs are integers. The ...
|
|
Why Is SQLite Coded In C
(whyc.html)
1.1. Performance
An intensively used low-level library like SQLite needs to be fast.
(And SQLite is fast, see Internal Versus External BLOBs and
35% Faster Than The Filesystem for example.)
C is a great language for writing fast code. C is ...
|
|
RETURNING
(lang_returning.html)
... This means that if a statement has a RETURNING clause that generates
a large amount of output, either many rows or large
string or BLOB values, then the statement might use a lot of
temporary memory to hold those values ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... The sqlite3_step()
interface will only return SQLITE_SCHEMA back to the application if
the failure persists after these many retries.
(18) SQLITE_TOOBIG
The SQLITE_TOOBIG error code indicates that a string or BLOB was
too large. The default maximum length of a ...
|
|
Architecture of SQLite
(arch.html)
... Individual values
(strings, integer, floating point numbers, and BLOBs) are stored
in an internal object named "Mem" which is implemented by
vdbemem.c.
SQLite implements SQL functions using callbacks to C-language routines.
Even the built-in SQL functions are ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
3.4. The geopoly_blob(P) Function
If P is a polygon, then geopoly_blob(P) returns the binary encoding
of that polygon as a BLOB.
If P is not a polygon, geopoly_blob(P) returns NULL.
|
|
Command Line Shell For SQLite
(cli.html)
7.3. File I/O Functions
... sqlite> CREATE TABLE images(name TEXT, type TEXT, img BLOB);
sqlite> INSERT INTO images(name,type,img)
...> VALUES('icon','jpeg',readfile('icon.jpg'));
The writefile(X,Y) SQL function write the blob Y into the file named ...
|
|
Distinctive Features Of SQLite
(different.html)
... They play special tricks for handling
BLOBs and CLOBs which can be of wildly varying length. But for most
tables, if you declare a column to be a VARCHAR(100) then the database
engine will allocate
100 bytes of disk ...
|
|
Run-Time Loadable Extensions
(loadext.html)
4.1. Example Extensions
... compress.c —
Implementation of application-defined SQL functions compress() and
uncompress() that do zLib compression of text or blob content.
json1.c —
Implementation of JSON SQL functions and table-valued functions.
This is a larger and more complex ...
|
Page generated by FTS5 in about 116.84 ms.