ADDED images/foreignlogos/fb.gif Index: images/foreignlogos/fb.gif ================================================================== --- /dev/null +++ images/foreignlogos/fb.gif cannot compute difference between binary files Index: pages/amalgamation.in ================================================================== --- pages/amalgamation.in +++ pages/amalgamation.in @@ -130,11 +130,11 @@
The build process makes extensive use of the [http://www.tcl-lang.org/|Tcl] scripting language. You will need to have a copy of TCL installed in order for the make targets above to work. Easy-to-use installers can be obtained from [http://www.tcl-lang.org/]. -May unix workstations of Tcl installed by default. +Many unix workstations have Tcl installed by default.
The build process also uses [http://en.wikipedia.org/wiki/AWK|AWK]. AWK is almost always installed by default on unix-like workstations, but it may need to be downloaded and installed on Windows development platforms. There are many versions of AWK available for Windows. Index: pages/autoinc.in ================================================================== --- pages/autoinc.in +++ pages/autoinc.in @@ -33,11 +33,11 @@ which is unique among all rows in the same table. ([WITHOUT ROWID] tables are the exception.)
-^(You can access the ROWID of an SQLite table using one the special column +^(You can access the ROWID of an SQLite table using one of the special column names ROWID, _ROWID_, or OID. Except if you declare an ordinary table column to use one of those special names, then the use of that name will refer to the declared column not to the internal ROWID.)^
Index: pages/docs.in ================================================================== --- pages/docs.in +++ pages/docs.in @@ -100,10 +100,22 @@ } doc {Pragma commands} {pragma.html} { This document describes SQLite performance tuning options and other special purpose database commands. } +doc {Core SQL Functions} {lang_corefunc.html} { + General-purpose built-in scalar SQL functions. +} +doc {Aggregate SQL Functions} {lang_aggfunc.html} { + General-purpose built-in aggregate SQL functions. +} +doc {Date and Time SQL Functions} {lang_datefunc.html} { + SQL functions for manipulating dates and times. +} +doc {JSON SQL Functions} {json1.html} { + SQL functions for creating, parsing, and querying JSON content. +} doc {DataTypes} {datatype3.html} { SQLite version 3 introduces the concept of manifest typing, where the type of a value is associated with the value itself, not the column that it is stored in. This page describes data typing for SQLite version 3 in further detail. Index: pages/fileformat2.in ================================================================== --- pages/fileformat2.in +++ pages/fileformat2.in @@ -649,11 +649,11 @@ zero or more byte which have the high-order bit set followed by a single byte with the high-order bit clear, or nine bytes, whichever is shorter. The lower seven bits of each of the first eight bytes and all 8 bits of the ninth byte are used to reconstruct the 64-bit twos-complement integer. Varints are big-endian: bits taken from the earlier byte of the varint -are the more significant and bits taken from the later bytes. +are the more significant than bits taken from the later bytes.The format of a cell depends on which kind of b-tree page the cell appears on. The following table shows the elements of a cell, in order of appearance, for the various b-tree page types.
Index: pages/index.in ================================================================== --- pages/index.in +++ pages/index.in @@ -1,10 +1,9 @@
-WelcomeSQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional @@ -16,12 +15,12 @@ More... Sponsors-Ongoing development and maintenance of SQLite is -sponsored in part by SQLite Consortium + Substantial support for the continuing enhancement and maintenance +of SQLite comes from SQLite Consortium members, including:
|