Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Run-Time Loadable Extensions
(loadext.html)
1. Overview
SQLite has the ability to load extensions (including new
application-defined SQL functions,
collating sequences, virtual tables, and VFSes) at run-time.
This feature allows the code for extensions to be developed and
tested separately from the application and then ...
|
|
ANALYZE
(lang_analyze.html)
1. Overview
The ANALYZE command gathers statistics about tables and
indices and stores the collected information
in internal tables of the database where the query optimizer can
access the information and use it to help make better query planning choices ...
|
|
Quality Management
(qmplan.html)
1. Overview
This is the Quality Management Plan for SQLite.
Quality management documents tend to expand into
binders full of incomprehensible jargon that nobody
reads. This document strives to break that pattern by
being concise and useful.
The inspiration for this document ...
|
|
Profiling SQL Queries
(profile.html)
1. Overview
SQLite contains built-in support for profiling SQL queries, but it is not
enabled by default. In order to enable support for query profiling, SQLite must
be compiled with the following option:
-DSQLITE_ENABLE_STMT_SCANSTATUS
Building SQLite with this option enables the ...
|
|
ALTER TABLE
(lang_altertable.html)
1. Overview
SQLite supports a limited subset of ALTER TABLE.
The ALTER TABLE command in SQLite allows
these alterations of an existing table:
it can be renamed;
a column can be renamed;
a column can be added to it;
or ...
|
|
SQLite's Built-in printf()
(printf.html)
1. Overview
SQLite contains its own implementation of the string formatting routine "printf()",
accessible via the following interfaces:
format() → an SQL function returning the formatted string
sqlite3_mprintf() → Store the formatted string in memory obtained
sqlite3_malloc64().
sqlite3_snprintf() → Store the formatted ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
1. Overview
The SQL language is a "standard".
Even so, no two SQL database engines work exactly alike.
Every SQL implementation has it own peculiarities and oddities,
and SQLite is no exception to this rule.
This document strives to highlight the principal ...
|
|
Pointer Passing Interfaces
(bindptr.html)
1. Overview
Three new "_pointer()" interfaces were added to SQLite 3.20.0 (2017-08-01):
sqlite3_bind_pointer(),
sqlite3_result_pointer(), and
sqlite3_value_pointer().
Questions and confusion quickly arose
on the mailing lists about the purpose behind these new interfaces,
why they were introduced, and what ...
|
|
TH3
(th3.html)
1. Overview
SQLite Test Harness #3 (hereafter "TH3") is one of
three test harnesses used for testing SQLite.
TH3 meets the following objectives:
TH3 is able to run on embedded platforms that lack the support
infrastructure of workstations.
TH3 tests SQLite in ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
1. Overview
The Geopoly module is an alternative interface to the R-Tree extension that uses
the GeoJSON notation
(RFC-7946) to describe two-dimensional
polygons. Geopoly includes functions for detecting when one polygon is
contained within or overlaps with another, for ...
|
Page generated by FTS5 in about 51.59 ms.