Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite's Built-in printf()
(printf.html)
3. Implementation And History
... The sqlite3VXPrintf() function began as code written by the first author
of SQLite (Hipp) when he was a graduate student at Duke University in the
late 1980s. Hipp kept this printf() implementation in his personal toolbox until
he started working ...
|
|
Profiling SQL Queries
(profile.html)
3. Complex Cases - Rows, Loops and Cycles
... sqlite> SELECT * FROM
t2,
(SELECT count(*) AS cnt, d FROM t2 GROUP BY d) AS v2
WHERE v2.d=t2.d AND t2.d>100
ORDER BY v2.cnt;
<...query results...>
QUERY PLAN (cycles=6234376 [100%] ...
|
|
The Carray() Table-Valued Function
(carray.html)
... The "value" of each row in the carray() is taken from a C-language array
supplied by the application via parameter binding.
In this way, the carray() function provides a convenient mechanism to
bind C-language arrays to SQL queries ...
|
|
C API: Configuring The SQLite Library
(c3ref/config.html)
sqlite3_config()
The sqlite3_config() interface is used to make global configuration
changes to SQLite in order to tune SQLite to the specific needs of
the application. The default configuration is recommended for most
applications and so this routine is usually not necessary ...
|
|
SQLite Copyright
(copyright.html)
... Contributed Code
In order to keep SQLite completely free and unencumbered by copyright,
the project does not accept patches. If you would like to suggest a
change and you include a patch as a proof-of-concept, that would
be ...
|
|
Full-Featured SQL
(fullsql.html)
... ACID transactions using BEGIN, COMMIT, and ROLLBACK
Nested transactions using SAVEPOINT, RELEASE, and
ROLLBACK TO
Subqueries, including correlated subqueries
Up to 64-way joins
LEFT, RIGHT, and FULL OUTER JOINs
DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
UNION ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
10.1. UTF-16 byte-order-mark problem
... More specifically, the bug can be triggered by any of the following:
A UTF-16 byte-order-mark (BOM) is embedded at the beginning of an SQL string
literal value inserted into an FTS3 table. For example:
INSERT INTO fts_table ...
|
|
C API: Determine If An SQL Statement Is Complete
(c3ref/complete.html)
sqlite3_complete(), sqlite3_complete16()
... If SQLite has not been initialized using sqlite3_initialize() prior
to invoking sqlite3_complete16() then sqlite3_initialize() is invoked
automatically by sqlite3_complete16(). If that initialization fails,
then the return value from sqlite3_complete16() will be non-zero
regardless of whether or not the input ...
|
|
C API: Run-Time Limit Categories
(c3ref/c_limit_attached.html)
SQLITE_LIMIT_LENGTH, SQLITE_LIMIT_SQL_LENGTH, SQLITE_LIMIT_COLUMN, SQLITE_LIMIT_EXPR_DEPTH, SQLITE_LIMIT_COMPOUND_SELECT, SQLITE_LIMIT_VDBE_OP ...
... SQLITE_LIMIT_COLUMN
The maximum number of columns in a table definition or in the
result set of a SELECT or the maximum number of columns in an index
or in an ORDER BY or GROUP BY clause.
SQLITE_LIMIT_EXPR_DEPTH
The maximum depth ...
|
|
SQLite FTS5 Extension
(fts5.html)
5.1.1. The bm25() function
... Since the default sorting order is
"ascending", this means that appending "ORDER BY bm25(ft)" to a query would
cause results to be returned in order from worst to best. The "DESC" keyword
would be required in order to return ...
|
Page generated by FTS5 in about 223.19 ms.