Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLITE_MEMSTAT Virtual Table
(memstat.html)
2. Usage
... For example, only the
high-water mark is meaningful for SQLITE_STATUS_MALLOC_SIZE, and
only the current value is meaningful for SQLITE_DBSTATUS_CACHE_USED.
For rows where one or the other of VALUE or HIWTR is not meaningful,
that value is returned as NULL ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
1.1. Syntax
... One can write "WITHOUT rowid" or "without rowid" or "WiThOuT rOwId" and
it will mean the same thing.
Every WITHOUT ROWID table must have a PRIMARY KEY. An error is raised
if a CREATE TABLE statement with the WITHOUT ROWID ...
|
|
Partial Indexes
(partialindex.html)
3. Queries Using Partial Indexes
... If W is AND-connected terms and X is
OR-connected terms and if any term of W
appears as a term of X, then the partial index is usable.
For example, let the index be
CREATE INDEX ex1 ON ...
|
|
C API: Define New Collating Sequences
(c3ref/create_collation.html)
sqlite3_create_collation(), sqlite3_create_collation_v2(), sqlite3_create_collation16()
These functions add, remove, or modify a collation associated
with the database connection specified as the first argument.
The name of the collation is a UTF-8 string
for sqlite3_create_collation() and sqlite3_create_collation_v2()
and a UTF-16 string in native byte ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
10. Dubious SQL Is Allowed Without Any Error Or Warning
... This used to be considered good design - that a system would accept
dodgy inputs and try to do the best it could without complaining too much.
But lately, people have come to realize that it is sometimes better to
be ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.20. The xSavepoint, xRelease, and xRollbackTo Methods
... None of the xSavepoint(), xRelease(), or xRollbackTo() methods will ever
be called except in between calls to xBegin() and
either xCommit() or xRollback().
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
2.4. Unlinking or renaming a database file while in use
... Windows does not allow this to occur.)
Since rollback journals and WAL files are based on the name of the database
file, the two different database files will share the same rollback
journal or WAL file. A rollback or recovery ...
|
|
C API: Name Of The Folder Holding Database Files
(c3ref/data_directory.html)
... Hence, if this variable is modified directly, either it should be
made NULL or made to point to memory obtained from sqlite3_malloc
or else the use of the data_store_directory pragma should be avoided.
See also lists of
Objects,
Constants, and ...
|
|
Features Of SQLite
(features.html)
Features Of SQLite
Transactions
are atomic, consistent, isolated, and durable (ACID)
even after system crashes and power failures.
Zero-configuration
- no setup or administration needed.
Full-featured SQL implementation
with advanced capabilities like partial indexes,
indexes on expressions, JSON,
common ...
|
|
How To Compile SQLite
(howtocompile.html)
2. Amalgamation Versus Individual Source Files
SQLite is built from over one hundred files of C code and script
spread across multiple directories. The implementation of SQLite is pure
ANSI-C, but many of the C-language source code files are either
generated or transformed by ...
|
Page generated by FTS5 in about 558.81 ms.