... 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 ... 

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 ... 

 ... 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 ... 

16. 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 ... 

 ... 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 ... 

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 ... 

 ... 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 ... 

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 ... 

 ... 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 ... 

 ... 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 ...