SQLITE_VTAB_CONSTRAINT_SUPPORT, SQLITE_VTAB_INNOCUOUS, SQLITE_VTAB_DIRECTONLY, SQLITE_VTAB_USES_ALL_SCHEMAS

 ... If the ON CONFLICT mode is ABORT, FAIL, IGNORE or ROLLBACK, SQLite is able to roll back a statement or database transaction, and abandon or continue processing the current SQL statement as appropriate. If the ON CONFLICT mode is REPLACE ... 

4.2. Evaluating OR constraints separately and taking the UNION of the result If and only if the previously described conversion of OR to an IN operator does not work, the second OR-clause optimization is attempted. Suppose the OR clause consists of multiple subterms as follows: expr1 OR expr2 OR expr3 Individual ... 

2.2. Compiling SQLite Programs  ... A language keyword like "SELECT" or "UPDATE". An identifier for a table or column or variable. Punctuation characters like "," or "==" or ";". Literal values: numeric or string constants. Whitespace or comments. Whitespace and comment tokens are discarded. All other tokens are ... 

 ... It exists, and Its size is greater than 512 bytes, and The journal header is non-zero and well-formed, and Its super-journal exists or the super-journal name is an empty string, and There is no RESERVED lock ... 

1. Situations Where SQLite Works Well  ... An SQLite database facilitates data transfer between systems even when the endpoints have different word sizes and/or byte orders. The data can be a complex mix of large binary blobs, text, and small numeric or boolean values. The data ... 

sqlite3_wal_checkpoint_v2()

 ... If database zDb is the name of an attached database that is not in WAL mode, SQLITE_OK is returned and both *pnLog and *pnCkpt set to -1. If zDb is not NULL (or a zero length string) and is not ... 

sqlite3_syscall_ptr(), struct sqlite3_vfs

 ... SQLite will use the xCurrentTimeInt64() method to get the current date and time if that method is available (if iVersion is 2 or greater and the function pointer is not NULL) and will fall back to xCurrentTime() if xCurrentTimeInt64() is ... 

4.9. The -> and ->> operators  ... The SQLite implementation of -> and ->> strives to be compatible with both MySQL and PostgreSQL. The -> and ->> operators take a JSON string or JSONB blob as their left operand and a PATH expression or object field label or array index as ... 

C-language Interface Specification for SQLite These pages are intended to be precise and detailed specification. For a tutorial introduction, see instead: SQLite In 5 Minutes Or Less and/or the Introduction To The SQLite C/C++ Interface. This same ... 

sqlite3_bind_parameter_name()

 ... In other words, the initial ":" or "$" or "@" or "?" is included as part of the name. Parameters of the form "?" without a following integer have no name and are referred to as "nameless" or "anonymous parameters". The first host parameter has ...