Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLite R*Tree Module
(rtree.html)
1. Overview
... The implementation found in SQLite is a refinement of Guttman's original
idea, commonly called "R*Trees", that was described by
Norbert Beckmann, Hans-Peter Kriegel, Ralf Schneider, Bernhard Seeger:
The R*-Tree: An Efficient and Robust Access Method for ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA Statements
The PRAGMA statement is an SQL extension specific to SQLite and used to
modify the operation of the SQLite library or to query the SQLite library for
internal (non-table) data. The PRAGMA statement is issued using the ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
1. Overview
... However,
depending on configuration options and the a particular version of SQLite
you are using, the Geopoly extension may or may not be enabled by default.
To ensure that Geopoly is enabled for your build,
add the -DSQLITE_ENABLE_GEOPOLY=1 compile ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
Overview
FTS3 and FTS4 are SQLite virtual table modules that allows users to perform
full-text searches on a set of documents. The most common (and effective)
way to describe full-text searches is "what Google, Yahoo, and Bing do
with ...
|
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
Syntax Diagrams For SQLite
aggregate-function-invocation:
References: expr filter-clause ordering-term
See also: lang_aggfunc.html lang_expr.html#*funcinexpr
alter-table-stmt:
Used by: sql-stmt
References ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
SQLite Session Module C/C++ Interface
This page defines the C-language interface to the SQLite
session extension.
This is not a tutorial. These pages are designed to be precise, not easy
to read. A tutorial is available separately.
This ...
|
|
The SQLite Bytecode Engine
(opcode.html)
1. Executive Summary
... This document describes SQLite internals. The information provided
here is not needed for routine application development using SQLite.
This document is intended for people who want to delve more deeply into
the internal operation of SQLite.
The bytecode engine is ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
The Virtual Database Engine of SQLite
Obsolete Documentation Warning:
This document describes the virtual machine used in SQLite version 2.8.0.
The virtual machine in SQLite version 3.0 and 3.1 is similar in
concept but is now ...
|
|
SQLite FTS5 Extension
(fts5.html)
1. Overview of FTS5
FTS5 is an SQLite virtual table module that provides
full-text search
functionality to database applications. In their most elementary form,
full-text search engines allow the user to efficiently search a large
collection of documents for the subset that ...
|
|
History Of SQLite Releases
(chronology.html)
History Of SQLite Releases
DateVersion
2025-02-18
3.49.1
2025-02-06
3.49.0
2025-01-14
3.48.0
2024-12-07
3.47.2
2024-11-25
3.47.1
2024-10-21
3.47 ...
|
Page generated by FTS5 in about 624.77 ms.