Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Foreign Key Support
(foreignkeys.html)
3. Required and Suggested Database Indexes
... SELECT rowid FROM <child-table> WHERE <child-key> = :parent_key_value
If this SELECT returns any rows at all, then SQLite concludes that
deleting the row from the parent table would violate the foreign key
constraint and returns ...
|
|
Transaction
(lang_transaction.html)
... In very old versions of SQLite (before version 3.7.11 - 2012-03-20)
the ROLLBACK will fail with an error code
SQLITE_BUSY if there are any pending queries. In more recent
versions of SQLite, the ROLLBACK will proceed and ...
|
|
The Base85() SQL Function
(base85.html)
... The base85() function is not a standard part of SQLite.
It must be loaded as a separate extension. The source code to
base85() is in the
base85.c source file
in the ext/misc/ folder of the
SQLite source tree ...
|
|
Measuring and Reducing CPU Usage in SQLite
(cpu.html)
2.3. Performance Measurement
Cachegrind is used to
measure performance because it gives answers that are repeatable to
7 or more significant digits. In comparison, actual (wall-clock)
run times are scarcely repeatable beyond one significant digit.
|
|
Write-Ahead Logging
(wal.html)
3.3. Persistence of WAL mode
... The persistence of WAL mode means that applications can be converted
to using SQLite in WAL mode without making any changes to the application
itself. One has merely to run "PRAGMA journal_mode=WAL;" on the
database file(s) using the ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... 3.0 The Extended API
Only the three core routines described in section 1.0 are required to use
SQLite. But there are many other functions that provide
useful interfaces. These extended routines are as follows:
int sqlite_last_insert_rowid(sqlite*);
int ...
|
|
SQLite Archive Files
(sqlar.html)
3. Disadvantages Of SQLite Archives
... As an example, the following table show the relative sizes for an
SQLite Archive, a ZIP Archive, and a Tarball of the 1,743 files
in the SQLite 3.22.0 source tree:
SQLite Archive10,754,048
ZIP Archive (using ...
|
|
C API: Database Connection Handle
(c3ref/sqlite3.html)
struct sqlite3
Each open SQLite database is represented by a pointer to an instance of
the opaque structure named "sqlite3". It is useful to think of an sqlite3
pointer as an object. The sqlite3_open(), sqlite3_open16(), and
sqlite3_open_v2() interfaces are its constructors, and ...
|
|
WAL-mode File Format
(walformat.html)
2.1.3. WAL Locks
... SQLite since
some VFSes (ex: Windows) might implement locks using mandatory file locks.
These are the eight locks supported:
WAL-Index Locks Controlled By xShmLock()
NameOffset
xShmLockFile
WAL_WRITE_LOCK
0
120
WAL_CKPT_LOCK
1
121
WAL_RECOVER_LOCK
2
122
WAL_READ_LOCK(0)
3
123 ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
9.3.2. Segment B-Tree Interior Nodes
The following diagram depicts the format of a segment b-tree interior
(non-leaf) node.
Segment B-Tree Interior Node Format
|
Page generated by FTS5 in about 367.69 ms.