Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Binding Values To Prepared Statements
(c3ref/bind_blob.html)
sqlite3_bind_blob(), sqlite3_bind_blob64(), sqlite3_bind_double(), sqlite3_bind_int(), sqlite3_bind_int64(), sqlite3_bind_null ...
... In this
case, the object and the provided pointer to it must remain valid until
either the prepared statement is finalized or the same SQL parameter is
bound to something else, whichever occurs sooner.
(3) The constant, SQLITE_TRANSIENT, may be ...
|
|
The Schema Table
(schematab.html)
3. Interpretation Of The Schema Table
... The CREATE, TABLE, VIEW, TRIGGER, and INDEX keywords at the beginning
of the statement are converted to all upper case letters.
The TEMP or TEMPORARY keyword is removed if it occurs after the
initial CREATE keyword.
Any database name qualifier ...
|
|
ANALYZE
(lang_analyze.html)
... It is
possible to construct a pathological case where an approximate ANALYZE
is noticeably inferior to a full-scan ANALYZE, but such cases are rare in
real-world problems.
A good rule of thumb seems to be to always set ...
|
|
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()
... This is because the
in this case the new values are not available. In this case, when a
callback made with op==SQLITE_DELETE is actually a write using the
sqlite3_blob_write() API, the sqlite3_preupdate_blobwrite() returns
the index of the column being ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.2.1. Adding Entries to a Zip Archive
... non-NULL value is provided using an UPDATE
statement, it is an error.
data
To insert a directory into the archive, this field must be set to
NULL. In this case if a value was explicitly specified for the "mode ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... statement that the third parameter
points to has just been executed. Or, if the fourth parameter is 2, then
the connection being passed as the second parameter is being closed. The
third parameter is passed NULL In this case. An ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
5. The LIKE Optimization
... that case we know that all of the
rows selected by the index will pass the LIKE or GLOB test.
Note that when the right-hand side of a LIKE or GLOB operator is
a parameter and the statement is ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... or more
SQL statements and/or queries to be processed.
A pointer to a callback function which is invoked once for each
row in the result of a query. This argument may be NULL, in which
case no callbacks will ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
... SQLite Does Not Do Full Unicode Case Folding By Default
SQLite does not know about the upper-case/lower-case distinction
for all unicode characters. SQL functions like
upper() and lower() only work on ASCII characters. There are two
reasons ...
|
|
C API: Result Values From A Query
(c3ref/column_blob.html)
sqlite3_column_blob(), sqlite3_column_double(), sqlite3_column_int(), sqlite3_column_int64(), sqlite3_column_text(), sqlite3_column_text16 ...
... In every case the first argument is a pointer
to the prepared statement that is being evaluated (the sqlite3_stmt*
that was returned from sqlite3_prepare_v2() or one of its variants)
and the second argument is the index of the column for ...
|
Page generated by FTS5 in about 154.69 ms.