Small. Fast. Reliable.
Choose any three.

Search results 61..70 of 103 for: "x\"

C API: Load An Extension
(c3ref/load_extension.html)
sqlite3_load_extension()
 ... If that does not work, it constructs a name "sqlite3_X_init" where the X is consists of the lower-case equivalent of all ASCII alphabetic characters in the filename from the last "/" to the first following "." and omitting any initial "lib ... 
C API: Checkpoint a database
(c3ref/wal_checkpoint_v2.html)
sqlite3_wal_checkpoint_v2()
The sqlite3_wal_checkpoint_v2(D,X,M,L,C) interface runs a checkpoint operation on database X of database connection D in mode M. Status information is written back into integers pointed to by L and C. The M parameter must be ... 
Memory-Mapped I/O
(mmap.html)
 ... If the hard upper bound on mmap_size is non-zero at compilation time, it may still be reduced or zeroed at start-time using the sqlite3_config(SQLITE_CONFIG_MMAP_SIZE,X,Y) interface. The X and Y parameters must both be 64-bit ... 
SQLite Query Language: upsert
(lang_UPSERT.html)
 ... 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; Limitations UPSERT ... 
Deterministic SQL Functions
(deterministic.html)
1. Overview  ... For example, the abs(X) function always returns the same answer as long as its input X is the same. Non-deterministic functions might give different answers on each invocation, even if the arguments are always the same. The following ... 
Database File Format
(fileformat.html)
4.2. Checksum Algorithm  ... In other words, if the inputs are x(0) through x(N) then N must be odd. The checksum algorithm is as follows: s0 = s1 = 0 for i from 0 to n-1 step 2: s0 += x(i) + s1; s1 ... 
 ... CREATE TABLE t1(a); CREATE TABLE t2(x); SELECT * FROM (SELECT t1.a FROM t1 JOIN t2 ORDER BY t2.x LIMIT 1) ORDER BY 1; In version 3.5.9 the query above would return a single column named ... 
C API: Create and Destroy VFS Filenames
(c3ref/create_filename.html)
sqlite3_create_filename(), sqlite3_free_filename()
 ... The memory obtained from sqlite3_create_filename(X) must be released by a corresponding call to sqlite3_free_filename(Y). The P parameter in sqlite3_create_filename(D,J,W,N,P) should be an array of 2*N pointers to strings. Each pair of pointers ... 
C API: Unlock Notification
(c3ref/unlock_notify.html)
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 ... 
UPSERT
(lang_upsert.html)
 ... 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 ... 

12345678910

Page generated by FTS5 in about 171.91 ms.