4. Auxiliary Functions - Snippet, Offsets and Matchinfo  ... query expression>; The three auxiliary functions are only useful within a SELECT statement that uses the FTS table's full-text index. If used within a SELECT that uses the "query by rowid" or "linear scan" strategies, then the ... 

 ... On Windows, Microsoft's documentation says that locking may not work under FAT filesystems if you are not running the Share.exe daemon. People who have a lot of experience with Windows tell me that file locking of network files ... 

 ... sqlite3_randomness() provides access to SQLite's internal pseudo-random number generator, sqlite3_limit() allows size limits to be set at run-time on a per-connection basis, and sqlite3_context_db_handle() is a convenience routine that allows an application-defined SQL function implementation ... 

 ... For changes to rows in tables that are not attached to the Session object, the filter is called to determine whether changes to the table's rows should be tracked or not. If xFilter returns 0, changes are not tracked ... 

6.5. The 'deletemerge' Configuration Option  ... Instead, a "tombstone" marker containing the rowid of the deleted row is attached to the b-tree that contains the row's FTS index entries. When the b-tree is queried, any query result rows for which there exist tombstone ...