Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... The value returned by sqlite_offset(X) might reference either the
original table or an index, depending on the query. If the value X would
normally be extracted from an index, the sqlite_offset(X) returns the
offset to the corresponding index ...
|
|
Defense Against The Dark Arts
(security.html)
1.1. Untrusted SQL Inputs
... For that reason,
no table, index, view, or trigger definition can be much larger than the
precision limit. You can set a precision limit of less than 100000,
but be careful that whatever precision limit you use is at least ...
|
|
STRICT Tables
(stricttables.html)
2. STRICT Tables
... work the same.
COLLATE clauses work the same.
Generated columns work the same.
ON CONFLICT clauses work the same.
Indexes work the same.
AUTOINCREMENT works the same.
An INTEGER PRIMARY KEY column is an alias for the rowid, but an ...
|
|
Architecture of SQLite
(arch.html)
... Separate B-trees are used for
each table and each index in the database. All B-trees are stored in the
same disk file. The file format details are stable and well-defined and
are guaranteed to be compatible moving ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... Added a new R*Tree index extension.
|
|
SQLite As An Application File Format
(appfileformat.html)
... In either case, if performance problems do arise in an SQLite application
those problems can often be resolved by adding one or two CREATE INDEX
statements to the schema or perhaps running ANALYZE one time
and without having to touch ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... This "timeline" query demonstrates that SQLite can easily process complex
relational database queries involving multiple tables, subqueries, and
complex WHERE clause constraints, and it can make effective use of indexes
to solve the queries with minimal disk I/O.
Following ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... This can serve as a warning to application designers that the
database might benefit from additional indexes.
(513) SQLITE_ERROR_RETRY
The SQLITE_ERROR_RETRY is used internally to provoke sqlite3_prepare_v2()
(or one of its sibling routines for creating prepared statements) to
try again ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... CREATE TABLE slide(
pageNumber INTEGER, -- The slide page number
slideContent TEXT -- Slide content as XML or JSON
);
CREATE INDEX slide_pgnum ON slide(pageNumber); -- Optional
The content of each slide could still be stored as compressed XML.
But now each page ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.1. Standard Unix VFSes
... Also keeps the wal-index in heap rather than in
shared memory.
unix-none - all file locking operations are no-ops.
unix-namedsem - uses named semaphores for file locking.
VXWorks only.
The various unix VFSes differ only in the way ...
|
Page generated by FTS5 in about 103.14 ms.