sqlite3_unlock_notify()

 ... For example, if connection X is waiting for connection Y's transaction to be concluded, and similarly connection Y is waiting on connection X's transaction, then neither connection will proceed and the system may remain deadlocked indefinitely. To avoid ... 

4. Download Copies Of The Precompiled Amalgamation The amalgamation and the sqlite3.h header file are available on the download page as a file named sqlite-amalgamation-X.zip where the X is replaced by the appropriate version number.

 ... INSERT INTO t1 SELECT * FROM t2 ON CONFLICT(x) DO UPDATE SET y=excluded.y; Ambiguity resolved using a WHERE clause: INSERT INTO t1 SELECT * FROM t2 WHERE true ON CONFLICT(x) DO UPDATE SET y=excluded.y; 3. Limitations ... 

7.4. The "merge=X,Y" command The "merge=X,Y" command (where X and Y are integers) causes SQLite to do a limited amount of work toward merging the various inverted index b-trees of an FTS3/4 table together into one large b-tree. The ... 

7.2. Coverage testing of defensive code  ... In release builds, these macros are pass-throughs: #define ALWAYS(X) (X) #define NEVER(X) (X) During most testing, however, these macros will throw an assertion fault if their argument does not have the expected truth value. This alerts the ... 

2.20. The xSavepoint, xRelease, and xRollbackTo Methods  ... When xSavepoint(X,N) is invoked, that is a signal to the virtual table X that it should save its current state as savepoint N. A subsequent call to xRollbackTo(X,R) means that the state of the virtual table ... 

2. Loading An Extension  ... load_extension(X,Y). It works just like the sqlite3_load_extension() C interface. Both methods for loading an extension allow you to specify the name of an entry point for the extension. You can leave this argument blank - passing in a NULL ... 

2.1. Use of reallocarray()  ... Instead, SQLite does allocations of the form "X+C" or "N*X+C" or "M*N*X+C" or "N*X+M*Y+C", and so forth. The reallocarray() interface is not helpful in avoiding integer overflow in those cases ... 

8.3. File I/O Functions  ... The readfile(X) SQL function reads the entire content of the file named X and returns that content as a BLOB. This can be used to load content into a table. For example: sqlite> CREATE TABLE images(name TEXT ... 

3. Security Implications  ... Suppose, for example, an application defines a new "system(X)" SQL function that runs its argument X as a command and returns the integer result code. Perhaps the implementation is like this: static void systemFunc( sqlite3_context *context, int argc, sqlite3_value ...