Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
Moving From SQLite 3.5.9 to 3.6.0
SQLite version 3.6.0 (2008-07-16)
contains many changes. As is the custom with
the SQLite project, most changes are fully backwards compatible.
However, a few of the ...
|
|
Change in Default Page Size in SQLite Version 3.12.0
(pgszchng2016.html)
The Default Page Size Change of SQLite 3.12.0
1.0 Introduction
An SQLite database file consists of one or more "pages".
For a single database file, all pages are the same size, though
for different database files, the ...
|
|
SQLite Version 3 Overview
(version3.html)
... Version 2.8 of SQLite will not read a version 3.0 database
files and version 3.0 of SQLite will not read a version 2.8 database file.
To convert an SQLite 2.8 database into an SQLite 3 ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... An Introduction To The SQLite C/C++ Interface
SQLite C/C++ Reference Guide
C/C++ Interface For SQLite Version 3
1.0 Overview
SQLite version 3.0 is a new version of SQLite, derived from
the SQLite 2.8.13 ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
Moving From SQLite 3.4.2 to 3.5.0
SQLite version 3.5.0 (2007-09-04) introduces a new OS interface layer that
is incompatible with all prior versions of SQLite. In addition,
a few existing interfaces have ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
This document was originally created in early 2004 when SQLite version 2
was still in widespread use and was written to introduce
the new concepts of SQLite version 3 to readers who were already familiar
with SQLite version 2. But ...
|
|
Recent SQLite News
(news.html)
... Map of all changes since the 3.32.0 release:
https://www.sqlite.org/src/timeline?p=version-3.32.3&bt=version-3.32.0
2020-06-04 - Release 3.32.2
The 3.32.2 release is a ...
|
|
8+3 Filenames
(shortnames.html)
SQLite And 8+3 Filenames
The default configuration of SQLite assumes the underlying filesystem
supports long filenames.
SQLite does not impose any naming requirements on database files.
SQLite will happily work with a database file that has any filename extension ...
|
|
SQLite Older News
(oldnews.html)
2015-11-02 - Release 3.9.2
SQLite version 3.9.2 is a patch release fixing two obscure bugs.
(Details: (1),
(2)).
Upgrade only if you are having problems.
2015-10-16 - Release 3.9.1
SQLite version 3 ...
|
|
Row Values
(rowvalue.html)
3.1. Scrolling Window Queries
... What really happens
with "LIMIT x OFFSET y" is that SQLite computes the query as
"LIMIT x+y" and discards the first y values without returning them
to the application. So as the window scrolls down toward
the bottom of ...
|
Page generated by FTS5 in about 360.87 ms.