Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Version Numbers in SQLite
(versionnumbers.html)
1.3. Version History
Chronology
Change log
|
|
SQLite Download Page
(download.html)
SQLite Download Page
Source Code
sqlite-src-3490100.zip(13.71 MiB)
Complete canonical source tree for SQLite version 3.49.1, include test cases and
extensions. This is a snapshot of all code under version control at the time ...
|
|
File Format Changes in SQLite
(formatchng.html)
... SQLite 3.7.0 and later can read and write all database files created
by earlier versions of SQLite. And earlier versions of SQLite can
read and write database files created by SQLite 3.7.0 and later
as long ...
|
|
JSON Functions And Operators
(json1.html)
3. Interface Overview
SQLite stores JSON as ordinary text.
Backwards compatibility constraints mean that SQLite is only able to
store values that are NULL, integers, floating-point numbers, text,
and BLOBs. It is not possible to add a new "JSON" type.
|
|
Maintaining Private Branches Of SQLite
(privatebranch.html)
3.8. Further Updates
As new versions of SQLite are released, repeat steps 3.6 and 3.7 to
add changes in the new release to the private branch.
Additional private changes can be
made on the private branch in between releases if desired.
|
|
CREATE INDEX
(lang_createindex.html)
... Only versions of SQLite 3.3.0 (2006-01-11)
and later are able to understand
the descending index format. For compatibility, version of SQLite between 3.3.0
and 3.7.9 use the legacy schema format by default ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
3. Thread Related Issues
In SQLite versions 3.3.0 through 3.4.2 when shared-cache mode is enabled,
a database connection may only be
used by the thread that called sqlite3_open() to create it.
And a connection could only share cache with ...
|
|
SQLite: Single File Database
(onefile.html)
... The SQLite database file format is also stable.
All releases of SQLite version 3 can read and write database
files created by the very first SQLite 3 release (version 3.0.0)
going back to 2004-06-18. This is ...
|
|
Deterministic SQL Functions
(deterministic.html)
3.1. Bug fix in version 3.35.2
When the enhancement was made to SQLite 3.20.0 such that date/time
functions would be considered deterministic as they do not depend
on the current time, one case was overlooked:
Many of the date/time functions can be ...
|
|
Profiling SQL Queries
(profile.html)
3. Complex Cases - Rows, Loops and Cycles
... AS v1 CROSS JOIN
ft('sqlite'),
cnt
WHERE cnt.i=ft.rowid AND v1.a=ft.rowid;
<...query results...>
QUERY PLAN (cycles=177665334 [100%])
|--CO-ROUTINE v1 (cycles=4500444 [3%])
| |--SCAN t1 (cycles=397052 ...
|
Page generated by FTS5 in about 356.78 ms.