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 ...
|
|
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().
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
10. Dubious SQL Is Allowed Without Any Error Or Warning
... There are now millions of applications that take advantage of
SQLite's flexible and forgiving design choices.
We cannot change SQLite to follow the current preference toward
strict and dogmatic behavior without breaking those legacy applications.
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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 ...
|
Page generated by FTS5 in about 515.94 ms.