Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... The argument is of type (void**)
- an array of two (void *) values. The first (void *) actually points
to a function of type (int (*)(void *)). In order to invoke the connection's
busy-handler, this function should be invoked with the ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
3. Benefits Of WITHOUT ROWID Tables
... The special "INTEGER PRIMARY KEY" column type in ordinary SQLite tables
causes the column to be an alias for the rowid, and so an INTEGER PRIMARY
KEY is a true PRIMARY KEY. But any other kind of PRIMARY KEYs, including ...
|
|
SQL Language Expressions
(lang_expr.html)
... operator the conversion always takes place even if the conversion
lossy and irreversible, whereas column affinity only changes the data type
of a value if the change is lossless and reversible.
If the value of expr is NULL, then the ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... The pointer
passed as the second argument must point to a value of type (int).
If this value is greater than 0, it is used as the new streaming data
chunk size for both input and output. Before returning, the ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... SQLITE_MISMATCH
This error occurs when there is an attempt to insert non-integer
data into a column labeled INTEGER PRIMARY KEY. For most columns, SQLite
ignores the data type and allows any kind of data to be stored. But
an ...
|
|
SQLite FTS5 Extension
(fts5.html)
7.2.2. Custom Auxiliary Functions API Reference
... Each extension function is allocated a single auxiliary data slot for
each FTS query (MATCH expression). If the extension function is invoked
more than once for a single FTS query, then all invocations share a
single auxiliary data context.
If ...
|
|
Imposter Tables
(imposter.html)
... A table b-tree contains a 64-bit integer key and arbitrary data.
The 64-bit integer key is the ROWID. Index b-trees contain
an arbitrary binary key and no data. So table b-trees and index
b-trees ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... P5 is a bitmask of data types. SQLITE_INTEGER is the least significant
(0x01) bit. SQLITE_FLOAT is the 0x02 bit. SQLITE_TEXT is 0x04.
SQLITE_BLOB is 0x08. SQLITE_NULL is 0x10.
WARNING: This opcode does not reliably distinguish between NULL and REAL
when ...
|
|
JSON Functions And Operators
(json1.html)
4.23.1. Examples using json_each() and json_tree()
... To see a complete line-by-line decomposition of the data:
SELECT big.rowid, fullkey, value
FROM big, json_tree(big.json)
WHERE json_tree.type NOT IN ('object','array');
In the previous, the "type NOT IN ('object','array')" term of the ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
3. Core Objects And Interfaces
... Instead, what we here call "sqlite3_column()"
is a place-holder for an entire family of functions that return
a value from the result set in various data types. There are also routines
in this family that return the size of ...
|
Page generated by FTS5 in about 104.13 ms.