Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Virtual Table Indexing Information
(c3ref/index_info.html)
struct sqlite3_index_info, struct sqlite3_index_constraint, struct sqlite3_index_orderby ...
... A cost of log(N)
indicates that the expense of the operation is similar to that of a
binary search on a unique indexed field of an SQLite table with N rows.
The estimatedRows value is an estimate of the ...
|
|
Generated Columns
(gencol.html)
2.2. Capabilities
... Generated columns may have NOT NULL, CHECK, and UNIQUE constraints,
and foreign key constraints, just like ordinary columns.
Generated columns can participate in indexes, just like ordinary
columns.
The expression of a generated column can refer to any of the ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
3. Virtual Table Details
Each row in the spellfix1 virtual table has a unique rowid
with seven columns plus five extra hidden columns.
The columns are as follows:
rowid
A unique integer number associated with each
vocabulary item in the table. This can be ...
|
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
1.1. Limitations
... CHECK constraints,
FOREIGN KEY constraints, UNIQUE constraints, type constraints on
STRICT tables - any of these might be violated in the recovered
database.
Content might be moved from one table into another.
The recovery API does as good of a job ...
|
|
Database File Format
(fileformat.html)
2.5. Representation Of SQL Indices
Each SQL index, whether explicitly declared via a CREATE INDEX statement
or implied by a UNIQUE or PRIMARY KEY constraint, corresponds to an
index b-tree in the database file.
Each entry in the index b-tree corresponds to a ...
|
|
SQLite Older News
(oldnews.html)
... A problem appeared in the CREATE INDEX command beginning with
version 3.8.2 (2013-12-06) that allowed, under some circumstances,
a UNIQUE index to be created on a column that was not unique. Once
the index was created ...
|
|
The RBU Extension
(rbu.html)
2.2.1. The RBU Database Schema
... The data_% table should have no
PRIMARY KEY or UNIQUE constraints, but each column should have the same type as
the corresponding column in the target database. The rbu_control column should
have no type at all. For example, if the ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA quick_check
PRAGMA schema.quick_check;
PRAGMA schema.quick_check(N)
PRAGMA schema.quick_check(TABLENAME)
The pragma is like integrity_check except that it does not verify
UNIQUE constraints and does not verify
that index content matches table content. By skipping UNIQUE
and index consistency ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
5. PRIMARY KEYs Can Sometimes Contain NULLs
A PRIMARY KEY in an SQLite table is usually just
a UNIQUE constraint. Due to an historical oversight,
the column values of a PRIMARY KEY are allowed to be NULL.
This is a bug, but by the time the problem ...
|
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... The name must
be unique across all VFS modules.
SQLite guarantees that the zFilename parameter to xOpen
is either a NULL pointer or string obtained
from xFullPathname() with an optional suffix added.
If a suffix is added to the zFilename ...
|
Page generated by FTS5 in about 96.49 ms.