3. Required and Suggested Database Indexes  ... CREATE TABLE parent2(a, b, PRIMARY KEY(a,b)); CREATE TABLE child8(x, y, FOREIGN KEY(x,y) REFERENCES parent2); -- Ok CREATE TABLE child9(x REFERENCES parent2); -- Error! CREATE TABLE child10(x,y,z, FOREIGN KEY(x,y,z) REFERENCES ... 

3.1. The URI Path  ... On windows, if the absolute path begins with "/X:/" where X is any single ASCII alphabetic character ("a" through "z" or "A" through "Z") then the "X:" is understood to be the drive letter of the volume containing the file ... 

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

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

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