Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Version Numbers in SQLite
(versionnumbers.html)
1.2. The Historical Numbering System (Before 2015-10-14)
... The addition of common table expressions,
partial indexes, and indexes on expressions are all examples of
"minor" changes. Again, the distinction between "major" and "minor"
is subjective.
The patch level Z was historically only used for bug-fix releases
that ...
|
|
Command Line Shell For SQLite
(cli.html)
17. Index Recommendations (SQLite Expert)
... The shell tool recommends that the
user create a new index (index "x1_idx_000123a7") and outputs the plan
that the query would use in EXPLAIN QUERY PLAN format. The user then creates
an index with an equivalent schema and runs the ...
|
|
SQLite Library Footprint
(footprint.html)
... Library size will likely be larger
when including optional features such as full-text search or r-tree indexes,
or when using more aggressive compiler options such as -O3.
This document is intended only as a general guideline to the ...
|
|
Benefits of SQLite As A File Format
(aff_short.html)
... Applications can leverage the
full-text search and RTREE indexes and use triggers to implement
an automated undo/redo stack.
Performance problems can often be resolved, even late in the
development cycle, using CREATE INDEX, avoiding costly
redesign, rewrite, and ...
|
|
SQLite Keywords
(lang_keywords.html)
... EXISTS
EXPLAIN
FAIL
FILTER
FIRST
FOLLOWING
FOR
FOREIGN
FROM
FULL
GENERATED
GLOB
GROUP
GROUPS
HAVING
IF
IGNORE
IMMEDIATE
IN
INDEX
INDEXED
INITIALLY
INNER
INSERT
INSTEAD
INTERSECT
INTO
IS
ISNULL
JOIN
KEY
LAST
LEFT
LIKE
LIMIT
MATCH
MATERIALIZED
NATURAL
NO
NOT ...
|
|
C API: Determine The Collation For a Virtual Table Constraint
(c3ref/vtab_collation.html)
sqlite3_vtab_collation()
... The second argument
must be an index into the aConstraint[] array belonging to the
sqlite3_index_info structure passed to xBestIndex.
Important:
The first parameter must be the same pointer that is passed into the
xBestMethod() method. The first parameter may not ...
|
|
C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... Prohibit the use of SQL functions inside triggers, views,
CHECK constraints, DEFAULT clauses, expression indexes,
partial indexes, or generated columns
unless those functions are tagged with SQLITE_INNOCUOUS.
Prohibit the use of virtual tables inside of triggers or views
unless those ...
|
|
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 ...
... The leftmost column of the result set has the index 0.
The number of columns in the result can be determined using
sqlite3_column_count().
If the SQL statement does not currently point to a valid row, or if the
column index ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... Re-attempting the "DROP
TABLE" or "DROP INDEX" statement will return another SQLITE_LOCKED
error. In the implementation of sqlite3_blocking_step() shown to the
left, this could cause an infinite loop.
The caller could distinguish between this special "DROP TABLE|INDEX"
case ...
|
|
SQLite Older News
(oldnews.html)
... A problem appeared in the CREATE INDEX command beginning with
version 3.8.2 (2013-12-06) that allowed, under some circumstances,
a UNIQUE index to be created on a column that was not unique. Once
the index was created ...
|
Page generated by FTS5 in about 111.72 ms.