Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Row Values
(rowvalue.html)
3.4. Update multiple columns of a table based on a query
... As new documents are added to the repository, they are not indexed right
away. Indexing is deferred until there is a search request. The
ftsdocs table contains an "idxed" field which is true if the document
has been indexed and ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
DELETE
(lang_delete.html)
... The INDEXED BY and NOT INDEXED clauses are not allowed on DELETE
statements within triggers.
The LIMIT and ORDER BY clauses (described below) are unsupported for
DELETE statements within triggers.
The RETURNING clause is not supported for triggers.
3. Optional ...
|
Page generated by FTS5 in about 100.55 ms.