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 @@ SQLite Home Page
-

Welcome

SQLite 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:

@@ -63,11 +62,19 @@ alt="expensify.org" border="0">\ ' - count = 5 + sponsor[5] = '' + + count = 6 while( count>0 ){ i = Math.floor(Math.random()*6) if( sponsor[i]!=null ){ document.write(sponsor[i]) sponsor[i] = null Index: pages/mostdeployed.in ================================================================== --- pages/mostdeployed.in +++ pages/mostdeployed.in @@ -53,11 +53,11 @@ Precise numbers are difficult to obtain and so exact rankings are impossible. But our best guess is that SQLite is the second mostly widely deployed software library, after libz. Some commentators observe that SQLite tends to be statically linked and thus have multiple instances on -each machine, whereas libz tend sto have just +each machine, whereas libz tends to have just a single instance per machine in the form of a shared library or DLL. So even though the number of devices containing libz may be greater than the number of devices that contain SQLite, the total number of instances per device might be higher for SQLite and so SQLite might
\ Expensify - \ We power the most exciting companies in the world using SQLite.
\ + \ + facebook.com\ + \ + Facebook - \ + Giving people the power to share and make the world \ + more open and connected.