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 ...
|
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 ...
|
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 ...
|
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 ...
|
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().
|
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 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 ...
|
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 ...
|
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 ...
|
SQLite Backup API
(backup.html)
... The return values of the sqlite3_backup_step() and sqlite3_backup_finish()
calls are ignored and the error code indicating the success or failure of
the copy operation collected from the destination database connection
afterward.
Possible Enhancements
The implementation of this function could be ...
|
Page generated by FTS5 in about 306.39 ms.