Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... It is not necessary to retrieve data in the format specify by
sqlite3_column_type(). If a different format is requested, the data
is converted automatically.
Data format conversions can invalidate the pointer returned by
prior calls to sqlite3_column_blob(), sqlite3_column_text(), and/or ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA reverse_unordered_selects
PRAGMA reverse_unordered_selects;
PRAGMA reverse_unordered_selects = boolean;
When enabled, this PRAGMA causes many SELECT statements without
an ORDER BY clause to emit their results in the reverse order from what
they normally would. This can help debug applications that are
making invalid ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
4. Typical Usage Of Core Routines And Objects
... For queries, extract results by calling
sqlite3_column() in between
two calls to sqlite3_step().
Destroy the prepared statement using sqlite3_finalize().
The foregoing is all one really needs to know in order to use SQLite
effectively. All the rest is optimization and ...
|
|
The Checksum VFS Shim
(cksumvfs.html)
... However, in
complex situations where multiple VFS shims are being loaded,
it might be important to ensure that cksumvfs is loaded in the
correct order so that it sequences itself into the default VFS
Shim stack in the right order ...
|
|
C API: Data Change Notification Callbacks
(c3ref/update_hook.html)
sqlite3_update_hook()
The sqlite3_update_hook() interface registers a callback function
with the database connection identified by the first argument
to be invoked whenever a row is updated, inserted or deleted in
a rowid table.
Any callback set by a previous call to this ...
|
|
C API: Status Parameters for prepared statements
(c3ref/c_stmtstatus_counter.html)
SQLITE_STMTSTATUS_FULLSCAN_STEP, SQLITE_STMTSTATUS_SORT, SQLITE_STMTSTATUS_AUTOINDEX, SQLITE_STMTSTATUS_VM_STEP, SQLITE_STMTSTATUS_REPREPARE, SQLITE_STMTSTATUS_RUN ...
... SQLITE_STMTSTATUS_AUTOINDEX
This is the number of rows inserted into transient indices that
were created automatically in order to help joins run faster.
A non-zero value in this counter may indicate an opportunity to
improvement performance by adding permanent indices ...
|
|
C API: Convenience Routines For Running Queries
(c3ref/free_table.html)
sqlite3_get_table(), sqlite3_free_table()
... A result table is memory data structure created by the
sqlite3_get_table() interface. A result table records the
complete query results from one or more queries.
The table conceptually has a number of rows and columns. But
these numbers are not ...
|
|
Compile-time Options
(compile.html)
3. Platform Configuration
... The "sqlite_cfg.h" file usually contains other configuration options, especially
"HAVE_INTERFACE" type options generated by the configure process. Note that this
header is intended only for use for platform-level configuration, not library-level
configuration. To set SQLite-level configuration ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... An SQLITE_OPEN_TRANSIENT_DB holds a database table that
SQLite creates automatically in order to evaluate a subquery or
ORDER BY or GROUP BY clause. Both TEMP_DB and TRANSIENT_DB databases
are private and are deleted automatically. TEMP_DB databases last
for the duration ...
|
|
WAL-mode File Format
(walformat.html)
2. The WAL-Index File Format
... database
by multiple clients, and as a cache to help clients quickly locate frames
within the wal file.
Because the shm file is not involved in recovery, the shm file does not
need to be machine byte-order independent. Hence ...
|
Page generated by FTS5 in about 223.93 ms.