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.
|
|
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 ...
|
|
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. The source repository is public and is
readable by anonymous passersby on ...
|
|
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 ...
|
|
C API: Compile-Time Library Version Numbers
(c3ref/c_source_id.html)
SQLITE_VERSION, SQLITE_VERSION_NUMBER, SQLITE_SOURCE_ID
The SQLITE_VERSION C preprocessor macro in the sqlite3.h header
evaluates to a string literal that is the SQLite version in the
format "X.Y.Z" where X is the major version number (always 3 for
SQLite3) and Y is ...
|
Page generated by FTS5 in about 358.26 ms.