|
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 ...
|
|
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 ...
|
|
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 ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... 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 ...
|
|
SQLite Foreign Key Support
(foreignkeys.html)
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 ...
|
|
Uniform Resource Identifiers
(uri.html)
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 ...
|
|
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 ...
|
|
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 ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
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 ...
|
Page generated by FTS5 in about 89.17 ms.