SELECT
(lang_select.html)
... Otherwise, the BINARY collation sequence is used.
In a compound SELECT statement, all ORDER BY expressions are handled
as aliases for one of the result columns of the compound.
If an ORDER BY expression is not an integer alias, then ...
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.1. The eval method
... If $bigstring is a large string or binary object, this
technique is not only easier to write, it is also much more efficient
since it avoids making a copy of the content of $bigstring.
If the $bigstring variable has both ...
|
Recent SQLite News
(news.html)
... This can significantly increase the
performance of applications that process large JSON
strings as it omits the need to translate JSON text
to and from the internal binary format used by SQLite.
A second noteworthy change is that any
application ...
|
The sqlite3_analyzer.exe Utility Program
(sqlanalyze.html)
1. The sqlite3_analyzer.exe Utility Program
The sqlite3_analyzer.exe binary is a command-line utility program
that measures and displays how much and how efficiently space is used by
individual tables and indexes with an SQLite database file.
Example usage:
sqlite3_analyzer database.sqlite
The output is ...
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
Overview
... Users input a term, or series
of terms, perhaps connected by a binary operator or grouped together into a
phrase, and the full-text query system finds the set of documents that best
matches those terms considering the operators and ...
|
The Virtual Database Engine of SQLite
(vdbe.html)
... Note that only the first 10
characters of string values are displayed and that binary
values (such as the result of the MakeRecord instruction) are
treated as strings. The only other datatype that can be stored
on the VDBE stack ...
|
The SQLite Bytecode Engine
(opcode.html)
3. Viewing The Bytecode
... nbsp;3 9 2 (BINARY) 51 if r[2]>=r[3] goto  ...
|
Page generated by FTS5 in about 46.37 ms.