Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Version Numbers in SQLite
(versionnumbers.html)
1.2. The Historical Numbering System (Before 2015-10-14)
... The minor version number Y was historically incremented for new
features and/or new interfaces that did not significantly change
the structure of the code. The addition of common table expressions,
partial indexes, and indexes on expressions are all examples ...
|
|
SQLite Is Transactional
(transactional.html)
... SQLite implements
serializable
transactions that are atomic, consistent, isolated, and durable,
even if the transaction is interrupted by a program crash, an
operating system crash, or a power failure to the computer.
We here restate and amplify the previous sentence ...
|
|
Isolation In SQLite
(isolation.html)
... Suppose there are two database connections X and Y. X starts
a read transaction using BEGIN followed by one or more SELECT statements.
Then Y comes along and runs an UPDATE statement to modify the database.
X can subsequently do ...
|
|
SQLite Backup API
(backup.html)
3.1. File and Database Connection Locking
... This allows other threads
to use database connection pDb and other connections to write to the
underlying database file.
If another thread or process writes to the source database while this
function is sleeping, then SQLite detects this and usually ...
|
|
VACUUM
(lang_vacuum.html)
... However, when not in write-ahead log mode, the
page_size and/or auto_vacuum properties of an existing database may be
changed by using the page_size and/or
pragma auto_vacuum pragmas and then immediately VACUUMing
the database. When in write-ahead ...
|
|
C API: Prepared Statement Scan Status
(c3ref/stmt_scanstatus.html)
sqlite3_stmt_scanstatus(), sqlite3_stmt_scanstatus_v2()
These interfaces return information about the predicted and measured
performance for pStmt. Advanced applications can use this
interface to compare the predicted and the measured performance and
issue warnings and/or rerun ANALYZE if discrepancies are found.
Since this interface ...
|
|
C API: Memory Allocation Routines
(c3ref/mem_methods.html)
struct sqlite3_mem_methods
... A pointer to an instance of this object is the argument to
sqlite3_config() when the configuration option is
SQLITE_CONFIG_MALLOC or SQLITE_CONFIG_GETMALLOC.
By creating an instance of this object
and passing it to sqlite3_config(SQLITE_CONFIG_MALLOC)
during configuration, an application can specify ...
|
|
Datatypes In SQLite version 2
(datatypes.html)
... But some notion of type comes into play
when sorting and comparing data. For these purposes, a column or
an expression can be one of two types: numeric and text.
The sort or comparison may give different results depending on ...
|
|
Using SQLite In Multi-Threaded Applications
(threadsafe.html)
4. Run-time selection of threading mode
... The
SQLITE_OPEN_NOMUTEX flag causes the database connection to be in the
multi-thread mode and the SQLITE_OPEN_FULLMUTEX flag causes the connection
to be in serialized mode. If neither flag is specified or if
sqlite3_open() or sqlite3_open16() are used instead of ...
|
|
SQLite FTS5 Extension
(fts5.html)
3.7. FTS5 Boolean Operators
... MATCH 'one two three' -- 'one AND two AND three'
... MATCH 'three "one two"' -- 'three AND "one two"'
... MATCH 'NEAR(one two) three' -- 'NEAR(one two) AND three'
... MATCH 'one OR two three' -- 'one OR two AND three'
... MATCH 'one NOT ...
|
Page generated by FTS5 in about 579.13 ms.