3. Required and Suggested Database Indexes  ... If they are not the primary key, then the parent key columns must be collectively subject to a UNIQUE constraint or have a UNIQUE index. If the parent key columns have a UNIQUE index, then that index must use the ... 

7. Implementation Of Shared-Memory For The WAL-Index The wal-index is implemented using an ordinary file that is mmapped for robustness. Early (pre-release) implementations of WAL mode stored the wal-index in volatile shared-memory, such as files created in /dev/shm on Linux or /tmp ... 

sqlite3_bind_parameter_count()

 ... This routine actually returns the index of the largest (rightmost) parameter. For all forms except ?NNN, this will correspond to the number of unique parameters. If parameters of the ?NNN form are used, there may be gaps in the list ... 

 ... Full-featured SQL implementation with advanced capabilities like partial indexes, indexes on expressions, JSON, common table expressions, and window functions. (Omitted features) A complete database is stored in a single cross-platform disk file. Great for use as an application ... 

1. The RBU Extension  ... But if an SQL table has one or more indexes, the key order for each index may be different from the main table and the other auxiliary indexes. As a result, when executing a series of INSERT, UPDATE and DELETE ... 

 ... Used by:   column-constraint   table-constraint See also:   lang_altertable.html   lang_conflict.html   lang_createtable.html   lang_createtable.html#notnullconst create-index-stmt: Used by:   sql-stmt References:  ... 

sqlite3_stmt_status()

 ... For example, if the number of table steps greatly exceeds the number of table searches or result rows, that would tend to indicate that the prepared statement is using a full table scan rather than an index. This interface is ... 

sqlite3_bind_parameter_name()

 ... The first host parameter has an index of 1, not 0. If the value N is out of range or if the N-th parameter is nameless, then NULL is returned. The returned string is always in UTF-8 encoding ... 

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

sqlite3_unlock_notify()

 ... When executing a "DROP TABLE" or "DROP INDEX" statement, SQLite checks if there are any currently executing SELECT statements that belong to the same connection. If there are, SQLITE_LOCKED is returned. In this case there is no "blocking connection", so ...