sqlite3_stmt_readonly()

 ... But because the SELECT statement does not change the database file directly, sqlite3_stmt_readonly() would still return true. Transaction control statements such as BEGIN, COMMIT, ROLLBACK, SAVEPOINT, and RELEASE cause sqlite3_stmt_readonly() to return true, since the statements themselves do not actually ... 

sqlite3_commit_hook(), sqlite3_rollback_hook()

 ... Note that running any other SQL statements, including SELECT statements, or merely calling sqlite3_prepare_v2() and sqlite3_step() will modify the database connections for the meaning of "modify" in this paragraph. Registering a NULL function disables the callback. When the commit hook ... 

sqlite3_snapshot_open()

 ... If there is already a read transaction open on schema S, then the database handle must have no active statements (SELECT statements that have been passed to sqlite3_step() but not sqlite3_reset() or sqlite3_finalize()). SQLITE_ERROR is returned if either of these ... 

sqlite3_unlock_notify()

 ... If the blocked connection is attempting to obtain a write-lock on a shared-cache table, and more than one other connection currently holds a read-lock on the same table, then SQLite arbitrarily selects one of the other connections ... 

 ... SELECT name FROM (SELECT * FROM sqlite_schema UNION ALL SELECT * FROM sqlite_temp_schema) WHERE type='table' ORDER BY name (8) Are there any known size limits to SQLite databases? See limits.html for a full discussion of the limits of SQLite. (9 ... 

2. Details The designed query interface is: SELECT DISTINCT candidate COLLATE nocase FROM completion($prefix, $wholeline) ORDER BY 1; The query above will return suggestions for the whole input word that begins with $prefix. The $wholeline parameter is all text from the ... 

 ... CREATE TABLE t1(x REAL); INSERT INTO t1 VALUES(1.55e+308),(1.23),(3.2e-16),(-1.23),(-1.55e308); SELECT sum(x), decimal_sum(x) FROM t1; The large values ±1.55e+308 cancel each other out, but ... 

3.10. The geopoly_regular(X,Y,R,N) Function  ... SELECT '<svg width="600" height="300">'; WITH t1(x,y,n,color) AS (VALUES (100,100,3,'red'), (200,100,4,'orange'), (300,100,5,'green'), (400,100,6,'blue'), (500,100,7,'purple'), (100,200,8,'red'), (200 ... 

SQLITE_SCANSTAT_NLOOP, SQLITE_SCANSTAT_NVISIT, SQLITE_SCANSTAT_EST, SQLITE_SCANSTAT_NAME, SQLITE_SCANSTAT_EXPLAIN, SQLITE_SCANSTAT_SELECTID ... 

 ... The select-id is the same value as is output in the first column of an EXPLAIN QUERY PLAN query. SQLITE_SCANSTAT_PARENTID The "int" variable pointed to by the V parameter will be set to the the id of the parent ... 

 ... How INDEXED BY Works The INDEXED BY phrase forces the SQLite query planner to use a particular named index on a DELETE, SELECT, or UPDATE statement. The INDEXED BY phrase is an SQLite extension and is not portable to other ...