Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The sqlite3_analyzer.exe Utility Program
(sqlanalyze.html)
1.2. Example Output
The following is sqlite3_analyzer output for an example
places.sqlite database used by Firefox.
/** Disk-Space Utilization Report For ██████████████████/places.sqlite
Page ...
|
|
SQLite Database Speed Comparison
(speed.html)
... Executive Summary
A series of tests were run to measure the relative performance of
SQLite 2.7.6, PostgreSQL 7.1.3, and MySQL 3.23.41.
The following are general
conclusions drawn from these experiments:
SQLite 2.7.6 ...
|
|
Window Functions
(windowfunctions.html)
3. Built-in Window Functions
As well as aggregate window functions, SQLite features a set of built-in
window functions based on
those supported by PostgreSQL.
Built-in window functions honor any PARTITION BY clause in the same way
as aggregate window functions - each selected ...
|
|
C API: Extended Result Codes
(c3ref/c_abort_rollback.html)
SQLITE_ERROR_MISSING_COLLSEQ, SQLITE_ERROR_RETRY, SQLITE_ERROR_SNAPSHOT, SQLITE_IOERR_READ, SQLITE_IOERR_SHORT_READ, SQLITE_IOERR_WRITE ...
... In an effort to
address this, newer versions of SQLite (version 3.3.8 2006-10-09
and later) include
support for additional result codes that provide more detailed information
about errors. These extended result codes are enabled or disabled ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
3.3. The geopoly_area(P) Function
If P is a polygon, then geopoly_area(P) returns the area enclosed by
that polygon. If P is not a polygon, geopoly_area(P) returns NULL.
|
|
Quality Management
(qmplan.html)
5.3.1. SQLite Source Code
The SQLite source code and the TCL test suite are stored together
in a single repository. This one repository is all that is required to
build the SQLite source. The source repository is public and is
readable by anonymous passersby ...
|
|
CREATE TABLE
(lang_createtable.html)
... Generated columns are supported beginning with SQLite version 3.31.0 (2020-01-22).
See the separate documentation for details on the capabilities and
limitations of generated columns.
3.5. The PRIMARY KEY
Each table in SQLite may have at ...
|
|
The WITH Clause
(lang_with.html)
... The ability for the recursive-select to be a compound
was added in version 3.34.0 (2020-12-01). In earlier versions of
SQLite, the recursive-select could only be a single
simple SELECT statement.
The basic algorithm for ...
|
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... The iVersion value started out as 1 in
SQLite version 3.5.0 on 2007-09-04, then increased to 2
with SQLite version 3.7.0 on 2010-07-21, and then increased
to 3 with SQLite version 3 ...
|
|
Database Remote-Copy Tool For SQLite
(rsync.html)
3. Limitations
The database files must both be in WAL mode, and must have the
same page-size. ← This limitation was removed in
version 3.50.0 (2025-05-29).
While sqlite3_rsync is running, REPLICA is read-only.
Queries can be ...
|
Page generated by FTS5 in about 336.61 ms.