Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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: Enable Or Disable Shared Pager Cache
(c3ref/enable_shared_cache.html)
sqlite3_enable_shared_cache()
... This method is disabled on MacOS X 10.7 and iOS version 5.0
and will always return SQLITE_MISUSE. On those systems,
shared cache mode should be enabled per-database connection via
sqlite3_open_v2() with SQLITE_OPEN_SHAREDCACHE.
This interface is threadsafe on ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
Page generated by FTS5 in about 77.59 ms.