Documentation Source Text

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

1639 check-ins using file art/syntax/all-bnf.html version e16f52bc1f

2019-04-08
18:08
Fix a minor error in the datatype documentation. (Leaf check-in: 87bef3d123 user: drh tags: branch-3.27)
2019-04-01
14:44
Improvements to VACUUM documentation - describe more clearly when another transaction might block a vacuum. (check-in: 0f897a0268 user: drh tags: branch-3.27)
2019-03-26
00:14
Update to the ".parameter" command documentation to conform to the latest implementation. (check-in: 9dab48bb9d user: drh tags: trunk)
2019-03-25
20:56
Updates to the change log for 3.28.0. (check-in: 32b82e8386 user: drh tags: trunk)
15:19
Update the CLI documentation to describe the new --insert option to ".archive" and the behavior change to the --update option. (check-in: bf3c223723 user: drh tags: trunk)
14:32
Import typo fixes from trunk. (check-in: 6f80f0890f user: drh tags: branch-3.27)
14:30
Fix a documentation error: The preprocessor macro is SQLITE_HAVE_ZLIB, not SQLITE_USE_ZLIB. However the USE_ZLIB=1 option is what Makefile.msc expects. (check-in: 85f5f65d9f user: drh tags: trunk)
2019-03-23
16:09
Add a note about the ".breakpoint" shell command to the "debugging.html" page. (check-in: 61444ae7e4 user: drh tags: trunk)
2019-03-22
15:04
Improvements to the debugging.html webpage. (check-in: ad08afecb8 user: drh tags: trunk)
2019-03-18
10:26
Updates to the size and speed graph spreadsheet. (check-in: c925c91186 user: drh tags: trunk)
2019-03-14
01:05
Fix a documentation typo. No changes to code. (check-in: 81fdc2faea user: mistachkin tags: trunk)
2019-03-07
00:26
Fix typos in the changelog for 3.28.0. (check-in: 6bd3d16e85 user: drh tags: trunk)
2019-03-06
15:16
Add the new sqlite3_stmt_isexplain() interface to the change log. (check-in: 13e71499bd user: drh tags: trunk)
15:03
Merge changes from the 3.27 branch. (check-in: 00f74a59cd user: drh tags: trunk)
2019-03-04
23:49
New expensify logo. (check-in: 81ea50fc28 user: drh tags: branch-3.27)
2019-03-02
17:13
Merge fixes from the 3.27 branch. (check-in: dcc4d55e47 user: drh tags: trunk)
17:12
Add an initial change log for the 3.28 development cycle. (check-in: f41d1a3db0 user: drh tags: trunk)
2019-03-01
13:27
Update the JSON parsing speed in the json1.html documentation. (check-in: 393a3d19ae user: drh tags: branch-3.27)
2019-02-28
17:29
Documentation on the bind_falback method of the TCL interface. (check-in: fb20146338 user: drh tags: trunk)
2019-02-27
23:13
Add a note to the printf() documentation to make clear that the built-in SQLite printf() does not implement positional parameters. (check-in: e0c57dd3d0 user: drh tags: branch-3.27)
16:51
Add documentation for the Tcl command "db function" -returntype option. (check-in: 2f154421cf user: dan tags: trunk)
13:46
Updates to the althttpd.md documentation. (check-in: 9ea89e32bf user: drh tags: trunk)
13:20
Sanitize the search string when doing a search against the changelog. (check-in: 0a969667a7 user: drh tags: trunk)
13:08
In althttpd.c, add a newline after error message replies. (check-in: 12f6c3b314 user: drh tags: trunk)
2019-02-25
16:46
Add a news item for the 3.27.2 release. (check-in: f52168899f user: drh tags: trunk)
16:10
Version 3.27.2 (check-in: 4604e54aca user: drh tags: trunk, release, version-3.27.2)
2019-02-18
20:35
Fix typos in the fileformat2.html page. (check-in: eecca5ae5e user: drh tags: trunk)
15:33
Change "the following three queries" to "the following four queries" in fts5.in. (check-in: b5b65a3c13 user: dan tags: trunk)
15:22
Clarification of the StrAppend() routine in althttpd.c. (check-in: 90fe325e31 user: drh tags: trunk)
2019-02-16
16:42
Extra defensive coding in althttpd.c. (check-in: 2ae41f4427 user: drh tags: trunk)
15:41
Enhancements to the althttpd.c SCGI mechanism: Added the "fallback:" and "relight:" lines to the *.scgi specification file format. (check-in: 1c981267ee user: drh tags: trunk)
2019-02-15
21:21
Send the SCGI environment variable with a value of "1" on SCGI requests. (check-in: 216ba4ebe1 user: drh tags: trunk)
20:56
Extra security in althttpd.c. (check-in: 45c1cd9fae user: drh tags: trunk)
20:31
Add SCGI support to the althttpd.c web server. (check-in: 201d18b836 user: drh tags: trunk)
20:31
Mention the use of SCGI in the althttpd.md file. (Closed-Leaf check-in: d2ad0c8ca6 user: drh tags: althttpd-scgi)
20:27
Updates to comments. Use size_t instead of int where appropriate. (check-in: 5faf086850 user: drh tags: althttpd-scgi)
20:14
Preliminary support for SCGI in althttpd. (check-in: b3aaed91ba user: drh tags: althttpd-scgi)
18:16
In althttpd.c, refactor some of the CGI processing logic as a preliminary step toward adding SCGI support. (check-in: 3e667aef3a user: drh tags: trunk)
17:00
Enhancements to althttpd.c: Add the --input FILE command-line option to simplify debugging using lldb. Improvements to comments. (check-in: a537e6f3fc user: drh tags: trunk)
11:43
Fix a typo in the ALTER TABLE documentation. (check-in: 625c9fbdad user: drh tags: trunk)
2019-02-12
13:54
Fix a typo in loadext.html. (check-in: 4efb429d19 user: drh tags: trunk)
12:27
Clarify how the SQLITE_OK_LOAD_PERMANENTLY return value should be used. (check-in: 8182293dd8 user: drh tags: trunk)
2019-02-11
13:24
Fix "asterix" typo in fts5.in. (check-in: 569262e571 user: dan tags: trunk)
13:21
Add documentation for the fts3/4/5 remove_diacritic options. (check-in: 34f973966a user: dan tags: trunk)
2019-02-08
16:06
The change of removing deprecated PRAGMAs with SQLITE_OMIT_DEPRECATED was backed out, so remove it from the change log. (check-in: 0ed8a559a1 user: drh tags: trunk)
13:54
Improved text for the 3.27.1 news article. (check-in: b5727d3e83 user: drh tags: trunk)
13:41
Add a news item for 3.27.1. (check-in: c563fbbd64 user: drh tags: trunk)
13:22
Version 3.27.1 (check-in: 65b2939d78 user: drh tags: trunk, release, version-3.27.1)
13:04
Changes for version 3.27.1. (check-in: 287ea23516 user: drh tags: trunk)
2019-02-07
18:10
Fix the chronology entry for 3.27.0. (check-in: 79e69bbf6e user: drh tags: trunk)
17:06
Version 3.27.0 (check-in: f120fbc6f8 user: drh tags: trunk, release, version-3.27.0)
16:59
Update the size and performance graph spreadsheet. (check-in: 5c6358b7e1 user: drh tags: trunk)
14:31
Fix typos detected by spellcheck. (check-in: 8c65dc2deb user: drh tags: trunk)
13:59
Add back the sponsors section to the front page. (check-in: 3b7ad43873 user: drh tags: trunk)
13:47
Merge changes from the 3.26.0 release branch. (check-in: 9d6e96fd8f user: drh tags: trunk)
13:42
Add news for 3.27.0 (check-in: 7a25788e4c user: drh tags: trunk)
2019-02-05
16:45
Update to the change log. (check-in: f9f945c599 user: drh tags: trunk)
12:58
Clarification to the VACUUM INTO documentation. (check-in: c7001012e1 user: drh tags: trunk)
2019-02-01
22:06
Fix typos and omissions in the change log. (check-in: 91188df9ec user: drh tags: trunk)
16:57
Clarification of "billion" and "trillion" on the most-used page. (check-in: ca148dd5c0 user: drh tags: trunk)
16:55
Clarification of usage claims on the index page. (check-in: 20fa2ff51e user: drh tags: trunk)
14:44
Fix a typo on the index page. (check-in: 139fa7c746 user: drh tags: trunk)
2019-01-31
17:51
Add documentation for SQLITE_CONFIG_MEMDB_MAXSIZE. (check-in: cb850cf9a5 user: drh tags: trunk)
2019-01-29
18:59
Fix a typo in the date-time function documentation. (Leaf check-in: 0866c95aaf user: drh tags: branch-3.26)
2019-01-28
20:31
Updates to the change log for version 3.27.0. (check-in: 03bca65239 user: drh tags: trunk)
12:16
Fix typo on the "PRAGMA database_list" documentation. (check-in: 70943cf0c8 user: drh tags: branch-3.26)
2019-01-22
20:59
Clean up links in the arch.html and opcode.html documents. (check-in: ea5ed63f07 user: drh tags: trunk)
2019-01-09
19:56
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. (check-in: fd152b335d user: drh tags: branch-3.26)
19:54
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. (check-in: 83da33aabc user: drh tags: trunk)
2018-12-26
12:00
Fix typo on the security.html webpage. (check-in: 2ffc105f81 user: drh tags: branch-3.26)
2018-12-15
11:12
Fix a typo in the assert.html document. (check-in: 538a9a3099 user: drh tags: branch-3.26)
02:51
Fix a typo in the code of ethics. (check-in: 6e0f306cb7 user: drh tags: branch-3.26)
01:17
Merge defense-against-dark-arts fixes from trunk. (check-in: a8707b40a7 user: drh tags: branch-3.26)
2018-12-14
19:01
Fix typos in the defense-against-dark-arts document. (check-in: 94ad3e51e7 user: drh tags: trunk)
15:54
Rename the "security.html" document as "Defense Against Dark Arts". Add the additional recommendation to avoid memory-mapped I/O on untrusted database files. (check-in: 11d0259504 user: drh tags: trunk)
2018-12-10
12:52
Futher homepage enhancements. Improvements and typo fixes on secondary pages. (check-in: e6aa1d2d9a user: drh tags: trunk)
12:34
Further tweaks to the homepage. (check-in: dd073d8325 user: drh tags: trunk)
12:09
Improvements to the homepage. (check-in: 818a7ac30c user: drh tags: branch-3.26)
12:08
Improvements to the homepage. (check-in: 893d161a74 user: drh tags: trunk)
11:48
Update the change log. (check-in: 22f1dff034 user: drh tags: trunk)
00:54
Fix the "Latest Release" on the front page. (check-in: 2b5acd3ccf user: drh tags: branch-3.26)
00:52
Begin a new change log entries for 3.27.0. (check-in: 41f9becb46 user: drh tags: trunk)
2018-12-09
22:31
Omit the sponsor links from the homepage. (check-in: 551ce8e2ad user: drh tags: branch-3.26)
22:30
Omit the sponsor links from the homepage. (check-in: 3c035c0759 user: drh tags: trunk)
22:23
Preliminary documentation for VACUUM INTO (check-in: 130193a5b9 user: drh tags: trunk)
2018-12-06
15:20
Enhanced ALTER TABLE documentation, and in particular show the dangers of not following the generalized 12-step ALTER TABLE procedure precisely. (check-in: 4ffbc3f635 user: drh tags: trunk)
2018-12-01
20:55
Adjust the date for 3.26.0 in the speed and size chart. (check-in: 41f2b76661 user: drh tags: trunk)
19:17
Enhancements to the geopoly documentation. (check-in: 3ab6e3f6a6 user: drh tags: trunk)
12:41
Version 3.26.0 (check-in: 7463317ee9 user: drh tags: trunk, release, version-3.26.0)
2018-11-30
21:04
Fix documentation typos. (check-in: 297fc5035b user: drh tags: trunk)
2018-11-28
14:59
Update the speed-and-size spreadsheet with the latest performance numbers. (check-in: 71c9a6d2b0 user: drh tags: trunk)
10:21
Further enhancements to the Quirks document. (check-in: 8a0206bb29 user: drh tags: trunk)
10:08
Fix a typo on the quirks.html page. (check-in: dd1def55d8 user: drh tags: trunk)
2018-11-26
18:57
Caution users to have well-defined column names in VIEWs. (check-in: 5a0203cdca user: drh tags: trunk)
12:01
Merge typo fix from the 3.25 branch. (check-in: 121aeee579 user: drh tags: trunk)
12:01
Fix typo in the wal.html document. (Leaf check-in: 4182b1655e user: drh tags: branch-3.25)
2018-11-24
20:58
In the GeoPoly documentation, mention that geopoly_ccw() can be used to correct vertex order after geopoly_xform(). (check-in: bfc897c9c0 user: drh tags: trunk)
20:24
Minor enhancements and updates to various documents. (check-in: 9e12c649c9 user: drh tags: trunk)
19:14
Update the speed-and-size spreadsheet and the cpu.html page. Also make minor tweaks to the omitted.html page. (check-in: 555bf82e10 user: drh tags: trunk)
2018-11-21
21:46
Improvements to the althttpd documentation. (check-in: 44a1928f55 user: drh tags: trunk)
2018-11-16
17:33
Update the speed-and-size chart for version 3.26.0 (beta). (check-in: f7ada093c1 user: drh tags: trunk)
14:35
Add the SQLITE_CONSTRAINT return from xBestIndex to the change log. (check-in: 14b1451274 user: drh tags: trunk)
14:33
More fixes to the virtual table documentation. (check-in: 70c4eaad4d user: drh tags: trunk)
14:30
Explain the use of SQLITE_CONSTRAINT as a return value from xBestIndex. (check-in: 52c277f049 user: drh tags: trunk)
01:45
Fix a typo in csv.html. (check-in: ccee8fa12e user: drh tags: trunk)
01:43
Improvements to documentation on the CSV virtual table. (check-in: c0ef40b603 user: drh tags: trunk)
2018-11-15
16:53
Remove all hyperlinks to CVSTrac in preparation for shutting down all CVSTrac servers, which are now unmaintained for 10 years and are showing their age. (check-in: 3c24a2c7f6 user: drh tags: trunk)
2018-11-13
19:55
Improvements to documentation associated with new features in version 3.26.0. (check-in: 3d96456389 user: drh tags: trunk)
2018-11-12
15:24
Enhancements to the documentation regarding security and shadow tables. (check-in: 7b6b7a791b user: drh tags: trunk)
13:39
Begin adding a change log for version 3.26.0. (check-in: a74a421c12 user: drh tags: trunk)
2018-11-07
20:07
Merge changes from the 3.25 branch. (check-in: 3b8a91bbce user: drh tags: trunk)
17:35
Improvements to the documentation of the busy method in the TCL interface. Words contributed by flightaware. (check-in: bf23032b75 user: drh tags: branch-3.25)
2018-11-05
20:41
Version 3.25.3 (check-in: d2c8e25ac9 user: drh tags: release, version-3.25.3, branch-3.25)
16:42
Preparation for the 3.25.3 patch release. (check-in: 176a9535a2 user: drh tags: branch-3.25)
2018-10-31
18:16
Update the Bloomberg logo to conform to their most recent. (check-in: 4c305230da user: drh tags: branch-3.25)
2018-10-29
16:43
Fix a typo on the prosupport.html page. (check-in: a2738e8e4d user: drh tags: branch-3.25)
2018-10-25
20:19
Merge changes from the 3.25 branch. (check-in: efd5b055b2 user: drh tags: trunk)
01:40
Add a link from the code of ethics back to the code of conduct. (check-in: 5e6fe2c1d5 user: drh tags: branch-3.25)
2018-10-24
19:30
Fix typo in codeofethics.in. (check-in: e59abc19a7 user: drh tags: branch-3.25)
19:26
Fix typos in the codeofconduct.html document. (check-in: 626d883e22 user: drh tags: branch-3.25)
18:30
Rename the codeofconduct.html page to codeofethics.html. Create a new codeofconduct.html page that references the MCPG. (check-in: b65ec66abe user: drh tags: branch-3.25)
11:37
Pull in all the changes on the 3.25 branch. (check-in: 097d5fec34 user: drh tags: trunk)
2018-10-23
20:20
Omit the sponsor links from the homepage. (check-in: 62248cde6a user: drh tags: branch-3.25)
18:44
Fix CoC typos. (check-in: af1ee4516a user: drh tags: branch-3.25)
13:58
Fix a typo in the CoC. (check-in: 90656237d0 user: drh tags: branch-3.25)
13:51
Further clarification to the CoC, to try to forestall misinterpretation of the scope and intent. (check-in: 8883859ae3 user: drh tags: branch-3.25)
04:25
Update the preface to the code-of-conduct to clarify to whom the rule applies, and also to add an enforcement mechanism and a mechanism to deal with new developers who have concerns about the rule. (check-in: f5ef4b0991 user: drh tags: branch-3.25)
2018-10-22
16:07
Update RBU documentation to include REPLACE command rows. (check-in: a9594020c6 user: dan tags: trunk)
15:42
Fix a typo on the dbstat.html page. (check-in: 07eea695f1 user: drh tags: branch-3.25)
2018-10-14
20:33
Fix typo on the GLOB documentation. (check-in: ddacae7fd0 user: drh tags: branch-3.25)
2018-10-03
12:59
Add documentation for missing result codes. (check-in: 76e1292157 user: drh tags: branch-3.25)
2018-09-28
23:43
Initial documentation for the MEMSTAT virtual table. (check-in: 6f48ca52cf user: drh tags: trunk)
20:59
Fix typos on th enew dbpage.html page. (check-in: 966ccc894f user: drh tags: trunk)
20:51
Add documentation on the sqlite_dbpage virtual table. (check-in: 86e3ea9245 user: drh tags: trunk)
17:08
Add documentation for the geopoly_regular() function. (check-in: 7804034c38 user: drh tags: trunk)
2018-09-27
13:06
Say that the recursive part of a CTE may not use aggregate or window functions. (check-in: cf2f8cbd8f user: drh tags: branch-3.25)
12:56
Say that the recursive part of a CTE may not use aggregate or window functions. (check-in: aa1202143a user: drh tags: trunk)
2018-09-26
19:52
Fix a formatting error in the rtree.html document. (check-in: 3b812913fe user: drh tags: branch-3.25)
15:19
Merge changes from the 3.25 branch. (check-in: 2e3a732177 user: drh tags: trunk)
2018-09-25
19:32
Version 3.25.2 (check-in: 8c31c0cd8c user: drh tags: release, version-3.25.2, branch-3.25)
19:28
Clarification to the order of arguments in like() and glob(). (check-in: 86e05fde50 user: drh tags: branch-3.25)
19:28
Update the sha3 sum for sqlite3.c for version 3.25.2. (check-in: 31377cc26a user: dan tags: branch-3.25)
19:13
Add hashes to the 3.25.2 change log. (check-in: 2770eeff69 user: drh tags: branch-3.25)
16:26
Improvements to the legacy_alter_table pragma documentation. Typo fix in the change log. (check-in: db3facf719 user: drh tags: branch-3.25)
15:02
Preliminary changes for version 3.25.2. (check-in: e00e728eae user: drh tags: branch-3.25)
2018-09-24
14:46
Clarify the operation of the "weekday" date and time modifier. (check-in: b4b8f35ef1 user: drh tags: branch-3.25)
14:38
Improved linkage to window functions. (check-in: 1c7ab913f0 user: drh tags: branch-3.25)
12:40
Document the SQLITE_QUERY_PLANNER_LIMIT and SQLITE_QUERY_PLANNER_LIMIT_INCR compile-time options. (check-in: 55fce17e3c user: drh tags: trunk)
2018-09-21
10:16
Fix a harmless typo in the json documentation. (check-in: 2bdb2d7e21 user: drh tags: trunk)
2018-09-19
11:04
Fix a typo in the JSON extension documentation. (check-in: 7eef7f4c93 user: drh tags: trunk)
2018-09-18
20:33
Add news to the 3.25.1 release. (check-in: e81118eeb9 user: drh tags: trunk)
20:26
Version 3.25.1 (check-in: 6ffc80634e user: drh tags: trunk, release, version-3.25.1)
2018-09-17
18:38
Initial change log for version 3.25.1. (check-in: 9daac74fb0 user: drh tags: trunk)
12:48
Fix typo. (check-in: be9d86ac89 user: mistachkin tags: trunk)
2018-09-15
04:26
Version 3.25.0 (check-in: 9089e073c4 user: drh tags: trunk, release, version-3.25.0)
2018-09-14
17:42
Fix minor typos detected by the spell checker. (check-in: c68e153fc6 user: drh tags: trunk)
16:54
Add news for the 3.25.0 release. (check-in: 884ea7b3ed user: drh tags: trunk)
16:34
The application_id is a signed integer. (check-in: 3580ba4b5b user: drh tags: trunk)
15:54
Update the speed-and-size spreadsheet with the latest measurements. (check-in: 37ab9b40af user: drh tags: trunk)
2018-09-13
12:50
Updates to the geopoly documentation. (check-in: f1742a52f5 user: drh tags: trunk)
2018-09-12
10:49
Fix typos in the windowfunctions.html document. (check-in: 221cce4209 user: drh tags: trunk)
2018-09-11
22:44
Fix typos in the geopoly document. (check-in: 81cf14c724 user: drh tags: trunk)
18:17
Updates to the change log. (check-in: 5c91ca999e user: drh tags: trunk)
2018-09-10
14:56
Update the change log with recent bug fixes. (check-in: eba1c4fd81 user: drh tags: trunk)
2018-09-06
21:37
Improvements to the RENAME COLUMN syntax diagram. (check-in: c951c8c482 user: drh tags: trunk)
20:36
Fix a long-standing typo in the ALTER TABLE documentation. (check-in: 9b5947f2ee user: drh tags: trunk)
20:34
Update the documentation to reflect the enhancements to ALTER TABLE. (check-in: c3c04a7bb4 user: drh tags: trunk)
20:05
Update the ALTER TABLE bubble diagram to show the RENAME COLUMN syntax. (check-in: f995368f57 user: drh tags: trunk)
20:02
Merge documentation fixes from the 3.24.0 release branch. (check-in: 4235bb053e user: drh tags: trunk)
19:09
Updates the speed and size graph spreadsheet. (check-in: e772c0fa3a user: drh tags: trunk)
2018-09-05
09:58
Fixes to the geopoly documentation. (check-in: ab4f7977fb user: drh tags: trunk)
2018-09-03
10:57
Fix a typo in the CREATE TABLE documentation. (check-in: aff4908d94 user: drh tags: trunk)
10:46
Fix a typo in the testing.html document. (check-in: fb87225a7a user: drh tags: trunk)
2018-09-02
10:12
Fix a duplicate anchor in the lang.in page. (Leaf check-in: 718909cfaf user: drh tags: branch-3.24)
2018-08-27
20:52
Enhancements to the virtual table documentation to describe the operation of SQLITE_INDEX_CONSTRAINT_FUNCTION. (check-in: f3d8866e42 user: drh tags: trunk)
17:15
First cut at documentation for the Geopoly module. (check-in: a007133016 user: drh tags: trunk)
2018-08-25
14:56
Fix a duplicate fragment name in lang_expr.html (check-in: 8ffd68dac7 user: drh tags: trunk)
2018-08-15
13:21
Pre-expand key railroad diagrams in the windowfunctions.html page. (check-in: 61483bc834 user: drh tags: trunk)
2018-08-08
17:36
Fixes to the CGI handling in althttpd.c. (check-in: 6faf1e47b9 user: drh tags: trunk)
2018-08-06
01:42
Fix typos in the windowfunction documentation. (check-in: ab3b52646c user: drh tags: trunk)
2018-08-01
07:08
In althttpd.c, make sure all file descriptors other than 0, 1, and 2 are closed prior to launching CGI. (check-in: c84d76df63 user: drh tags: trunk)
2018-07-30
20:16
Enhancement to the how-to-corrupt document. (check-in: 06a6ca5d34 user: drh tags: branch-3.24)
2018-07-27
23:56
Sublists in the change log are a-b-c instead of 1-2-3. (check-in: 3e5cf6efac user: drh tags: trunk)
23:55
Change log updates. (check-in: 6a6488d91d user: drh tags: trunk)
2018-07-23
18:32
Improved documentation for snapshots. (check-in: 62d574457f user: drh tags: trunk)
12:58
Update the size and speed spreadsheet (check-in: 328bad0eed user: drh tags: trunk)
11:17
Merge changes from branch-3.24 (check-in: 777501f7ed user: drh tags: trunk)
11:16
Prosupport edits. (check-in: fb2699cc28 user: drh tags: branch-3.24)
11:02
Merge changes from the 3.24 branch. (check-in: 137b4b6a0f user: drh tags: trunk)
11:00
Further changes to the prosupport documentation. (check-in: 00457c34b5 user: drh tags: trunk)
10:53
Changes to information on support packages. (check-in: 5caed7a191 user: drh tags: branch-3.24)
10:51
Changes to information on support packages. (check-in: 7e685f86a9 user: drh tags: trunk)
2018-07-13
20:31
Add docs for fts5 unicode61 tokenizer option "categories". (check-in: e32e877119 user: dan tags: trunk)
2018-07-11
11:08
Update the keyword list with all of the new keywords added for UPSERT and window functions. (check-in: 824b38d28e user: drh tags: trunk)
2018-07-07
17:44
Update the "small footprint" docs to put the size at 600KB instead of 500KB, as we have crossed that threshold with the addition of window functions. (check-in: eeaadb7da2 user: drh tags: trunk)
17:36
Minor changes to the windows function documentation. (check-in: ff1e1e885a user: drh tags: trunk)
2018-07-06
20:43
Work on the window function documentation, including importing the new syntax diagrams. (check-in: 6d60e5d021 user: drh tags: trunk)
18:30
Update the syntax diagrams to include the new window function syntax. (check-in: f7a6a2f7c2 user: drh tags: trunk)
2018-07-05
21:13
Fix typo in the RANGE documentation of windows functions. (check-in: 463da73728 user: drh tags: trunk)
2018-07-02
08:00
Add a sentence to the FTS3/4 documentation to make it clear that only columns that are part of the FTS3/4 table declaration exist, even if an external content table with more columns is in use. (check-in: ea0f0b4c4a user: dan tags: trunk)
2018-06-30
20:30
New entries in the change log. (check-in: 5ef0fc4e97 user: drh tags: trunk)
20:23
Create a change log for version 3.25.0 (check-in: 5697c09027 user: drh tags: trunk)
2018-06-26
18:24
Mention that UPSERT does not work for virtual tables. (check-in: 887762cf99 user: drh tags: branch-3.24)
17:48
Improve the example of how to create a new aggregate window function in windowfunctions.in. (check-in: 873c1ea4b7 user: dan tags: trunk)
2018-06-25
20:35
Add documentation for implementing new aggregate window functions. (check-in: b5a81b3bdf user: dan tags: trunk)
2018-06-22
16:14
Add further examples to windowfunctions.in. (check-in: 84418fef8d user: dan tags: trunk)
2018-06-21
21:00
Improve windowfunctions.in. (check-in: 7094fcac78 user: dan tags: trunk)
2018-06-20
21:13
Add beginning of documentation for window functions in new file windowfunctions.in. (check-in: c1e5cf0cb1 user: dan tags: trunk)
2018-06-15
19:12
Fix missing "const" in the documentation of the argv parameters to the xCreate and xConnect methods in the sqlite3_module object. (check-in: 2ee890a53a user: drh tags: branch-3.24)
2018-06-09
22:13
Fix typos in the compile.html page. (check-in: 10c05df9fb user: drh tags: branch-3.24)
2018-06-08
13:41
Fix the -auth redirect logic to avoid duplicating part of the URL. (check-in: 76396bf1df user: drh tags: trunk)
13:21
Use https for all internal hyperlinks. (Leaf check-in: 59e5f9e3da user: drh tags: branch-3.24-https)
2018-06-07
18:29
In althttpd.c, add the "anyone" line to the -auth file syntax. This allows inserting an -auth file that reads "http-redirect \n anyone" and which will force HTTP connections to redirect to HTTPS. (check-in: 9005943d91 user: drh tags: trunk)
2018-06-05
23:20
Clarification that the overwrite optimization does not affect the behavior of triggers. (check-in: 27b8057665 user: drh tags: branch-3.24)
13:43
Add hyperlinks for "index b-tree" and "table b-tree". (check-in: 35ca8da032 user: drh tags: trunk)
2018-06-04
19:41
Add the upsert-clause.gif image. (check-in: 7d927bcea1 user: drh tags: trunk)
19:28
Add the final date and various hashes for the 3.24.0 release. (check-in: c300836d83 user: drh tags: trunk)
2018-06-01
17:41
Add the Sanderson book to the books.html page. (check-in: 97f6d1477c user: drh tags: trunk)
2018-05-31
19:14
Typo fixes. (check-in: db85f0efae user: drh tags: trunk)
17:37
Miscellaneous typo fixes and minor enhancements. (check-in: 1a236e279d user: drh tags: trunk)
16:43
Create a News article about the 3.24.0 release. (check-in: 6cb0e35932 user: drh tags: trunk)
13:17
Add a size graph with units of mibibytes. (check-in: d6256c1615 user: drh tags: trunk)
13:11
Update the speed and size graph. (check-in: 696489a7db user: drh tags: trunk)
2018-05-29
18:35
Document (with links) that SQLite is a LoC Recommended Storage Format. (check-in: 2ab12e598f user: drh tags: trunk)
15:55
Change log updates due to review of sqlite3.c diffs from prior release. (check-in: 4a562f8d21 user: drh tags: trunk)
2018-05-26
01:59
Show the apSqlParam field that was added to the sqlite3_rtree_query_info object in version 3.8.11. (check-in: b5582fa868 user: drh tags: trunk)
2018-05-25
22:50
Fix a typo in the rtree documentation. (check-in: fe9ab1ba5b user: drh tags: trunk)
18:17
Improved wording on the OsQuery description. (check-in: 1a2d15781d user: drh tags: trunk)
17:50
Add the vtablist.html page. (check-in: 3d073f02d7 user: drh tags: trunk)
12:54
Clarification of xUpdate behavior in the virtual table documentation. (check-in: 36334d1830 user: drh tags: trunk)
2018-05-23
20:21
Updates to the speed and size graph. (check-in: b25c5620c3 user: drh tags: trunk)
18:06
Update the change log to mention the sqlite_sequence bug. (check-in: b31a1c8b32 user: drh tags: trunk)
2018-05-22
15:40
Better phrasing of the read-only WAL mode disadvantage in wal.html. (check-in: 729be21bb1 user: drh tags: trunk)
15:31
Read-only WAL mode in 3.22, not 3.20. (check-in: f5137e463c user: drh tags: trunk)
15:28
Update information on read-only WAL-mode databases to conform with the new capabilities added in version 3.22.0. (check-in: ba027764e3 user: drh tags: trunk)
2018-05-19
14:21
Updates to the TH3 documentation. (check-in: ac3ef1f6aa user: drh tags: trunk)
2018-05-18
18:02
Merge fixes from the 3.23 branch. (check-in: 45753832a8 user: drh tags: trunk)
18:02
Update docs for the r-tree auxiliary columns. (check-in: daa211f9cd user: drh tags: trunk)
2018-05-17
20:40
Updates to the change log and other documentation pages. (check-in: 4c3f0e6adb user: drh tags: trunk)
10:02
New advantage of SQLite Archives: Bypass firewall censorship. (Leaf check-in: ef0b96b340 user: drh tags: branch-3.23)
2018-05-09
10:11
Merge fixes from the 3.23 branch. (check-in: cc22fb914a user: drh tags: trunk)
10:10
Fix documentation typos. (check-in: 9d89e82c5d user: drh tags: trunk)
2018-05-08
14:32
More details on the UPSERT documentation. (check-in: 7ca811b29f user: drh tags: trunk)
13:35
Mention the cell-overwrite optimization on the change log. (check-in: d324d1a30e user: drh tags: trunk)
2018-05-04
16:43
Documentation for SQLITE_ENABLE_SORTER_REFERENCES. (check-in: 183931a121 user: drh tags: trunk)
05:03
Update the speed-and-size spreadsheet. (check-in: 0fdc011d0b user: drh tags: trunk)
02:36
Begin revising the EXPLAIN QUERY PLAN document. More work is needed here. Update the change log. (check-in: f07b7a3a18 user: drh tags: trunk)
2018-04-30
22:39
More detail on synchronous=NORMAL. (check-in: 13c3dff046 user: drh tags: branch-3.23)
22:27
Update the change log. Fix typo in virtual table documentation. (check-in: 32c5dad1b2 user: drh tags: trunk)
2018-04-25
00:02
Updates to the change log. (check-in: 6d211fe371 user: drh tags: trunk)
2018-04-20
00:00
Document the fact that UPSERTs count INSERT operations but not UPDATEs. (check-in: fcfd6e8be6 user: drh tags: trunk)
2018-04-19
13:28
Preliminary documentation for upsert. (check-in: 74564b6da7 user: drh tags: trunk)
10:24
Start the change log for 3.24.0 (check-in: 1f4c6d050e user: drh tags: trunk)
2018-04-14
18:49
Fix incorrect hyperlink to xkcd in the whynotgit.html document. (check-in: ee9866f9cc user: drh tags: trunk)
11:48
Add a link to the lobsters discussion to whynotgit.html. (check-in: 08879e07be user: drh tags: trunk)
11:12
Improve the focus of the "open-source, not open-contribution" section of the Copyright page. (check-in: 1e4dabf140 user: drh tags: trunk)
11:02
Add a link to the revision history of the whynotgit.html document. (check-in: 34c5347f0b user: drh tags: trunk)
10:22
Minor edits to whynotgit.html due to Reddit comments. (check-in: 2ad4610bdf user: drh tags: trunk)
2018-04-13
15:09
Fix a minor formatting issue in the tempfiles.html document. (check-in: 9f03d7ca10 user: drh tags: trunk)
2018-04-12
18:21
More tweaks to the whynotgit.html document. (check-in: 200882d3ff user: drh tags: trunk)
18:08
Fix yet another typo in whynotgit.html (check-in: 13eff8bb25 user: drh tags: trunk)
17:04
Fix a typo on the optoverview.html document. (check-in: 5272d8d61d user: drh tags: trunk)
15:31
There are "hundreds of billions", not "tens of billions" of SQLite database files in circulation - in the rowidtable.html document. (check-in: c34168d55b user: drh tags: trunk)
14:47
Tweaks to the whynotgit.html page. (check-in: 149486cfb5 user: drh tags: trunk)
14:09
Correct details in the description of the SHM file format. (check-in: d40d77faa2 user: drh tags: trunk)
2018-04-11
17:10
Fix a typo in the whynotgit.html document. (check-in: b4af616809 user: drh tags: trunk)
14:29
Update the whynotgit.html article. (check-in: e9e9759f68 user: drh tags: trunk)
11:29
Fix duplicate ticket link in the change log for 3.23.1. (check-in: 4d52786c5d user: drh tags: trunk)
03:33
Fix a typo in the whynotgit.html page. (check-in: 36bacb0ca7 user: drh tags: trunk)
2018-04-10
18:53
Fix another typo in whynotgit.html (check-in: dc2c4c372b user: drh tags: trunk)
18:26
Fix typos in the whynotgit.html document. (check-in: 4b40ee5303 user: drh tags: trunk)
17:44
Version 3.23.1 (check-in: f7fce883af user: drh tags: trunk, release, version-3.23.1)
17:09
Fix a typo in the whynotgit.html document. (check-in: 44fe2354a1 user: drh tags: trunk)
13:48
Update the performance and size spreadsheet. Update the cpu.html page with the latest graph. (check-in: 9e3acfbfab user: drh tags: trunk)
12:36
Changes for the 3.23.1 patch release. (check-in: 21ae80926f user: drh tags: trunk)
01:09
Merge fixes from the 3.23.0 branch. (check-in: 2ca5d3c1c4 user: drh tags: trunk)
00:29
Fix a typo in the whynotgit.html document. (Leaf check-in: 737022637a user: drh tags: version-3.23)
00:24
Add the Why SQLite Does Not Use Git document. (Cherrypick from trunk) (check-in: 50c596f536 user: drh tags: version-3.23)
00:21
Add the Why SQLite Does Not Use Git document. (check-in: 1b4a90faa0 user: drh tags: trunk)
2018-04-09
22:34
Fix typos in cpu.html. (check-in: fc3877b543 user: drh tags: version-3.23)
01:19
Fix typo in the lang_createindex.html document. (check-in: f8c8d8614f user: drh tags: version-3.23)
2018-04-07
12:00
Fix a typo on the "when to use" page. (check-in: 1963430c3f user: drh tags: version-3.23)
11:54
Add "data transfer format" to the use cases for SQLite in the "When to Use" document. (check-in: d232f16b87 user: drh tags: version-3.23)
2018-04-06
12:16
Align the use of the "BLOB" affinity in lang_createtable.html with the definitions in datatype3.html. (check-in: e4161dc6b1 user: drh tags: version-3.23)
2018-04-04
00:56
Enhance the how-to-corrupt document to warn against carrying an open database connection across a fork(). (check-in: 516e342f08 user: drh tags: version-3.23)
2018-04-03
12:02
Work on the "quirks.html" page. The page is still incomplete, but I need to divert attention to other issues so I'm checking in partial changes. (check-in: 508297d763 user: drh tags: trunk)
2018-04-02
21:24
Fix a typo in the CLI document. (check-in: 7bf84d856a user: drh tags: version-3.23)
15:25
Updates to the "serverless" page to talk about resent definitions of that word. Add a skeleton for the "quirks" document. (check-in: 1e78d197a1 user: drh tags: trunk)
11:10
Version 3.23.0 (check-in: 9f377d4453 user: drh tags: trunk, release, version-3.23.0)
2018-03-30
18:41
More spelling errors fixed. (check-in: c9667def97 user: drh tags: trunk)
18:33
Fix typos discovered by spell-check. (check-in: e436f9d464 user: drh tags: trunk)
18:12
Add news and update metrics in testing.html. (check-in: 9f7ee8332a user: drh tags: trunk)
18:08
Bring the speed-and-size spreadsheet up-to-date. (check-in: f80a29418e user: drh tags: trunk)
17:15
Fix a close-requirement mark in optoverview.html. (check-in: 2f6a562725 user: drh tags: trunk)
2018-03-29
18:55
Fix a bad unicode character in the books.html page. (check-in: 1db40a5e0e user: drh tags: trunk)
2018-03-28
15:54
A couple more minor changes in the change log. (check-in: ac0b5884a5 user: drh tags: trunk)
15:11
Add mention of sqlite3changeset_apply() hardening to the change log. (check-in: 156259f9a6 user: drh tags: trunk)
2018-03-27
12:51
Update the speed and size chart. (check-in: e704c03dfe user: drh tags: trunk)
2018-03-24
08:53
Typo fixes and wording improvements. (check-in: ff59449da3 user: drh tags: trunk)
2018-03-23
23:09
Typos and minor wording changes to the CoC intro to bring it into alignment with the trunk. (Leaf check-in: 29d1943774 user: drh tags: branch-3.22)
23:08
Fix typo and minor wording change in the CoC. (check-in: 43b0cc26d6 user: drh tags: trunk)
23:02
Minor simplification to the overview in the CoC. (check-in: 03da80f8be user: drh tags: trunk)
22:56
Copy the new CoC overview from trunk. (check-in: 3b828f75e4 user: drh tags: branch-3.22)
22:56
Further rework of the overview to the CoC. (check-in: 3015ed3356 user: drh tags: trunk)
19:16
Rework the overview section of the CoC. (check-in: 647aab3db2 user: drh tags: trunk)
18:18
Cross-reference whyc.html to the HN and Reddit comments. (check-in: a8bc3a4771 user: drh tags: trunk)
17:50
Tweaks to the new assert documentation. (check-in: 19d3bdb7e3 user: drh tags: trunk)
17:42
Updates to the whyc.html and assert.html documentation pages. (check-in: e7ab215c5b user: drh tags: trunk)
14:53
Clarification of text in the new optoverview.html section on the LEFT JOIN Optimization. (check-in: 9e6750c1fc user: drh tags: trunk)
14:46
Update syntax diagrams and expression text to cover the new TRUE and FALSE literals and the IS TRUE and IS FALSE operators. (check-in: dfdf980e6c user: drh tags: trunk)
14:30
Add TRUE and FALSE to the syntax diagrams as new literal values. (check-in: 1d1c0fc6ec user: drh tags: trunk)
11:47
Fix typos. Clarification to the CoC in response to criticism. (check-in: 79f3efbc86 user: drh tags: trunk)
2018-03-22
18:55
Further enhancement to the optimizer overview document, giving the change log for 3.23.0 something to link to. (check-in: 219fa13637 user: drh tags: trunk)
13:36
Refactor the optoverview.html document to be written in HTML with occasional <tcl> tags, rather than in pure TCL, so that it works better with fancy-format. (check-in: 69fd8c5ba9 user: drh tags: trunk)
12:01
Updates to the change log. (check-in: 50c0768dbe user: drh tags: trunk)
2018-03-20
13:15
Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. (check-in: 015a7ffa9e user: drh tags: branch-3.22)
13:14
Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. (check-in: fc5ba69bb7 user: drh tags: trunk)
2018-03-19
13:46
Document two new bug fixes in the change log. (check-in: 58f72e5776 user: drh tags: trunk)
2018-03-15
15:13
Updates to the change log. (check-in: 6b0d51b8b9 user: drh tags: trunk)
14:45
Merge typo fixes from the 3.22.0 branch. (check-in: 2fca7bc025 user: drh tags: trunk)
11:25
Fix typos in the th3.html document. (check-in: 996754464c user: drh tags: branch-3.22)
2018-03-14
21:01
Updates to the assert.html document. (check-in: 6b0d70f277 user: drh tags: trunk)
19:09
Fix a typo in the whyc.html page. (check-in: c7663e0c39 user: drh tags: branch-3.22)
2018-03-10
20:39
Updates to the TCL interface documentation, plus other minor typo fixes. (check-in: 381e82d92b user: drh tags: trunk)
18:40
Improvements to ZIP processing in the CLI document. Fix a hyperlink in the sqlar.html document. (check-in: 23f1f44cc2 user: drh tags: trunk)
15:27
Improvements to the sqlar.html page. (check-in: 0a2c8d8f26 user: drh tags: trunk)
12:09
Fix a typo in the zipfile.html document. (check-in: 7accc324d8 user: drh tags: trunk)
12:05
Fix a typo on the printf.html page. (check-in: 5c4f29e7bd user: drh tags: trunk)
2018-03-09
18:11
Merge search box fixes from the 3.22.0 branch. (check-in: 848c37b010 user: drh tags: trunk)
18:11
Further improvements to the search script. (check-in: 55959de4e8 user: drh tags: branch-3.22)
17:59
Improvements to Wapp to clean up the previous XSS fix. (check-in: 4652ea52c0 user: drh tags: branch-3.22)
17:26
Fix a XSS problem in the search box. (check-in: c57271bdec user: drh tags: branch-3.22)
2018-03-08
16:27
Improvements to SQLite Archive documentation. (check-in: 7647551ed3 user: drh tags: trunk)
14:50
New alternative TCLINC and TCLLIB suggestions in the Makefile. (check-in: 4cef637367 user: drh tags: trunk)
13:39
Continuing work on the sqlar.html document. (check-in: 2e4f0d8cda user: drh tags: trunk)
12:18
Merge updates from the 3.22.0 release. (check-in: 2fa11f57a9 user: drh tags: trunk)
00:33
Add the documentation about SQLite Archive files. Updates to the change log. (check-in: f49396b55b user: drh tags: trunk)
2018-03-05
12:21
Fix a typo in the about.html page. While we were at it, remove some older and largely obsolete text from that page. (check-in: 5f83963454 user: drh tags: branch-3.22)
2018-02-28
22:21
Enhance the sessions documentation to show the methods of objects. (check-in: a0b50e2c3d user: drh tags: trunk)
21:50
Fix the sessions documentation generator so that code snippets are indented correctly. (check-in: f3445c7d01 user: drh tags: trunk)
2018-02-27
22:16
Updates to the althttpd documentation. (check-in: 5a87c618a8 user: drh tags: trunk)
21:29
Add documentation on althttpd. (check-in: d9cb224c9f user: drh tags: trunk)
16:36
Create a change log entry for 3.23.0. (check-in: 45bd3cdd39 user: drh tags: trunk)
2018-02-25
19:24
Be sure to ParseRfc822Date() has enough precision in its output. (check-in: 3fed9a6fc9 user: drh tags: trunk)
17:29
Fix some missing error codes from the previous althttpd.c check-in. (check-in: 5f2e54c6c1 user: drh tags: trunk)
17:25
Change the action codes in the althttpd.c log to be consistent numbers, rather than source code line numbers. Include text at the end of a file that will generate a cross-reference table in SQLite. (check-in: 8aafa56bb9 user: drh tags: trunk)
01:29
Add support for Last-Modified and If-Modified-Since in althttpd.c. (check-in: 130feb0aa0 user: drh tags: trunk)
2018-02-23
21:41
Add support for the "Test Checklist" named "0demo" in the checklist.tcl application. (check-in: 53dab205ad user: drh tags: trunk)
21:18
Add a customized version of the checklist.tcl script. (check-in: 85e8a997dd user: drh tags: trunk)
2018-02-22
20:36
The Makefile should now work out-of-the-box on Ubuntu. (check-in: 5b2d8db588 user: drh tags: trunk)
19:40
Remove the unused TCLSTUBSFLAGS from the makefiles. (check-in: 1412cc8f93 user: drh tags: trunk)
19:34
Remove the NAWK macros from the Makefiles, since they are no longer used. (check-in: 76b1d7f1d4 user: drh tags: trunk)
18:14
First draft of a new quality management plan. Still incomplete. (check-in: 295c4e35bc user: drh tags: trunk)
13:42
Add a draft of a quality management plan based on DO178B. But the document seems to prolix, and so it is parked on a branch while I explore simpler alternatives. (Leaf check-in: 6a64bdf866 user: drh tags: do178b-qm-plan)
12:39
Merge the 3.22.0 updates into trunk. (check-in: c0ef1f2bd8 user: drh tags: trunk)
12:27
Add the code of conduct document. (check-in: d0d1d80bc4 user: drh tags: branch-3.22)
2018-02-20
13:46
Further refinement of the new printf.html document. (check-in: 6c1f37df7f user: drh tags: trunk)
02:53
First cut at a separate document for the printf() string formatters. (check-in: 664ed2dce4 user: drh tags: trunk)
2018-02-19
10:46
Add a list of shadow tables to the fts5 documentation. (check-in: 1225bcc93d user: dan tags: trunk)
2018-02-17
17:08
Text clarification and typo fixes on the copyright.html page. (check-in: 8a0f41df1a user: drh tags: branch-3.22)
2018-02-16
14:31
Enhance althttpd.c so that with the -DLOG_HEADER option, it records the complete http request header in logfile-hdr if the "FullHeaderLog" string occurs anyplace in the request path. (check-in: b1ce1a2b56 user: drh tags: trunk)
2018-02-14
18:59
Avoid extra / characters in the redirect to /index.html from / in althttpd.c. (check-in: 4f48a846f6 user: drh tags: trunk)
14:14
Update the spellfix1 documentation regarding the k1 column of the %_vocab table. (check-in: 92cb32fb50 user: drh tags: trunk)
2018-02-13
22:16
Fix an issue with not-found processing in althttpd.c. (check-in: 72c8b8c6ff user: drh tags: trunk)
15:40
Add initial words for the assert.html document. Clearly label the document as a work-in-progress for now. (check-in: 076b02c111 user: drh tags: branch-3.22)
2018-02-12
19:31
Enhancements to the "When To Use SQLite" document. (check-in: a54eb3903e user: drh tags: trunk)
2018-02-07
20:35
Fix typo in the vtab.html document. (check-in: ec9c8be989 user: drh tags: branch-3.22)
16:50
To althttpd.c: Add "signal.h" and a mimetype table entry for "svg" files. (check-in: 2ad7f8fef4 user: drh tags: trunk)
2018-02-06
13:20
Update search to the latest version of wapp. (check-in: 7fdd8a667f user: drh tags: trunk)
2018-02-05
21:20
Fix another typo on the copyright page. (check-in: 1f78a04da9 user: drh tags: branch-3.22)
21:18
Fix typo on the new copyright.html page. (check-in: c5661b456c user: drh tags: branch-3.22)
21:14
Add the "Open-source not open-contribution" section to the copyright.html page. Try to clarify the meaning of "Warranty of Title". (check-in: a2ec6275f0 user: drh tags: branch-3.22)
20:00
Rework the CGI scripts for search so that they use the Wapp framework (https://wapp.tcl.tk). Cherry-pick from trunk. (check-in: 6a06e6c785 user: drh tags: branch-3.22)
01:36
Rework the CGI scripts for search so that they use the Wapp framework (https://wapp.tcl.tk). (check-in: 16a431615f user: drh tags: trunk)
01:15
Update the built-in wapp.tcl to the latest from wapp.tcl.tk. (Closed-Leaf check-in: 9c03c81fbb user: drh tags: search-refactor)
00:47
On the /search.d/admin page, show the Wapp environment if the env=1 query parameter is present. (check-in: ebe9a614eb user: drh tags: search-refactor)
00:38
Minor correction to the new path parser in althttpd.c. (check-in: ec999fa7cd user: drh tags: trunk)
00:32
The SCRIPT_FILENAME cgi parameter in althttpd is now a full pathname. (check-in: f30335da5c user: drh tags: trunk)
2018-02-04
23:30
Add the search.d/admin script. (check-in: 685371e833 user: drh tags: search-refactor)
21:41
Use Wapp to implement the search function. Search can now be run from the command-line using "./tclsh.docsrc doc/search". (check-in: 33c56bee81 user: drh tags: search-refactor)
2018-02-01
14:44
Merge fixes from the release branch. (check-in: 5279eb6057 user: drh tags: trunk)
14:43
Fix a typo in the flattening rules of the optoverview.html document. (check-in: 20ecb45b42 user: drh tags: branch-3.22)
2018-01-31
02:53
Fix another howtocorrupt.html typo. (check-in: 633d838aa0 user: drh tags: branch-3.22)
02:52
Typo in the how-to-corrupt document. (check-in: 6ad1abb448 user: drh tags: branch-3.22)
2018-01-30
23:44
Remove an unused variable from althttpd.c. (check-in: 94b9b95bee user: drh tags: trunk)
17:06
Improved redirect handling in althttpd.c (check-in: c4dcea55cd user: drh tags: trunk)
2018-01-29
18:38
Add documentation for the zipfile() aggregate function. (check-in: 1582bada14 user: dan tags: trunk)
17:17
Fix an XSS problem in the search function on the website. (check-in: 90f86ae4c5 user: drh tags: trunk)
2018-01-27
20:56
Update zipfile documentation to include using the table-valued function to read an in-memory zip archive. (check-in: 5b698017df user: dan tags: trunk)
2018-01-26
18:38
Update documentation for CAST to integer to describe what happens when the integer is too large. This behavior is only supported on the latest trunk, so with this check-in the documentation is no longer suitable for use with 3.22.0. (check-in: 6b1b360098 user: drh tags: trunk)
15:50
Turn on "fancy-format" for the optoverview.html document. (check-in: 98e66068fe user: drh tags: trunk)
15:44
Bring the query flattening section of the optoverview.html document up to date with version 3.22.0. (check-in: a599e76d95 user: drh tags: trunk)
2018-01-25
16:06
Fix a typo on the privatebranch.html page. (check-in: a41da69db7 user: drh tags: trunk)
12:25
Fix hyperlink errors in the sqlanalyze.html page. (check-in: 7941cd31c2 user: drh tags: trunk)
2018-01-22
18:50
Version 3.22.0 (check-in: 09b0d075dc user: drh tags: trunk, release, version-3.22.0)
18:49
Add the date of 3.22.0 to the chronology and set the hashes on the change log. (check-in: 848f20826b user: drh tags: trunk)
18:07
Fix a typo in the change log for 3.22.0. (check-in: abd84d1d06 user: drh tags: trunk)
18:05
Fix a typo in the vtab document. (check-in: 2105719672 user: drh tags: trunk)
17:58
Fix a typo in the CLI document. (check-in: dece3aa0cc user: drh tags: trunk)
17:53
Fix typos in the lemon.html document. (check-in: 62f434c8b8 user: drh tags: trunk)
17:51
Fix typos in the swarmvtab document. (check-in: 67a942c86f user: drh tags: trunk)
17:24
Add a News entry for 3.22.0. Set the release date for 3.22.0. (check-in: 95328e21fb user: drh tags: trunk)
2018-01-18
20:26
Another simplification to the change log. (check-in: e040454680 user: drh tags: trunk)
20:15
Wording improvements and typo fixes. (check-in: 5cbf9f2c9d user: drh tags: trunk)
19:07
Update the size and speed spreadsheet. Simplifications to text in the CLI document. (check-in: 2fac94a5a3 user: drh tags: trunk)
2018-01-16
21:01
Add new result codes to the rescode.in document. Mention the new sqlite3_vtab_collation() interface in the change log. (check-in: e3685f5763 user: drh tags: trunk)
17:07
Fix typo in the CSV documentation. (check-in: a1a35a2b71 user: drh tags: trunk)
13:55
Add the infinite-loop UPDATE problem to the bugfix list for 3.22.0. (check-in: bb5411e371 user: drh tags: trunk)
2018-01-15
18:55
Update zipfile docs to remove the capability to insert compressed data. (check-in: 424270babe user: dan tags: trunk)
18:50
Make sure 304 responses are always followed by a blank line to signal the client that the response is complete. (check-in: b85fcc5367 user: drh tags: trunk)
14:28
Add caching to static content delivery in althttpd.c. (check-in: 635a6553e2 user: drh tags: trunk)
13:31
Update comments on althttpd.c. No changes to code. (check-in: 3f569fa95d user: drh tags: trunk)
2018-01-13
20:39
Fix typo in the how-to-corrupt document. (Cherrypick from trunk) (Leaf check-in: 97e70fb787 user: drh tags: branch-3.21)
20:37
Fix typo in the how-to-corrupt document. (check-in: 66c7f7dcd6 user: drh tags: trunk)
16:45
Add a description of how UPDATE statements work to zipfile.in. (check-in: 33a36d6b95 user: dan tags: trunk)
14:33
Update the file-format documentation on serial-types 10 and 11. They are no longer "reserved for expansion" but have shifted to "reserved for internal use". (check-in: 9b212044e0 user: drh tags: trunk)
00:03
Clarification and typo fixes in the sqlite3_value_nochange() description within the xUpdate documentation. (check-in: 92b3735966 user: drh tags: trunk)
2018-01-12
23:52
Update documentation for the sqlite3_value_nochange() interface. (check-in: 8d811e938b user: drh tags: trunk)
17:40
Update the speed-and-size spreadsheet to the latest performance numbers. (check-in: 3ce75e588e user: drh tags: trunk)
15:24
More althttpd.c changes to remove ::ffff: prefixes from IP addresses. (check-in: bb31c42ef2 user: drh tags: trunk)
14:44
Fix althttpd so that it omits the prefix from REMOTE_ADDRs of the form "::ffff:1.2.3.4" (check-in: a2f73b0c80 user: drh tags: trunk)
2018-01-11
18:29
Add sqlite3_vtab_nochange() to the change log. (check-in: 3b8a8bd89a user: drh tags: trunk)
00:44
Add documentation on the edit() function and .excel command in the CLI. (check-in: 24c4bece59 user: drh tags: trunk)
2018-01-10
20:28
Add the "Export to Excel" subparagraph under "CSV Export" section of the CLI documentation. (check-in: 1728ebf59c user: drh tags: trunk)
19:39
Further tweaks to the cli.html document. (check-in: c27765f3b7 user: drh tags: trunk)
19:26
Improved documentation for recently added features such as SQL Archive support and the Zipfile extension. (check-in: 260f2fd7ee user: drh tags: trunk)
17:06
Update zipfile docs to match the implementation. (check-in: 469ec4c63f user: dan tags: trunk)
2018-01-09
21:05
Add mention of the FTS5-initial-token-syntax in the change log. (check-in: 668e39014a user: drh tags: trunk)
20:05
Remove colloquialism to make the docs more understandable to non-native speakers. (check-in: 82f8d029ed user: drh tags: trunk)
19:47
More typo fixes. (check-in: 6a23f5f429 user: drh tags: trunk)
19:15
Fix typo in the rtreecheck() documentation. (check-in: 68f1e1944c user: drh tags: trunk)
16:41
Add bug fixes to the 3.22.0 change log (check-in: 0e0412e603 user: drh tags: trunk)
16:04
Add mention of the fsdir() table-valued function to the change log. (check-in: a2b074857f user: drh tags: trunk)
15:57
Remove stray characters from the change log. (check-in: 852d1d5d3b user: drh tags: trunk)
15:56
Updates to the change log. (check-in: 45f448bf75 user: drh tags: trunk)
01:25
Add the "docapp" makefile target for building the "docapp" application. (check-in: d31880687e user: drh tags: trunk)
2018-01-08
12:05
Add new documentation file zipfile.in. (check-in: 99c2fcc179 user: dan tags: trunk)
2018-01-04
19:28
Documentation on the sqlite_offset() SQL function. (check-in: 4ce0a400c2 user: drh tags: trunk)
19:10
Flesh out the description of shadow tables and the rtreecheck() function in the R*Tree documentation. (check-in: 2ccafeedbe user: drh tags: trunk)
16:41
Fix broken documentation hyperlinks. (check-in: dfa0a34e07 user: drh tags: trunk)
16:37
Fix typo in the new lemon document. (check-in: ca3748636f user: drh tags: trunk)
16:33
Add a documentation page that overviews Lemon, its history, and its importance to SQLite. (check-in: 106ae9b8df user: drh tags: trunk)
03:33
Update the change log for the 3.22.0 release. (check-in: a897222d15 user: drh tags: trunk)
2018-01-01
17:54
Add documentation for the introspection pragmas that were really added in version 3.20.0 (check-in: 73444ff7b8 user: drh tags: trunk)
14:36
Update to the speed-size-graph spreadsheet. (check-in: 727ad4e477 user: drh tags: trunk)
2017-12-21
18:50
Add docs for experimental ".expert" command. (check-in: 7f57c342de user: dan tags: trunk)
2017-12-19
17:34
Add docs for a proposed addition to the SQLite shell tool. (Closed-Leaf check-in: cd6f445782 user: dan tags: expert-in-shell)
2017-12-16
17:20
Add documentation for the "swarmvtab" extension. (check-in: 9cc758b326 user: dan tags: trunk)
2017-12-12
01:16
Changes to walformat.html document. (check-in: c0a1fede37 user: drh tags: trunk)
2017-12-09
15:44
Add documentation for shell tool SQLAR archive support. (check-in: 809f9fa181 user: dan tags: trunk)
2017-11-25
15:22
Update the fts5 documentation to make it clear that the xDestroy function is not invoked if either xCreateFunction or xCreateTokenizer fails. (check-in: 820de7c995 user: dan tags: trunk)
14:02
Add a description of the "^" syntax to fts5.in. (check-in: 58bbcf8b2f user: dan tags: trunk)
2017-11-23
21:43
Default value for the "s" query parameter in /search is now "d". (check-in: 6182e9ea42 user: drh tags: branch-3.21)
2017-11-13
23:06
Continuing work on the walformat.html document. (check-in: 74c71c744b user: drh tags: trunk)
17:03
Continuing work on the walformat.html document. This is an incremental check-in. (check-in: 627feecddc user: drh tags: trunk)
13:11
Typos in the new walindex.html document. (check-in: 59536a697b user: drh tags: trunk)
2017-11-09
21:01
Fix documentation typos reported on the mailing list by Philip Newton. (check-in: 8283dbcef9 user: drh tags: branch-3.21)
2017-11-08
15:43
Updated VFS documentation. (check-in: 61fb0b3465 user: drh tags: trunk)
2017-11-05
22:22
On the JSON1 documentation, make sure all arguments in the Overview section are italicized. (check-in: 0d9fba9226 user: drh tags: branch-3.21)
2017-11-04
20:26
Continuing work on the WAL file format document. (check-in: 0d151f472f user: drh tags: trunk)
17:08
Begin adding the "WAL-mode File Format" document. Much work left to be done. (check-in: 3f66c70302 user: drh tags: trunk)
15:02
Merge fixes from the 3.21.0 release branch. (check-in: 411a4d6dde user: drh tags: trunk)
2017-11-03
02:37
Fix typo reported on the mailing list. (check-in: d26d101c74 user: mistachkin tags: trunk)
2017-11-02
20:07
Fix a typo ("quote" instead of "quota") in the VFS document. (check-in: 877f14d569 user: drh tags: branch-3.21)
14:29
Fix typos in the affcase1.html document. (check-in: 7546b88643 user: drh tags: branch-3.21)
2017-10-30
17:32
Update the change log with more details of recent enhancements. (check-in: b22a695db2 user: drh tags: trunk)
2017-10-28
20:58
Preliminary changes for the 3.22.0 release. (check-in: b3e5268a9a user: drh tags: trunk)
2017-10-24
19:02
Fix the date and add hashes for the 3.21.0 release. (check-in: 19e6014767 user: drh tags: trunk, release, version-3.21.0)
18:26
Add news for the 3.21.0 release. (check-in: 83687a0810 user: drh tags: trunk)
14:54
Update the speed and size graphs. (check-in: c674dc0ada user: drh tags: trunk)
12:47
Deprecate the SQLITE_RTREE_INT_ONLY compile-time option. (check-in: c0722042ac user: drh tags: trunk)
2017-10-21
20:59
New updates to the change log for the 3.21.0 release. (check-in: 9654c88db8 user: drh tags: trunk)
2017-10-18
16:08
Add new fts5vocab virtual table type - "instance" - to the changelog for 3.21. (check-in: c325f3aaed user: dan tags: trunk)
2017-10-12
14:08
Updates to the change log for 3.21.0 (check-in: 90735e2235 user: drh tags: trunk)
13:55
Update document to show that the src/shell.c source file no longer exists in the canonical source repository and must now be generated from src/shell.c.in. (check-in: beb03aaf56 user: drh tags: trunk)
2017-10-11
18:22
Updates to the change log, including a typo-fix from Ward Willats. (check-in: 6239ca41af user: drh tags: trunk)
2017-10-09
12:54
Rewrite the footprint.html page to use recent measurements. (check-in: 9934321f15 user: drh tags: trunk)
12:04
Add the compiler-difference spreadsheet. (check-in: a6a543f623 user: drh tags: trunk)
2017-10-06
20:00
Fix minor problems in fts3.html. (check-in: 47132abeb4 user: dan tags: trunk)
17:54
Improve the error handling in the example rank function in fts3.html. (check-in: a95efd5bb8 user: dan tags: trunk)
2017-10-04
18:21
Do not scan documents "chronology.html" and "requirements.html" for requirements marks. (check-in: 8c28fe8097 user: drh tags: trunk)
17:53
Partial indexes may contain LIKE and GLOB operators since version 3.16.0. (check-in: 463a68e523 user: drh tags: trunk)
16:16
In the co-routine documentation, mention that future versions of SQLite might make smarter transformations. (check-in: 9cf55de770 user: drh tags: trunk)
15:53
Improvements to the co-routine documentation. (check-in: 18d1ad0854 user: drh tags: trunk)
2017-10-03
14:22
Update the size and speed spreadsheet. (check-in: af347871e8 user: drh tags: trunk)
2017-10-02
03:42
Mention changes to the use of co-routines in the change log. Provide information on co-routines in the query planner overview document. (check-in: 7e35a79626 user: drh tags: trunk)
2017-09-29
12:52
Merge fixes from the 3.20 release branch (check-in: 521876cfa4 user: drh tags: trunk)
12:50
Consistent name for the "SQLite In 5 Minutes Or Less" document. (Leaf check-in: 14bfb3bcf4 user: drh tags: branch-3.20)
12:11
Fix another typo in cintro.html (check-in: 3454b92ec6 user: drh tags: branch-3.20)
12:10
Fix typos and poor wording in cintro.html (check-in: becd70e3fa user: drh tags: branch-3.20)
2017-09-27
09:47
Fix two minor typos. (check-in: f4e38c11f1 user: drh tags: branch-3.20)
2017-09-15
21:15
Minor documentation updates. (check-in: 0896528c21 user: drh tags: trunk)
20:34
Update the change log. (check-in: 506bc5fa56 user: drh tags: trunk)
2017-09-13
04:08
Add a line to the change log for the recent pragma integrity_check enhancement. (check-in: 12d0f93647 user: drh tags: trunk)
2017-09-12
00:44
Update the virtual table documentation with information about the new operators passed into xBestIndex. (check-in: bd399e9806 user: drh tags: trunk)
2017-09-11
23:48
Add the b899b6042f97f5 ticket fix to the change log. (check-in: 5257ab389b user: drh tags: trunk)
21:09
Add the xBestIndex enhancement to the 3.21.0 change log. (check-in: 2e695cb380 user: drh tags: trunk)
2017-09-01
20:53
Updates to the size and performance chart (check-in: 5e4cd244d1 user: drh tags: trunk)
2017-08-31
00:54
Readability improvements to the file format documentation. (check-in: 3b1bef8768 user: drh tags: trunk)
2017-08-30
04:50
Update the speed-and-size spreadsheet. (check-in: 402ce78c69 user: drh tags: trunk)
04:46
Update the CPU usage improvement for 3.21.0. (check-in: 4ea4e27dc5 user: drh tags: trunk)
2017-08-29
13:19
Remove the scratch memory allocator. (check-in: d482cfb5ea user: drh tags: trunk)
2017-08-25
17:54
Update the change log for 3.21.0. (check-in: 2d9f1292ff user: drh tags: trunk)
17:26
Update the prototype Makefile. (check-in: 44c52e864a user: drh tags: trunk)
17:22
Merge changes from branch-3.20. Updated the makefile so that it works with recent changes to the core SQLite. The makefile now expects the BLD variable to be set to point to the directory in which has been run "./configure; make sqlite3.c" for the core source code. (check-in: 6c382d50b9 user: drh tags: trunk)
16:28
Update the speed and size graph. (check-in: a56a3b4391 user: drh tags: trunk)
2017-08-24
16:48
Fix incorrect SHA3 hash on the 3.20.1 sqlite3.c file. (check-in: 4252537c27 user: drh tags: branch-3.20)
16:32
Version 3.20.1 (check-in: b75bf48ce1 user: drh tags: release, version-3.20.1, branch-3.20)
2017-08-21
00:18
Fix typos in the CSV extension documentation. (check-in: 780ee679bd user: drh tags: branch-3.20)
2017-08-12
16:44
Add a description of new fts5vocab table type "instance" to the the fts5 documentation. (check-in: 2ba9202168 user: dan tags: trunk)
2017-08-11
01:21
Update the virtual table documentation to describe writable WITHOUT ROWID virtual tables. Also update the change log. (check-in: af4e59995a user: drh tags: trunk)
01:11
Fix an error in the FTS5 extension mechanism documentation. (check-in: 2d4dd1d10c user: drh tags: branch-3.20)
00:55
Fix a typo in the fileformat document (check-in: faacaa1d1b user: drh tags: branch-3.20)
00:54
Fix a typo in the fileformat document (check-in: 85bec545b9 user: drh tags: trunk)
2017-08-09
20:03
Clarification on the operation of the xUpdate method in the virtual table interface. (check-in: ecec1e668b user: drh tags: trunk)
2017-08-08
03:49
In the 35%-faster report, invert the ratios on the charts, as this seems to make them easier to understand. Check-in the spreadsheet used to construct the charts. (check-in: 3aac5ad40e user: drh tags: branch-3.20)
03:33
In the 35%-faster report, invert the ratios on the charts, as this seems to make them easier to understand. Check-in the spreadsheet used to construct the charts. (check-in: 4869b508d9 user: drh tags: trunk)
2017-08-07
16:53
Update links to the source code repositories to be HTTPS and update the location of the WWW3 server from Fremont to San Francisco. (check-in: aa6b786823 user: drh tags: branch-3.20)
01:44
Fix the hyperlinks to subsequent pages in the search results page. (check-in: e249e0131c user: drh tags: trunk)
01:43
Fix the hyperlinks to the subsequent pages on the search results page. (check-in: ffe3fc4ac0 user: drh tags: branch-3.20)
2017-08-04
14:25
Add the 2009-2018 speed graph relative to 3.20.0 to the speed-size spreadsheet. (check-in: 4df296b435 user: drh tags: trunk)
2017-08-03
20:39
Begin a change log entry for the 3.21.0 release. (check-in: 4cadcc5b9c user: drh tags: trunk)
15:47
Fix another typo in the bindptr.html document. (check-in: 8d2c7aa89d user: drh tags: trunk)
14:35
Amplify one of the points justifying static string pointer types. (check-in: 6604546bb4 user: drh tags: trunk)
14:18
Fix typo in the pointer-passing document. (check-in: 2de67f2a1a user: drh tags: trunk)
13:02
Increased detail on pointer types in the bindptr.html document. (check-in: 1316d197a4 user: drh tags: trunk)
2017-08-02
14:08
When searching the changelog only, leave hyperlinks and other markup in the result summary. (check-in: 12433ed2a3 user: dan tags: trunk)
2017-08-01
19:29
Add a website option to search the changelog instead of the documentation. Do not add any changelog files to the documentation index. (check-in: 8f15082015 user: dan tags: trunk)
19:24
Add a website option to search the changelog instead of the documentation. Do not add any changelog files to the documentation index. (Closed-Leaf check-in: 368f8fa51f user: dan tags: changelog-search)
18:42
Fix a typo in the changelog for release 3.4.0. (check-in: 0a8c13265d user: dan tags: trunk)
13:28
Version 3.20.0 (check-in: f5463fb0e6 user: drh tags: trunk, release, version-3.20.0)
01:23
Update the speed-and-size spreadsheet with the latest test numbers. (check-in: 17d120e496 user: drh tags: trunk)
2017-07-31
20:31
Enhance the change log to use ordered-lists rather than unnumber-lists to make it easier for people to refer to a specific item in the change log. Also fixed a minor typo on item 7 of the current change log. (check-in: bfd46de16b user: drh tags: trunk)
20:19
Mention the column-name fix in the change log for 3.20.0. (check-in: 86057a37ce user: drh tags: trunk)
14:16
Enhance the chronology.html page so that the table columns are sortable. (check-in: d3fa7ece9a user: drh tags: trunk)
2017-07-30
20:28
Fix a broken link to the A350 on the Well-Known users page. (check-in: aa249826dc user: drh tags: trunk)
2017-07-27
18:20
Update documentation for the destructor parameters on the pointer passing interfaces. (check-in: dd480b4420 user: drh tags: trunk)
2017-07-26
17:25
Add a news entry. Fix the release date. Fix typos. (check-in: 9759ba8053 user: drh tags: trunk)
15:06
Update test metrics on the testing.html page. (check-in: 6fc727b510 user: drh tags: trunk)
2017-07-25
17:03
Change log typo fixes. (check-in: 0e82b7e2dd user: drh tags: trunk)
15:57
More typo fixes. (check-in: 9fdf1274f9 user: drh tags: trunk)
15:40
Fix typo in the pointer-passing document. (check-in: 2f0174e967 user: drh tags: trunk)
2017-07-24
15:29
Further typo fixes in the pointer-passing document. (check-in: 3ae0a793ec user: drh tags: trunk)
15:19
Add a couple of sentences to the pointer-passing document to try to clarify that the caller owns the passed pointers. (check-in: 74ab40f1f1 user: drh tags: trunk)
15:15
Fix typos in the pointer-passing document. (check-in: 2c7e1e0eff user: drh tags: trunk)
14:17
Update the performance graphs for version 3.20.0. (check-in: 5f75ab8f7e user: drh tags: trunk)
13:24
Add requirements marks on the deterministic.html document. (check-in: c705444999 user: drh tags: trunk)
12:05
Fix a typo in the change log. (check-in: 3eb9aa1196 user: drh tags: trunk)
12:01
Merge hyperlink fixes from the 3.19 branch. (check-in: 727dbfb460 user: drh tags: trunk)
12:00
Restore text mistakenly deleted from the change log. (check-in: f9a896f5c0 user: drh tags: trunk)
11:34
Typos and clarifications to the pointer-passing document. (check-in: 8d02ad5577 user: drh tags: trunk)
2017-07-23
20:57
Improved documentation on the pointer-passing interfaces. (check-in: 9bf45f99e1 user: drh tags: trunk)
17:07
Fix the hyperlinks to the mailing lists. (Leaf check-in: 2785e9dd6c user: drh tags: branch-3.19)
2017-07-21
19:39
Further enhancements to the change log for 3.20.0. (check-in: 4e0e4a8084 user: drh tags: trunk)
19:32
Add the enhanced ability for date/time functions to be deterministic to the change log and to the "deterministic function" documentation. (check-in: e27224b526 user: drh tags: trunk)
19:12
Add documentation for the UNION virtual table. (check-in: 64af4ea91f user: drh tags: trunk)
2017-07-20
00:15
Update the size and performance graph. (check-in: d35ef36eeb user: drh tags: trunk)
2017-07-17
16:00
Update the FTS5 extension documentation to show the new fts5_api access technique. Update the change log to talk about the backwards incompatible changes in extensions flowing out of sqlite3_bind_pointer(). Update the search extension to use the new FTS5 extensions technique. (check-in: 0585b3df1c user: drh tags: trunk)
12:52
Add the integrity_check false-positive bug-fix to the change log. (check-in: 9b65b351e5 user: drh tags: trunk)
12:47
Merge typo fix from the 3.19 branch. (check-in: ee08220e84 user: drh tags: trunk)
12:25
Fix a typo in whentouse.html. (Cherrypick from trunk) (check-in: 8cd332487d user: drh tags: branch-3.19)
10:16
Fix a typo in whentouse.html (check-in: 9f1b8abdc8 user: drh tags: trunk)
10:15
Fix a hyperlink to the STMT extension. (check-in: c9011466c1 user: drh tags: trunk)
2017-07-15
15:30
Update althttpd.c to exclude HTTrack, which seems to be an abusive spider. (check-in: b47f5ff005 user: drh tags: trunk)
2017-07-14
15:38
Update the change log and the SQLITE_STMT documentation to reflect the new table name. (check-in: d2cf72e32f user: drh tags: trunk)
15:37
Expand on the documentation for Tcl method "wal_hook". (check-in: 356a4d4687 user: dan tags: trunk)
13:00
Small wording change to the faster-than-fs document. (check-in: 98f02236a9 user: drh tags: trunk)
12:59
Fix the wording on a requirement about the REPLACE operation. (check-in: f2f32e8bfe user: drh tags: trunk)
03:53
Improvements to the COMPLETION table documentation. (check-in: 6043714558 user: drh tags: trunk)
2017-07-13
22:39
Fix the release date for 3.20.0. (check-in: ef397e0f00 user: drh tags: trunk)
22:24
Documentation for PRAGMA secure_delete=FAST. Better hyperlinks on the change log. (check-in: ed98e4b3bf user: drh tags: trunk)
20:59
Add basic documentation for the COMPLETION extension. (check-in: 875a26d2d9 user: drh tags: trunk)
19:25
Fix documentation typos from David Raymond. (check-in: 73c3c21f31 user: drh tags: trunk)
19:12
Merge fixes from the 3.19.0 branch. (check-in: 3a97831e93 user: drh tags: trunk)
19:11
Updates to the carray() documentation and the change log. (check-in: 1563329e78 user: drh tags: trunk)
18:25
Add a bullet point to the release notes about the new _pointer() interfaces. (check-in: 2ffb71a3a7 user: drh tags: trunk)
2017-07-11
14:31
Mention tab-completion in the change log for 3.20.0. (check-in: bc8bf74d88 user: drh tags: trunk)
14:00
Clarify how the % operator works. (check-in: 3cb8f4e5f2 user: drh tags: branch-3.19)
2017-07-10
20:11
Updates to the change log for version 3.20.0 (check-in: 424efe1633 user: drh tags: trunk)
19:55
Merge fixes from the 3.19 branch. (check-in: fea84d9dc3 user: drh tags: trunk)
19:49
Fix a typo in the dbstat.html document. (check-in: 4160ca5c08 user: drh tags: branch-3.19)
18:11
Typo fixes. (check-in: 2a08b85198 user: drh tags: branch-3.19)
2017-07-09
18:49
Fix typo in the appfileformat.html document. (check-in: 67789bcd04 user: drh tags: branch-3.19)
2017-07-03
11:01
Fix a typo in the FOREIGN KEY documentation. (check-in: 58cb4dd691 user: drh tags: branch-3.19)
2017-07-01
23:24
Attempt to improve the INSERT documentation. (check-in: 6b1a2005d8 user: drh tags: branch-3.19)
23:23
Attempt to improve the INSERT documentation. (check-in: 89ca937f0e user: drh tags: trunk)
2017-06-30
00:47
Add the "fts5ext.so" target for building an SQLite extension that enables the sqlite3 command-line shell to access the website search database. (check-in: 4110cb10fc user: drh tags: trunk)
00:18
Update to the CLI documentation. (check-in: e792c53939 user: drh tags: trunk)
2017-06-29
20:54
Update the speed-size graph spreadsheet (check-in: 8b7c30639e user: drh tags: trunk)
18:27
Mention the -withoutnulls option to the "db eval" method in the TCL interface documentation. (check-in: b1785f3962 user: drh tags: trunk)
18:17
Add documentation for the STMT virtual table (check-in: 3c1197562c user: drh tags: trunk)
17:33
Mention the sqlite3_prepare_v3() enhancement in the change log. (check-in: 9421ab387b user: drh tags: trunk)
14:53
Updates to the query planner stability guarantee description to make it clear that it is off by default. (check-in: fa4e2ba5b2 user: drh tags: trunk)
14:47
Initial draft of release notes for version 3.20.0. (check-in: fe054454f3 user: drh tags: trunk)
2017-06-26
14:43
Correction to the schema for the DBSTAT virtual table. (check-in: a30aad4d5c user: drh tags: trunk)
2017-06-17
13:51
Add a reference to the Jim Gray paper to the faster-than-filesystem article. (check-in: b37cb6bc60 user: drh tags: trunk)
10:14
Add change log, news, and chronology entries for the 3.18.2 backpatch release. (check-in: d7d183be5b user: drh tags: trunk)
00:32
Add a missing bug fix to the 3.19.0 change log. (check-in: 29f6671c4f user: drh tags: trunk)
2017-06-16
13:46
Put the correct hash identifiers on the 3.18.1 release. (check-in: 2b4095363b user: drh tags: trunk)
11:53
Add change-log, chronology, and news entries for the 3.18.1 release. (check-in: 48b0c119e2 user: drh tags: trunk)
2017-06-09
12:23
Clarify the rules for referencing tables in triggers. (check-in: e0f55595d4 user: drh tags: trunk)
2017-06-08
19:31
Refinements to the faster-than-filesystem article based on peer review. (check-in: e5a09f2ea2 user: drh tags: trunk)
14:34
Version 3.19.3 (check-in: 9a562cf207 user: drh tags: trunk, release, version-3.19.3)
12:46
Preliminary changes for the 3.19.3 release. (check-in: 4a29b53e40 user: drh tags: trunk)
00:28
Flag the faster-than-filesystem report as "under development" (check-in: 029e600ba4 user: drh tags: trunk)
2017-06-07
14:00
Fix typo in the file format document. (check-in: 64a0c62941 user: drh tags: trunk)
2017-06-06
20:24
Minor tweak to the aff_short.html document. (check-in: ede2d703a0 user: drh tags: trunk)
17:29
Tweaks to the faster-than-filesystem document to make it more mobile-friendly. (check-in: fb0299e43a user: drh tags: trunk)
15:16
New hyperlinks to the faster-than-filesystem paper. (check-in: 1539b18574 user: drh tags: trunk)
15:03
Update the "35% faster than the filesystem" document to talk about write performance. (check-in: d6c152123c user: drh tags: trunk)
2017-06-05
11:04
Change references to www.hwaci.com to use HTTPS instead of HTTP (check-in: 43205871ea user: drh tags: trunk)
2017-06-02
11:27
Fix a typo in the session documentation. (check-in: acfc24126f user: drh tags: trunk)
11:24
Remove an incorrect statement about sessions and WITHOUT ROWID from the WITHOUT ROWID documentation. (check-in: 65df8fdcfa user: drh tags: trunk)
2017-05-25
16:56
Version 3.19.2 (check-in: 27e87090c9 user: drh tags: trunk, release, version-3.19.2)
00:40
Initial changes for the 3.19.2 release. (check-in: 21ff2eb546 user: drh tags: trunk)
2017-05-24
13:18
Version 3.19.1 (check-in: 522b8714da user: drh tags: trunk, release, version-3.19.1)
2017-05-23
12:49
Start a change log for the 3.19.1 patch release. (check-in: 3abd703937 user: drh tags: trunk)
2017-05-22
20:04
Another typo in the faster than filesystem document. (check-in: de15ebf872 user: drh tags: trunk)
20:01
Fix typo and clarify wording in the new faster-than-filesystem update. (check-in: 2912902889 user: drh tags: trunk)
19:38
Fix another release note typo. (check-in: 4020461a82 user: drh tags: trunk)
19:28
Fix typo in the 3.19.0 release notes. (check-in: 76f5154a37 user: drh tags: trunk)
19:23
Add a chart of raw data to the faster-than-filesystem page. (check-in: 5f95a7df66 user: drh tags: trunk)
14:02
Version 3.19.0 (check-in: 9ae6f97cab user: drh tags: trunk, release, version-3.19.0)
13:49
Fix typos in the opcodes.html document. (check-in: d11890e573 user: drh tags: trunk)
13:36
Update the speed-and-size spreadsheet. (check-in: 5bed01e6bb user: drh tags: trunk)
2017-05-15
17:07
Add the "Why Is SQLite Coded In C" document. (check-in: edc057616f user: drh tags: trunk)
2017-05-12
21:05
Hyperlinks to the faster-than-the-filesystem report from the two application-file-format articles. (check-in: a79b7fc8f1 user: drh tags: trunk)
20:17
Mention the anycollseq.c loadable extension in the release notes. (check-in: c7eb4e0706 user: drh tags: trunk)
02:13
Fix typo in the change log. (check-in: 6aca55b1f8 user: drh tags: trunk)
2017-05-11
18:44
Add the json_extract() enhancement to the change log. (check-in: 48487a9f5c user: drh tags: trunk)
15:55
Mention the FTS5 column filter enhancement in the change log. (check-in: b65a1fd59e user: drh tags: trunk)
13:36
Fix the description of the SQLITE_READ authorizer change in the change log. (check-in: fd8d8bb382 user: drh tags: trunk)
2017-05-10
16:38
Update the 35%-faster document to the latest from trunk. (Leaf check-in: 7e41434c2b user: drh tags: branch-3.18)
16:38
Minor wording tweaks to the 35%-faster document. (check-in: a1177bfca0 user: drh tags: trunk)
16:34
Add the SQLITE_READ authorizer change to the change log for 3.19.0. (check-in: 84e21ebf22 user: drh tags: trunk)
2017-05-05
16:56
Copy the 35% faster changes from trunk. (check-in: 6fa9ca7f89 user: drh tags: branch-3.18)
16:55
Updates to the 35% faster document. (check-in: ac27ab7f6f user: drh tags: trunk)
12:55
Import the faster-than-filesystem document from trunk. (check-in: 488af3774f user: drh tags: branch-3.18)
2017-05-04
20:23
More tweaks to the 35% faster document. (check-in: 3563b95114 user: drh tags: trunk)
20:14
Fix typos and make improvements to the 35% faster document. (check-in: 4764f16dc0 user: drh tags: trunk)
19:44
Add the "35% Faster Than The Filesystem" document. (check-in: fd906f77ce user: drh tags: trunk)
2017-05-02
18:46
Update the change log and the speed-and-size graph. (check-in: 03fde5ae27 user: drh tags: trunk)
01:31
Fix typo. (check-in: f230c5ce7d user: mistachkin tags: trunk)
2017-04-29
18:03
Further improvements to the opcode.html document. (check-in: 1f4f0600ef user: drh tags: trunk)
16:55
Improved background information on the bytecode engine. (check-in: 21168dec96 user: drh tags: trunk)
2017-04-18
11:52
Update to the flattening optimization description in the optoverview.html page. Add a new bullet to the change log for 3.19.0. (check-in: d26b238e7e user: drh tags: trunk)
11:40
Add a change log entry for the pending 3.19.0 release. (check-in: 31ead1aade user: drh tags: trunk)
11:07
Update the perfomance and size spreadsheet with the latest figures. (check-in: 7b34966b61 user: drh tags: trunk)
2017-04-17
18:13
Update the documentation on the foreign_key_check pragma to explain that the second output column is NULL for WITHOUT ROWID child tables. (check-in: af6ceab74d user: drh tags: trunk)
2017-04-13
09:59
Update fts5 docs to reflect support for a user column on the LHS of a MATCH operator. (check-in: ab263df2e6 user: dan tags: trunk)
2017-04-12
20:02
Attempt to clarify the operation of the page_size pragma. (check-in: 6d2df6128e user: drh tags: trunk)
20:00
Update fts5 documentation to reflect new column filter capability. (check-in: 27ba2d2d59 user: dan tags: trunk)
2017-04-11
23:14
Fix a typo on the compile.html page. (check-in: 5c613c450a user: drh tags: trunk)
19:19
Fix typos in the howtocorrupt.html document. (check-in: 20b925f012 user: drh tags: trunk)
19:15
Update the JSON1 documentation to state the 2000-level limit on recursion. (check-in: 0bcdcaff9c user: drh tags: trunk)
2017-04-08
11:38
Clarify what it means when it says "JSON1 is not available by default." (check-in: 16bd995f65 user: drh tags: trunk)
2017-03-31
15:40
Fix typos and clarify text in the sessionintro.html document. (check-in: 1bac33959e user: drh tags: trunk)
2017-03-30
16:43
Add documentation for the unlock_notify method of the TCL interface. (check-in: d6dd485d18 user: drh tags: trunk)
15:02
Add a news entry for 3.18.0. (check-in: 8df001ccf7 user: drh tags: trunk)
14:13
Update the date of the 3.18.0 release in changes.in. (check-in: 52e170b093 user: dan tags: trunk, release, version-3.18.0)
11:49
Version 3.18.0 (check-in: b52ffdcfb4 user: drh tags: trunk)
2017-03-28
18:47
Update the size and speed spreadsheet. (check-in: 386e017de4 user: drh tags: trunk)
2017-03-24
19:19
Update the change log so that it shows the OP_Once bug fix. (check-in: 82e4157c6b user: drh tags: trunk)
2017-03-23
23:45
Add documentation for the json_patch() SQL function. (check-in: 3c4519094f user: drh tags: trunk)
2017-03-20
15:36
Report the fix of the sqlite3_trace_v2() output for nested SQL. (check-in: a432575098 user: drh tags: trunk)
14:42
Improved documentation for automatic analyze using PRAGMA optimize. (check-in: 1bbfd06810 user: drh tags: trunk)
13:05
Add the changes to SQLITE_SOURCE_ID to the change log. (check-in: 717afb7f73 user: drh tags: trunk)
12:26
Merge changes from the 3.17.0 release. (check-in: 3ff90dd03b user: drh tags: trunk)
12:25
Include a link to the draft change log on Pre-Release Snapshots on the download page. (Leaf check-in: 1b710ef1fc user: drh tags: 3.17)
12:10
Refinements to the change log for 3.18.0. (check-in: 967d54a0f6 user: drh tags: trunk)
2017-03-17
23:06
The change log addition of the previous check-in went into the wrong release. This check-in fixes the problem. (check-in: 71622aac82 user: drh tags: trunk)
23:00
Add enforcement of SQLITE_LIMIT_VDBE_OP to the change log. (check-in: 6e5fa8b967 user: drh tags: trunk)
2017-03-16
20:26
Update the speed and size graph. (check-in: fe8607b103 user: drh tags: trunk)
12:55
Merge doc fixes from the 3.17.0 release. (check-in: bb08575574 user: drh tags: trunk)
12:49
Mention the requirement of Fossil 2.0 in getthecode.html. (check-in: 36cbd238b5 user: drh tags: 3.17)
2017-03-15
23:10
An initial top-level README.md file. (check-in: 1b99dd4dc8 user: drh tags: trunk)
20:51
Update the details of when the LIKE optimization is allowed, due to enhancements to the LIKE optimization logic in 3.18.0. (check-in: 7c122e0975 user: drh tags: trunk)
20:32
Further refinement to the loadable extension documentation. (check-in: cecf106465 user: drh tags: trunk)
15:59
Improvements to CLI documentation. Expand the Examples section of the loadable extension document. (check-in: d2d3de4f3f user: drh tags: trunk)
14:08
Fix typos and improve the wording of the .selftest documentation. (check-in: 6aaee6c270 user: drh tags: trunk)
13:56
Preliminary documentation for the .sha3sum and .selftest commands of the CLI. (check-in: a4e4f94863 user: drh tags: trunk)
2017-03-14
23:28
Tighten and formalize the hack in althttpd that allows .well-known path prefixes on URIs. (check-in: adbefa195f user: drh tags: trunk)
02:17
Modify althttpd.c to allow web content in the ".well-known" directory. (check-in: 10a66e4535 user: drh tags: trunk)
2017-03-10
16:37
Add documentation for the SQLITE_MAX_MEMORY compile-time option. (check-in: 268f62bc5a user: drh tags: trunk)
2017-03-09
13:36
Initial work on improving the CLI documentation. Much more needed here. (check-in: fcac2a0e45 user: drh tags: trunk)
12:06
Fix a typo in the date of the 3.16.1 release on news.html. (check-in: 46dd340a24 user: drh tags: 3.17)
2017-03-07
22:25
Fix a typo in the file format document. (check-in: 01b45f38af user: drh tags: trunk)
13:08
Merge the search form fix from the 3.17 branch. (check-in: 4a748fb25c user: drh tags: trunk)
13:05
Fix the action= link for the search form on pages that are not at the top level. (check-in: 564d1318f8 user: drh tags: 3.17)
00:51
Change the defined default mask for PRAGMA optimize to 0xfffe. (check-in: b4f5fcc3c8 user: drh tags: trunk)
2017-03-06
23:14
Fix typo in the pragma optimize documentation. (check-in: f61736804d user: drh tags: trunk)
21:03
More typo fixes and enhancements to the 3.18 change log. (check-in: fc711f28f5 user: drh tags: trunk)
20:54
Fix a typo in the 3.18 change log. (check-in: 82f55fbab0 user: drh tags: trunk)
20:49
Initial documentation changes for 3.18.0. Add documentation for PRAGMA optimize and update documentation for PRAGMA integrity_check and quick_check. (check-in: f7a0591178 user: drh tags: trunk)
19:56
Merge fixes from the 3.17 branch. (check-in: 02cadace0c user: drh tags: trunk)
11:34
Fix typos in the malloc.html document. (check-in: 31b59e00e5 user: drh tags: 3.17)
2017-03-04
20:09
Fix typo reported by Jeffrey Mattox. (check-in: 1a4aa7fa1d user: drh tags: 3.17)
2017-02-22
12:43
Fix typos in the documentation reported by Karol Swietlicki. (check-in: d24b5395d0 user: drh tags: 3.17)
2017-02-15
22:44
Fix a harmless typo in the rollback journal checksum algorithm description. (check-in: ebd7ef38cc user: drh tags: trunk)
22:43
Correct the rollback journal checksum algorithm description. (check-in: b69eaea914 user: drh tags: trunk)
2017-02-14
20:18
Enhanced documentation for the ".separator" and ".mode quote" commands in the CLI. (check-in: 95afd54c2e user: drh tags: trunk)
2017-02-13
16:13
Update dates and tags for the 3.17.0 release. Also fix a hyperlink target in the testing.html document. (check-in: 60bb99911d user: drh tags: trunk, release, version-3.17.0)
11:53
Update sessionintro.in to reflect the support for WITHOUT ROWID tables in the sessions module. (check-in: c6eb84e1aa user: dan tags: trunk)
2017-02-10
17:56
Add news for 3.17.0. Set the dates and check-in hash for 3.17.0. (check-in: 2ca5036003 user: drh tags: trunk)
2017-02-09
19:48
Final adjustments to the change log before starting release tests. (check-in: b6f0b02c8c user: drh tags: trunk)
2017-02-08
18:10
Clarification of a sentence in the R-Tree documentation. (check-in: 96728cbc13 user: drh tags: trunk)
2017-02-04
16:22
Update the preformance spreadsheet (check-in: 49eb6735bf user: drh tags: trunk)
15:16
Updates to the change log for 3.17.0. (check-in: 90822d4b15 user: drh tags: trunk)
14:45
Remove obsolete statements from the EXPLAIN QUERY PLAN documentation. (check-in: 735ffb4d2d user: drh tags: trunk)
2017-02-03
04:10
Clarify wording about PRAGMA synchronous=NORMAL and WAL mode. (check-in: 7660cac647 user: drh tags: trunk)
2017-02-02
23:55
Clarify the behavior of AUTOINCREMENT after an UPDATE. (check-in: f6e2eab4e7 user: drh tags: trunk)
14:48
Update the wording on the description of the WHEN clause on triggers. (check-in: 09d3dc5c51 user: drh tags: trunk)
2017-01-29
11:39
Fix an obsolete example in the FTS3 documentation. (check-in: c90c7a1015 user: drh tags: trunk)
2017-01-28
14:45
Updates to the performance graph spreadsheet. (check-in: 63d1835d75 user: drh tags: trunk)
2017-01-18
02:41
Clarification of affinity, especially in regard to views and subqueries. (check-in: 513684f098 user: drh tags: trunk)
2017-01-14
14:31
Update the download message for prerelease snapshots. Fix a typo in the 2017 dates of the chronology. (Leaf check-in: c22f7ef4b3 user: drh tags: branch-3.16)
2017-01-12
20:25
Proposed enhancement to the definition of column affinity so that it covers columns belonging to subqueries and VIEWs. (check-in: 524ba450fb user: drh tags: trunk)
20:14
Begin adding changes for the 3.17.0 release. (check-in: 180288b238 user: drh tags: trunk)
19:43
Update the speed and size spreadsheet with the latest measurements from trunk. (check-in: 033eb12bb9 user: drh tags: trunk)
2017-01-06
17:28
Add a note about OSS Fuzz to the testing document. (check-in: f464b0a219 user: drh tags: trunk)
16:49
Second attempt at changing the date in news.html to 2017-01-06. (check-in: 05efe84bdd user: dan tags: trunk)
16:48
Change the date of the news.html entry for 3.16.2 to 2017-01-06. (check-in: 4cd739c3eb user: dan tags: trunk)
16:36
Adjust the change log and hashes for the 3.16.2 release. (check-in: 140541287d user: drh tags: trunk)
2017-01-05
17:53
Changes for the 3.16.2 release. (check-in: dea27852a0 user: drh tags: trunk)
2017-01-03
20:24
Version 3.16.1 (check-in: a9be5c2caa user: drh tags: trunk, release, version-3.16.1)
18:30
Add the final hashes and links for the 3.16.1 release. (check-in: 4d89cd68e7 user: drh tags: trunk)
16:45
Preliminary changes for the 3.16.1 release. (check-in: 9f0236befb user: drh tags: trunk)
15:32
Fix a typo in the change log. (check-in: 81b0ce16e7 user: drh tags: trunk)
2017-01-02
12:02
Add hashes and a chronology entry for the 3.16.0 release. (check-in: b01be9ce27 user: drh tags: trunk, release, version-3.16.0)
11:56
Added news for 3.16.0. Typo fixes and last-minute changes. (check-in: eb70d3b295 user: drh tags: trunk)
2016-12-31
19:55
Remove the not-found.html document. (check-in: 35ec903c39 user: drh tags: trunk)
15:41
Add lookaside change to the change log. Update testing stats. Other minor edits. (check-in: c31ae8096c user: drh tags: trunk)
2016-12-30
16:41
Update the cpu performance stats for Ubuntu 16.04 and GCC 5.4.0. (check-in: 0f60c6b4e4 user: drh tags: trunk)
2016-12-29
20:05
Typos and more updates to documentation. (check-in: 2e6a1f2be8 user: drh tags: trunk)
19:24
Fix a typo in imposter.html. (check-in: 1eb3e3ec71 user: drh tags: trunk)
18:39
Update the cpu-usage graph and the change log. Minor wording improvements in the datatype documentation. (check-in: aa485be4f2 user: drh tags: trunk)
2016-12-22
18:58
Information on PRAGMA table functions. (check-in: 70f4c8ee07 user: drh tags: trunk)
16:09
Updates to the performance graph spreadsheet. (check-in: 34c514f88e user: drh tags: trunk)
2016-12-16
21:26
Adjust the javascript that disables the search button on local browsing so that it works even on ancient browsers. (check-in: ea66b2e252 user: drh tags: trunk)
2016-12-14
11:31
Add the spreadsheet used to compute the performance graph. (check-in: 99240f2102 user: drh tags: trunk)
2016-12-13
19:11
Improve the wording on the change log entry for performance improvement. (check-in: cb109a5dc1 user: drh tags: trunk)
19:06
Update the change log to show a 6% CPU count reduction. Tweaks to the CPU usage measurement page. (check-in: fc30d4babb user: drh tags: trunk)
13:46
Updates to the memory-mapped I/O documentation to reflect that memory maps are always read-only. (check-in: 1b24b6113d user: drh tags: trunk)
00:11
Add in the latest CPU usage graph, showing version numbers along the graph line. (check-in: 3043f6595b user: drh tags: trunk)
2016-12-08
15:05
Add the CPU performance measurement document. (check-in: dd139223c4 user: drh tags: trunk)
2016-12-07
21:40
Boast about using 5% fewer CPU cycles on the change log for 3.16. (check-in: cd4044abac user: drh tags: trunk)
18:30
Improvements to wording and content of the SQLITE_UNTESTABLE docs. (check-in: 7133f9383a user: drh tags: trunk)
16:39
Update the change log to show the SQLITE_UNTESTABLE change. (check-in: dfe8cc2bd8 user: drh tags: trunk)
15:54
Improved documentation for SQLITE_OMIT_BUILTIN_TEST and SQLITE_UNTESTABLE. (check-in: 108398c17f user: drh tags: trunk)
2016-12-03
20:59
Update the change log for recent enhancements and bug fixes. (check-in: 332dab5c56 user: drh tags: trunk)
20:43
Improved sorting of the keyword index by ignoring initial punctuation characters. (check-in: 34fa170684 user: drh tags: trunk)
20:38
Simplified wording in the testing document. (check-in: 58ec3bd0d3 user: drh tags: trunk)
20:38
On the permuted title index, make unpermuted titles bold. (check-in: d0a0a01ce7 user: drh tags: trunk)
2016-11-30
19:07
Refinements to the bare column in aggregate query documentation. (check-in: f84dc83db4 user: drh tags: trunk)
2016-11-29
17:09
Merge more 3.15 changes into trunk. (check-in: a765b8866f user: drh tags: trunk)
2016-11-28
19:35
Clarify the Python entry on the famous users page. (Leaf check-in: b233527c05 user: drh tags: branch-3.15)
19:34
Fix a typo on the 3.15.2 change log, and add a News entry for 3.15.2. (check-in: 343d035585 user: drh tags: branch-3.15)
19:22
Merge changes from the 3.15 branch into trunk. (check-in: 1b36a2d2d4 user: drh tags: trunk)
19:18
Update change logs with the correct date for 3.15.2. (check-in: 0c84be29ea user: drh tags: branch-3.15)
2016-11-25
21:47
Fix typo in the FTS3/4 documentation. (check-in: 71a72a66ff user: drh tags: trunk)
20:10
More tweaks to the 3.15.2 change log. (check-in: 833bcb74d4 user: drh tags: branch-3.15)
13:37
Updates in preparation for the 3.15.2 release. (check-in: 7dce4ba2ff user: drh tags: branch-3.15)
2016-11-23
02:21
In the TCL interface documentation, mention that the busy callback takes a single integer argument which is the number of prior calls for the same locking event. (check-in: 215fcb1b90 user: drh tags: trunk)
2016-11-22
18:59
Further tweaks to language description due to row values. (check-in: 6d7d509612 user: drh tags: trunk)
18:37
SQL language documentation updates due to row values. (check-in: 437288e896 user: drh tags: trunk)
15:24
Discussion of bare columns in aggregate queries. (check-in: 8a4f72ebf1 user: drh tags: trunk)
14:05
Merge 3.15 branch changes into trunk. (check-in: 75391ba907 user: drh tags: trunk)
2016-11-04
13:14
Add a news entry for 3.15.1. (check-in: 953ce31e7e user: drh tags: branch-3.15)
12:12
Add the hashes for version 3.15.1. (check-in: e8b34d5547 user: drh tags: branch-3.15)
2016-11-03
19:02
Prepare for the 3.15.1 release. (check-in: 5b0368d51e user: drh tags: branch-3.15)
14:46
Add documentation on imposter tables. (check-in: 2f88520e33 user: drh tags: trunk)
13:27
Update the change log. (check-in: 06f94a998c user: drh tags: trunk)
2016-11-02
13:46
Start a change log for version 3.16.0. (check-in: c269f2074d user: drh tags: trunk)
13:31
Merge documentation fixes from the release. (check-in: fd68fab5c0 user: drh tags: trunk)
13:29
Further clarification of text in the AUTOINCREMENT documentation. (check-in: 3c7ab13e8b user: drh tags: trunk)
13:14
Add mention of LIKE and GLOB working with NOT NULL partial indexes. (check-in: 936fba6896 user: drh tags: trunk)
12:16
Fix typo in the rowvalue.html document. (check-in: a33b4bf02c user: drh tags: branch-3.15)
2016-10-31
19:02
Fix a broken link to the Lemon documentation. (check-in: 7434eb6397 user: drh tags: branch-3.15)
17:47
Update documentation on AUTOINCREMENT to indicate that it only works for INSERT and not UPDATE. (check-in: 71511a055b user: drh tags: trunk)
13:19
Additional cross-referencing of query planner documents. (check-in: e5277d7908 user: drh tags: trunk)
2016-10-27
15:12
Clarification to the incremental_vacuum documentation. (check-in: 767d991dda user: drh tags: trunk)
2016-10-25
14:50
Enhance the file format document to explain how sqlite_stat1 works for WITHOUT ROWID tables. (check-in: df4011932b user: drh tags: trunk)
2016-10-14
19:35
Fix typo on row value example. (check-in: 2d5915fdd8 user: drh tags: trunk)
10:23
Add hashes for 3.15.0 to the change log. Update the chronology. (check-in: 55f49500f9 user: drh tags: trunk)
10:16
Fix two spelling errors. (check-in: b951d26933 user: drh tags: trunk)
2016-10-13
17:09
Add the release date for 3.15.0. Still need to put in the SHA1 hash for the release check-in. Added a news entry. (check-in: c56346001f user: drh tags: trunk)
2016-10-12
22:22
Fix a typo. "CVS" should be "CSV". (check-in: ff0e70ab45 user: drh tags: trunk)
15:45
Add the fix for the latest ORDER BY LIMIT bug to the change log. (check-in: 3c17612648 user: drh tags: trunk)
2016-10-10
20:55
Fix a typo and slightly expand the "features.html" page. (check-in: 902d14ff5c user: drh tags: trunk)
13:42
Add the index-on-expression NULL handling fix to the bug list for 3.15.0. (check-in: c3d3435f05 user: drh tags: trunk)
10:33
Fix a date typo on the 2.0.0 release entry of the change log. (check-in: 4b0e288692 user: drh tags: trunk)
2016-10-04
19:04
Fix a typo in the new "deterministic function" document. (check-in: 823806a276 user: drh tags: trunk)
15:45
New documentation on deterministic functions. (check-in: 3a07cbb6d5 user: drh tags: trunk)
2016-10-03
18:25
Add the non-deterministic partial index enhancement to the 3.15.0 change log. (check-in: 9ff5e207d7 user: drh tags: trunk)
18:13
Allow deterministic functions in the WHERE clause of a partial index. (check-in: 2aa016e0a8 user: drh tags: trunk)
16:41
Increase the 3.15.0 preformance gain number to 7%. (check-in: 457b37bad2 user: drh tags: trunk)
11:55
Update the change log for new optimizations and the AUTOINCREMENT bug fix. (check-in: 33174a6a8f user: drh tags: trunk)
2016-09-30
22:31
Update the preformance increase on the change log. (check-in: 5f8cc85f5d user: drh tags: trunk)
2016-09-29
14:20
Rework the list of adjectives on the "SQLite is" line of the home page. (check-in: e073115146 user: drh tags: trunk)
14:10
Add the "high-reliability" page. Enhance the home page to reference "self-contained". Rework the self-contained page. (check-in: fd74494a34 user: drh tags: trunk)
2016-09-28
16:04
Fix typos. (check-in: 2a02e13870 user: drh tags: trunk)
14:22
Add "About" and "Download" to the drop-down menu on mobile. (check-in: b20b7983da user: drh tags: trunk)
14:07
Add dateof: macros to a couple of legacy documents. (check-in: eb90986099 user: drh tags: trunk)
13:42
Remove some duplicate chronology entries. Add a total at the bottom of the chronology. Fix a typo in the change-log generator. (check-in: 63090a72fc user: drh tags: trunk)
13:24
Updates to the FAQ (check-in: a68ef4b91a user: drh tags: trunk)
13:07
Add more [dateof:...] markup in the language description pages. (check-in: 6c79d37f0a user: drh tags: trunk)
12:59
New hyperlinks on the Full-Featured SQL page. (check-in: ba6e48411e user: drh tags: trunk)
11:52
Revise the "Full-Featured SQL" page to use just a single bullet-list of features. Add the discription "Clustered Index" to the WITHOUT ROWID page. (check-in: 2e1576a5a9 user: drh tags: trunk)
11:23
Fix a typo in Long-Term Support. (check-in: e6fa42924d user: drh tags: trunk)
11:22
Remove the "sustainable business model" argument from Long-Term Support. (check-in: f019f80a0e user: drh tags: trunk)
04:01
Futher refinement of the Full-featured SQL page. (check-in: d3731ef887 user: drh tags: trunk)
03:53
Add the Full-Featured SQL page. (check-in: 145980fe6f user: drh tags: trunk)
00:54
Fix a typo in the architecture document. (check-in: 27fee8962c user: drh tags: trunk)
00:53
Make the architecture image responsive. (check-in: 639000a718 user: drh tags: trunk)
00:49
Trying to update and improve the "Architecture" document. (check-in: 6316228a33 user: drh tags: trunk)
2016-09-27
23:04
Fix typo in the file format document. (check-in: 6e2e589a04 user: drh tags: trunk)
23:01
New alternative title for the On-Disk Format document. (check-in: 8615868905 user: drh tags: trunk)
22:45
More lts.html refinements. (check-in: 8730ac829e user: drh tags: trunk)
20:09
Tweaks to long-term support. (check-in: 8724e4b982 user: drh tags: trunk)
19:56
Add the "Long-term Support" document. (check-in: db4a43fe7d user: drh tags: trunk)
18:26
On the About page, change the "common links" sidebar into "Executive summary" (check-in: feebb52d8a user: drh tags: trunk)
18:01
Add the "searchdb" target to the "help" output for "make". (check-in: 93e6a53620 user: drh tags: trunk)
16:34
Add the "Many Small Queries Are Efficient In SQLite" page. (check-in: 2ff8c085a7 user: drh tags: trunk)
00:33
Update the makefile to put sqlite.css in the matrix directory. (check-in: 0fd7f82fa7 user: drh tags: trunk)
00:20
Remove the duplicate SQLITE_MAX_EXPR_DEPTH documentation. (check-in: 50e0e6008a user: drh tags: trunk)
2016-09-26
20:35
Add the "Recommended Compile-time Options" section to the compile.html document. (check-in: 67fa7525c1 user: drh tags: trunk)
16:02
New warnings about the possibility of corruption the database when certain pragmas are used. (check-in: bc4e6344c0 user: drh tags: trunk)
13:16
Update the change log to show the 2% performance gain over 3.14.2. (check-in: bf03335759 user: drh tags: trunk)
2016-09-23
14:33
Add an example of using row values in an UPDATE to the row value document. (check-in: 0bc1f4cfc7 user: drh tags: trunk)
11:32
Fix a LHS/RHS mixup in the rowvalue documentation. (check-in: db4e5cec36 user: drh tags: trunk)
2016-09-22
18:03
Provide for alternative document titles using <alt-title>...</alt-title>. Have the document page come up with the first sublist (containing lists of other documents) open automatically. (check-in: 22726478ad user: drh tags: trunk)
17:19
Fix typos in the opcode.html page. (check-in: bfe3dc203f user: drh tags: trunk)
2016-09-21
19:45
Adjust the date on the "current release" so that it read correctly even when the date is "pending". (check-in: 5ceba67384 user: drh tags: trunk)
19:28
Requirements mark fixes. (check-in: 0321b2ac62 user: drh tags: trunk)
15:17
Add the latest changes to the change log. (check-in: ba2eb30c24 user: drh tags: trunk)
13:34
Query planner tutorial updates. (check-in: 79dd9ff1e4 user: drh tags: trunk)
04:21
Remove duplicate disadvantage to WAL mode. (Leaf check-in: aa3809f595 user: drh tags: branch-3.14)
04:17
Remove duplicate disadvantage to WAL mode. (check-in: 4e5ba5873c user: drh tags: trunk)
2016-09-17
17:53
Update the update-stmt-limited syntax diagram and the text of the UPDATE documentation for the addition of row values. (check-in: ea28d5d596 user: drh tags: trunk)
17:39
Improvements to the bytecode engine documentation. (check-in: 20b7232027 user: drh tags: trunk)
17:10
Update the syntax diagram for UPDATE to show the ability to use row values. (check-in: 7f09c9eed4 user: drh tags: trunk)
16:57
Show "(pending)" for the dateof: of unreleased versions. Improvements to wording of recently added or modified documents. (check-in: 30cfddb6c9 user: drh tags: trunk)
15:55
On the current release log, show "(Pending)" instead of a date if the date contains a day of -00. (check-in: 7abf781c1d user: drh tags: trunk)
15:49
Provide a link to the draft changelog on the prerelease snapshot description. (check-in: 90de403f24 user: drh tags: branch-3.14)
15:44
Tweaks to the amalgamation.html and the getthecode.html pages. (check-in: ff6dbcdcf3 user: drh tags: trunk)
2016-09-16
17:02
Fix a missing <p> in the queryplanner document. (check-in: bdc4835c0b user: drh tags: trunk)
2016-09-14
21:12
Fix unescaped > characters in vtab.in. (check-in: aa59a746e9 user: drh tags: trunk)
21:07
Add documentation for the modeof= query parameter. (check-in: 6f85762df5 user: drh tags: trunk)
21:05
Fix a bug in search/hdom.tcl causing it to insert closing tags for elements such as <br>. (check-in: c7aa23108e user: dan tags: trunk)
20:49
Add the "Debugging Hints" document. (check-in: e79705daa6 user: drh tags: trunk)
18:40
Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: 858d993381 user: drh tags: trunk)
17:45
Update documentation on VACUUM to describe how attached databases can be vacuumed. (check-in: 6f01723464 user: drh tags: trunk)
17:28
Update syntax diagrams for expr and vacuum. (check-in: 3f00f6192a user: drh tags: trunk)
16:27
Continuing work on the row value documentation. (check-in: ee61092516 user: drh tags: trunk)
04:12
Start a change log for 3.15.0. Begin writing documentation for row values and for the generate_series table-valued function. (check-in: bdbea7dc63 user: drh tags: trunk)
03:45
Add the 3.14.2 release to the chronology. (check-in: 54fe7773db user: drh tags: trunk)
03:39
Add the correct release date for 3.14.2 on the homepage. (check-in: b7faa9d562 user: drh tags: trunk)
2016-09-13
23:54
Add links to android bindings, SDS, and Fossil to the documentation lists. (check-in: e581a20834 user: drh tags: trunk)
22:45
One of the disadvantages of WAL mode is that one cannot change the page_size. (check-in: 006ea9f849 user: drh tags: trunk)
22:40
Version 3.14.2 (check-in: bf7ce59b7b user: drh tags: trunk, release, version-3.14.2)
20:39
Enable a table-of-contents on the WAL documentation. Fix typos in the previous check-in. (check-in: e1960990d2 user: drh tags: trunk)
20:28
Add a section to the WAL documentation that describes some of the scenarios in which a query can get SQLITE_BUSY. (check-in: 9466a94ec8 user: drh tags: trunk)
01:12
Use <codeblock> in more places, instead of <blockquote><pre>. Improved CSS for codeblock and for syntax diagrams. (check-in: 14e4769852 user: drh tags: trunk)
2016-09-12
21:06
Fix formatting problems in vtab.html associated with <yyterm> marks. (check-in: 2262f22f31 user: drh tags: trunk)
21:01
Fix a typo in vtab.in. (check-in: 4df3244e10 user: dan tags: trunk)
20:59
Fix handling of
  • markup in hdom.tcl.
(check-in: dcf4e23f9b user: dan tags: trunk)
20:54
Add links to the Android Bindings repository. (check-in: 7bf5343c19 user: drh tags: trunk)
18:59
Add the 3.14.2 hashes to the change log. (check-in: d2267a9398 user: drh tags: trunk)
18:46
Fix parsehtml so that it recognizes <tcl>...</tcl> as in-line markup. (check-in: 587b9b0128 user: drh tags: trunk)
18:10
Update the news for the 3.14.2 release. (check-in: 3270d5018f user: drh tags: trunk)
18:07
Enhancements to the "cintro.html" document. (check-in: 27bb41c97d user: drh tags: trunk)
17:49
Minor wording improvements in the application file format document. (check-in: 511e39cbb5 user: drh tags: trunk)
17:29
Make the "cintro.html" article more mobile-friendly. (check-in: e540e313e6 user: drh tags: trunk)
16:22
Updates to the "docs.html" page so that it uses the same <ul>-style format on desktop as it does on mobile, except that the detailed document descriptions are shown on desktop while still omitted on mobile. (check-in: 572767e60b user: drh tags: trunk)
15:39
Split out the "Document Lists and Indexes" category at top of the categorical document list. Change the name of "Result Codes" to "Result and Error Codes" to make the document easier to find. (check-in: 8f221f2df8 user: drh tags: trunk)
10:59
Corrections to the statement that defines when the "PRAGMA page_size" macro is not a no-op. (check-in: 1d425258b1 user: drh tags: trunk)
08:34
Fix the search script so that it can search for individual pragmas. Fix a mismatched tag in the document headers causing the search script to index the menubar on every page. (check-in: 4d25c80abf user: dan tags: trunk)
2016-09-09
15:38
Initial change log for the 3.14.2 release. (check-in: 3324b46ab0 user: drh tags: trunk)
2016-09-07
14:45
Fix a typo on compile.html. (check-in: c45332bd5c user: dan tags: trunk)
2016-09-06
00:32
Fix typo on the homepage. (check-in: 3f158f149c user: drh tags: trunk)
2016-09-05
17:18
More mutation testing documentation. (check-in: 34514986f4 user: drh tags: trunk)
16:51
In the testing document, use <codeblock> instead of <pre> and add a section on mutation testing. (check-in: 15b43e7cdb user: drh tags: trunk)
2016-09-03
19:43
Improved hyperlinks in the history of releases. (check-in: a5156889f3 user: drh tags: trunk)
2016-09-02
19:04
Cause the comments within example code in sessionsintro.html to be in blue italic type. (check-in: 59b5461497 user: dan tags: trunk)
18:36
Update the "famous users" page to try to make it more mobile-friendly. (check-in: 709a8a255b user: drh tags: trunk)
18:35
Fix a mismatched tag in sessionintro.in. (check-in: 1abe86b9d2 user: dan tags: trunk)
17:47
Restore the old-style "Documentation" page for desktop while keeping the newer style for mobile. (check-in: 6268aa1b1a user: drh tags: trunk)
17:15
Fix the linkage between sqlite3_backup_xxxxxx() functions and their documentation. (check-in: 78c26d4a46 user: drh tags: trunk)
17:03
Store debugging information in the doc_vardump.txt file after building all documentation. (check-in: cb35d7c443 user: drh tags: trunk)
16:57
Rename the output_list proc to hd_list_of_links and move its implementation from capi3ref.in into wrap.tcl, since it is used as common code. (check-in: c3c40d6711 user: drh tags: trunk)
16:30
Remove unnecessary javascript from the header. Improvements to rendering of C APIs. (check-in: 4180b2cf6f user: drh tags: trunk)
15:25
Remove some unnecessary leading whitespace from generated page content. (check-in: 03b286c8ac user: drh tags: trunk)
14:38
Restructure the website to be more mobile friendly. Put CSS into a separate sqlite.css file. Use responsive layout techniques. This is a work-in-progress. (check-in: 8e1edafe16 user: drh tags: trunk)
12:22
Fix the hyperlink on the logo. (Closed-Leaf check-in: 6fc0f8db82 user: drh tags: mobile-friendly)
12:17
Fix typos and tighten some sentences in the prosupport page. (check-in: ec9d984cb5 user: drh tags: mobile-friendly)
01:33
Typo fix on the obsolete version3.html document. (check-in: a97ba0fa9d user: drh tags: mobile-friendly)
01:23
Less indentation for bullets of the change long on mobile. (check-in: e887482396 user: drh tags: mobile-friendly)
01:19
Fix the font-size of CodeBlock to 1em. (check-in: a12a0dd1b0 user: drh tags: mobile-friendly)
01:04
Improved rendering of CodeBlock in fancy-format. (check-in: a5ef7d9aff user: drh tags: mobile-friendly)
00:30
Improve the cross-platform display of show/hide lists. (check-in: 84b8acdf6c user: drh tags: mobile-friendly)
2016-09-01
21:53
Refinements to the prosupport.html page. (check-in: cc74d20ccd user: drh tags: mobile-friendly)
21:43
Make the prosupport.html page local. (check-in: a65f9087ca user: drh tags: mobile-friendly)
20:58
Hack to get "make searchdb" running again. (check-in: 304b04a18c user: drh tags: mobile-friendly)
19:12
Click-to-view for the table of contents on fancy-format. (check-in: 6d9737f221 user: drh tags: mobile-friendly)
18:38
Fix up the support.html page for mobile. Improved the look of "button" hyperlinks. (check-in: 5e4e985bf0 user: drh tags: mobile-friendly)
18:13
Display improvements for the list-of-documents documents. (check-in: 0ff35a28c6 user: drh tags: mobile-friendly)
16:32
Improved show/hide on the docs.html page. (check-in: 910e5ab927 user: drh tags: mobile-friendly)
15:15
Simplify the JSON documentation for better display on mobile. (check-in: 08908c99e5 user: drh tags: mobile-friendly)
14:36
Reduced indentation for fancy-format in mobile. (check-in: 47dbb59cad user: drh tags: mobile-friendly)
09:14
Change the "docs.in" file so that it shows all categories collapsed, initially. (check-in: b3567c150e user: drh tags: mobile-friendly)
02:08
Fix the syntax.html document so that it uses the output_list proc to generate a variable-column bullet list. (check-in: 028b7208ab user: drh tags: mobile-friendly)
01:54
The "Search" menubar option causes a drop-down search box to appear. (check-in: 61608e2d14 user: drh tags: mobile-friendly)
01:30
Modify the output of the "search" script so that it works better on mobile screens. (check-in: a4e77179b1 user: drh tags: mobile-friendly)
00:54
Update the comment on the output_list proc. Use the output_list proc from capi3ref.in to process session.in. (check-in: 6f74e2171b user: drh tags: mobile-friendly)
00:48
Reformat the core and aggregate function descriptions in a way that works better on mobile. Use the "output_list" proc for the lists of pragma and aggregate and core functions. (check-in: fc4a66aa03 user: drh tags: mobile-friendly)
2016-08-31
21:38
Limit the width of syntax diagram images to the width of the screen. (check-in: 2cbeb114ca user: drh tags: mobile-friendly)
21:18
Adjustments to the CSS for hyperlink buttons. (check-in: c40376b31c user: drh tags: mobile-friendly)
20:59
Close the "Menu" button submenu before leaving the page, in case the user returns to the page using the "Back" button. (check-in: 582eb4ef8a user: drh tags: mobile-friendly)
20:47
Automatically disable the "Search" menu option if the document does not originate from an HTTP server, since there is no chance of running the CGI script in that case. (check-in: 3de5aaebc8 user: drh tags: mobile-friendly)
20:03
Use the variable-number-of-columns routine for the keyword list. (check-in: 9e95bb666d user: drh tags: mobile-friendly)
19:13
Fix the multi-column bullet lists in the c3ref documents so that the number of columns varies with the screen width. (check-in: edc0f779f7 user: drh tags: mobile-friendly)
17:00
Further refinement of the home page. (check-in: 9bab722ac3 user: drh tags: mobile-friendly)
16:53
Update the "fancyformat.tcl" script to use pages/hdom.tcl to parse html. (check-in: 78f2f948fb user: dan tags: trunk)
15:09
Further improvements to the home page - make the sponsor images flow according to page width. (check-in: b44e46cbef user: drh tags: mobile-friendly)
13:35
Split out the CSS into a separate "sqlite.css" file. Add the "common_links" TCL procedure for generating the "Common Links" bullet list. Other changes to the homepage to try to be more mobile friendly. (check-in: 047e6c36f7 user: drh tags: mobile-friendly)
12:02
Use the experimental mobile-friendly menu. (check-in: b24301fa11 user: drh tags: mobile-friendly)
10:07
Fix date formats in the Last-Modified header. (check-in: 363a0d0503 user: drh tags: trunk)
07:00
Fix a build error in the previous commit. (check-in: 1e433b2be3 user: dan tags: trunk)
06:35
Store the search database, search-log database and search "admin" script in a separate directory. (check-in: 28aa410b46 user: dan tags: trunk)
2016-08-30
20:14
Alternative page header suitable for loading content into Fossil for display. (Leaf check-in: 42802d730e user: drh tags: xdoc)
17:05
Tweak the search engines ranking algorithm slightly. Add a logging database and a way for admins to view the most recent queries. (check-in: 4dd2793f98 user: dan tags: trunk)
16:37
Draft chagnes to the VACUUM documentation to describe the ability to VACUUM attached databases. (Leaf check-in: 08b1963db5 user: drh tags: vacuum-enhancement)
2016-08-29
20:44
Fix stray characters that managed to get into a commit of the header generator. (check-in: 3cb5fe9998 user: drh tags: trunk)
20:37
Make the search box always go to the "search" script in the root of the site, not to "/search". This enables the "search" script to work on /draft. (check-in: bd7343390c user: drh tags: trunk)
20:22
Use the same "tclsh.docsrc" binary for everything. (check-in: ddb4bf4fcf user: drh tags: trunk)
20:18
Add the $(TCLINC) to the arguments to build tclsh.docsrc (Closed-Leaf check-in: 8d6ba1bfab user: drh tags: experimental)
20:00
Fix a problem in the previous commit. (check-in: f1a680e527 user: dan tags: experimental)
19:59
Run all make scripts using the same tclsh binary - "tclsh.docsrc". (check-in: 28358c49d7 user: dan tags: experimental)
18:57
Include the TCL include path when building the searchdb target. (check-in: 8e290154f5 user: drh tags: trunk)
18:40
New improvements to the opcode documentation. (check-in: dd15111c6a user: drh tags: trunk)
18:38
Merge "experimental" with this branch. Adds more links to the front page, fts5 search, show/hide links for tables of contents and some other things. (check-in: e4c2e46a8c user: dan tags: trunk)
16:16
Typos in the opcodes.html document. (check-in: 4ab90dc6cf user: drh tags: trunk)
16:07
Improvements to the opcode.html page. Minor tweaks to legacy c_interface.html and queryplanner-ng.html (check-in: 5baf5a5191 user: drh tags: trunk)
15:41
Change the "show table-of-contents" setting so that it is off by default. Setting is still persistent. (Closed-Leaf check-in: a0e88fec0c user: dan tags: experimental)
15:01
Merge latest trunk changes into experimental branch. (check-in: b39f7479c0 user: dan tags: experimental)
14:46
Update to session module documentation. (check-in: c8d92d73ec user: dan tags: experimental)
11:56
Updates to TH3 documentation. (check-in: 8bc0546bb6 user: drh tags: trunk)
2016-08-27
23:54
Use &lt; instead of < in the r-tree documentation. (check-in: a55027b452 user: drh tags: trunk)
2016-08-26
18:52
Fix a bug in the previous checkin. (check-in: 92ed3a43f0 user: dan tags: experimental)
09:24
Add show/hide links for the "Table Of Contents" added to some documents. Use a cookie to make table of contents visibility a site-wide persistent setting. (check-in: ddd31d0018 user: dan tags: experimental)
2016-08-25
20:47
Merge trunk changes into this branch. (check-in: a3888fbe0e user: dan tags: experimental)
19:50
Update documentation for the sqldiff tool to include the --vtab option. (check-in: 0e6ed0fa48 user: dan tags: trunk)
17:29
Change the way sub-sections are selected by the search script. (check-in: c7628dcb37 user: dan tags: experimental)
12:18
Add <fancy_format> or <table_of_contents> markup to a few more documents. To ensure that there are enough anchors in the longer documents for the search script to use. (check-in: 066e5931ce user: dan tags: experimental)
2016-08-24
19:26
Further updates to search database and script. (check-in: cc51dec17e user: dan tags: experimental)
2016-08-20
17:22
Add "jump to" links to relevant sections of large documents in search results. (check-in: 9d49a78f9b user: dan tags: experimental)
2016-08-19
17:02
Fix more minor search problems. (check-in: c345859928 user: dan tags: experimental)
2016-08-18
20:07
Rework the site search to use FTS5. (check-in: 18e4a7b157 user: dan tags: experimental)
2016-08-17
12:01
In althttpd.c, increase the default maximum content size to 250MB. (check-in: f65bebb25e user: drh tags: trunk)
2016-08-16
10:46
Omit the underscore from hyperlinks in a few places where doing so makes the text less cluttered. (check-in: 70a94f20fa user: dan tags: experimental)
2016-08-15
20:16
Add new documents category - "Extensions". (check-in: d9b961a79a user: dan tags: experimental)
19:01
Undo a change made accidentally to docs.html. (check-in: d118188bb0 user: dan tags: experimental)
18:43
Fix layout issues in footer. Restrict footer to the front page only (not every page). (check-in: 5abf48cdb6 user: dan tags: experimental)
16:02
Add links to each section at the top of the docs.html page. (check-in: 336ce36b23 user: dan tags: experimental)
2016-08-13
20:02
Add experimental footer to each page featuring many of the links from docs.html. (check-in: 8200ba6e9a user: dan tags: experimental)
2016-08-12
08:17
Further fixes and enhancements to the About page. (check-in: f636f2cafe user: drh tags: trunk)
08:11
Fix a typo on the About page. (check-in: 6078886d9c user: drh tags: trunk)
07:15
Fix a typo on the download page. (check-in: 741e7a34be user: drh tags: trunk)
2016-08-11
19:12
News item for 3.14.1 added. (check-in: 8d42b5de02 user: drh tags: trunk)
19:02
Version 3.14.1 (check-in: 5d83625491 user: drh tags: trunk, release, version-3.14.1)
18:08
Update the change log for version 3.14.1. (check-in: d986e123df user: drh tags: trunk)
2016-08-10
12:01
Fix typo in FTS3 docs. (check-in: 58a14bf9e1 user: drh tags: trunk)
2016-08-09
19:48
Update fts5.html to document negative column filters. (check-in: e79e555f14 user: dan tags: trunk)
17:38
Improvements to the PRAGMA secure_delete documentation. (check-in: ec87587f77 user: drh tags: trunk)
00:13
Properly escape "<" and ">" characters in the vtab.html document. (check-in: 03ec352945 user: drh tags: trunk)
2016-08-08
22:40
Increase the fontsize on the "pi". (check-in: 5933ebb467 user: drh tags: trunk)
18:52
Clarifications and typo fixes in the CSV extension documentation. (check-in: 4ca1c49050 user: drh tags: trunk)
13:48
Add the sha1 checksum and SQLITE_SOURCE_ID for 3.14 to changes.html. (check-in: 6c613c2c11 user: dan tags: trunk)
13:41
Final changes for the 3.14 release. (check-in: bc4407518b user: drh tags: trunk)
2016-08-04
14:08
Update the change log and add SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION to the compile-time options documentation. (check-in: 88de905c03 user: drh tags: trunk)
2016-08-02
12:52
Update the documentation generator to keep track of historical requirement numbers and use that database to print the text of stale requirement numbers. (check-in: ec99d82068 user: drh tags: trunk)
2016-07-28
19:26
Updates to the 3.14 change log. (check-in: 6bc4912659 user: drh tags: trunk)
17:45
Add linkage macros to the compile-time macro page. (check-in: b23ac4e38d user: drh tags: trunk)
16:04
Fix a typo in a snippet() example in the FTS3 documentation. (check-in: d2cba16a38 user: drh tags: trunk)
15:08
When generating C-language API docs, remove the various calling convention macros required for Windows builds (ex: SQLITE_API and SQLITE_CALLBACK) to avoid unnecessary confusion. (check-in: 09d99088da user: drh tags: trunk)
2016-07-25
13:23
Remove the mention of "Sparc" from the TH3 documentation. (check-in: e757c54921 user: drh tags: trunk)
2016-07-23
21:45
Tweaks to the JSON extension docs. (check-in: d0a0b0987f user: drh tags: trunk)
19:42
Add documentation for the json_quote() SQL function. Updates to the change log. (check-in: 3506feb7c7 user: drh tags: trunk)
14:58
Mention the sqlite3_expanded_sql() and sqlite3_trace_v2() interfaces in the change log. (check-in: eecfde6ba8 user: drh tags: trunk)
2016-07-22
15:42
Fix another typo in howtocorrupt.html (check-in: 2b9db23f51 user: drh tags: trunk)
15:23
Update docs for sqlite3_trace_v2(). (Leaf check-in: f5fc8bf5d8 user: drh tags: sqlite3_trace_v2)
2016-07-20
19:51
Fix typo in the how-to-corrupt document. (check-in: d23e6d047a user: mistachkin tags: trunk)
2016-07-15
02:59
Fix typo in the when-to-use document. (check-in: faf1f46a56 user: drh tags: trunk)
2016-07-13
14:17
Convert the RTree documentation to fancy-format. (check-in: cb9d13f931 user: drh tags: trunk)
13:57
Add documentation on the dbhash.exe utility and an entry in the change-log. (check-in: f80207b028 user: drh tags: trunk)
11:59
Add a link to vfsstat.c in the change log. (check-in: 234e53bfcb user: drh tags: trunk)
01:00
Fix formatting on the CVS virtual table documentation. (check-in: 60e2c7225d user: drh tags: trunk)
00:55
Improvements to the carray() function documentation. (check-in: 3f0e846a97 user: drh tags: trunk)
2016-07-12
23:52
Add the <fancy_format> markup which works like <table_of_contents> but omits the actual table of contents. Begin writing documentation for the carray() function. Fix typos and adjust wording in the CLI document. (check-in: e89a552dc3 user: drh tags: trunk)
20:54
Updates to reflect changes in 3.14.0. The "expr" syntax diagram is changed to show the ability to put table-valued functions on the RHS of an IN operator. Related text changes. Update the change log. (check-in: 24cd5438cc user: drh tags: trunk)
2016-07-09
20:28
Mention the win32-none VFS and the CACHE_USED_SHARED enhancements in the change log. (check-in: a5f2c520a7 user: drh tags: trunk)
2016-07-01
19:17
Changes to the display format for chronology of releases. (check-in: 8e47ab6c5e user: drh tags: trunk)
12:54
Further tweaks to the "Common Links" area of the homepage. (check-in: 6c1a5a2528 user: drh tags: trunk)
2016-06-30
14:08
Minor changes to the homepage. (check-in: 1f062a2353 user: drh tags: trunk)
2016-06-23
19:04
Added preliminary documentation for the new CSV virtual table. (check-in: b0191810a4 user: drh tags: trunk)
17:44
Improvements to the DBSTAT and sqlite3_analyzer.exe documentation pages. (check-in: 13de82bb23 user: drh tags: trunk)
16:59
Enhancements to the WITHOUT ROWID virtual table documentation. (check-in: ad981b591f user: drh tags: trunk)
2016-06-20
11:12
Additional clarification of the file format. (check-in: df46867c0f user: drh tags: trunk)
10:51
Enhance the file format document to make it clear that records might contain fewer values than there are columns in the table schema. (check-in: 149d28ec0e user: drh tags: trunk)
2016-06-04
17:25
Fix an error in fts5.html. (check-in: 627d913e58 user: dan tags: trunk)
2016-06-03
22:40
Documentation on WITHOUT ROWID virtual tables and the LIKE OR EQUAL optimization for virtual tables. (check-in: 01b8f2aa54 user: drh tags: trunk)
15:19
Convert the loadext.html page to the pretty-format. (check-in: 899d627a5a user: drh tags: trunk)
14:25
Added a change log for 3.14.0. Updates for SQLITE_OK_LOAD_PERMANENTLY. (check-in: 2c9d634cc9 user: drh tags: trunk)
14:21
Remove the disused btreemodule.html document. (check-in: 4650ddb4f7 user: drh tags: trunk)
2016-06-01
11:18
Fix typo in the description of the blessing. (check-in: 8ff18d7976 user: drh tags: trunk)
2016-05-26
17:57
Fix a typo on the wal.html page. (check-in: e97f045354 user: drh tags: trunk)
2016-05-23
18:10
Fix typo. (check-in: a88d4c2239 user: mistachkin tags: trunk)
2016-05-20
19:21
Add the AAR Android Library to the download page. (check-in: 79c52bfb78 user: drh tags: trunk)
2016-05-19
12:19
Add the Da Rocha book to the books.html page. (check-in: 5b4b8cea40 user: drh tags: trunk)
2016-05-18
11:04
Add SOURCE_ID and sha1sum for version 3.13.0. (check-in: ee711c5d19 user: dan tags: trunk, version-3.13.0)
10:55
Last update to News and Changes prior to release. (check-in: c71ec9449d user: drh tags: trunk)
2016-05-16
15:41
Clarify wording in cintro.html. (check-in: b9557433b1 user: drh tags: trunk)
2016-05-09
23:12
Use &gt; instead of > in documentation. (check-in: 4607eaf52f user: drh tags: trunk)
20:14
Fix a typo in the change log. (check-in: 5100e74a66 user: drh tags: trunk)
2016-05-06
20:39
Update the change log for the DELETE-WHERE-OR bug. (check-in: cfe4d98e00 user: drh tags: trunk)
2016-05-05
23:51
Fix a typo in the Error and Warning log page. (check-in: cf02ec8132 user: drh tags: trunk)
23:40
Add sub-bullets in the description of the b-tree page type flag in fileformat2.html, for improved legibility. (check-in: ff214d6ba0 user: drh tags: trunk)
13:33
Merge changes from the 3.12 branch. (check-in: d545903147 user: drh tags: trunk)
13:28
Clarify that using an database file with a link count different from 1 results in undefined behavior. (Leaf check-in: 7c96132d65 user: drh tags: branch-3.12)
2016-05-04
11:46
Fix typos in the change log. (check-in: 05caaf5dfb user: drh tags: trunk)
2016-05-03
17:20
Fix typo in the change log. (check-in: ee23402710 user: drh tags: trunk)
2016-05-02
12:42
Update the change log with the new DELETE optimization bug fix. (check-in: 5b0295da93 user: drh tags: trunk)
11:03
Updates to the change log for 3.13.0. (check-in: 53e8efc79e user: drh tags: trunk)
2016-04-26
19:37
Also add a table of contents to fileformat2.html. (check-in: e9007b6030 user: dan tags: trunk)
17:59
Add automatically generated tables of contents to rbu.html, cli.html and datatype3.html. (check-in: bd775e82aa user: dan tags: trunk)
15:37
Add documentation for RBU vacuum to rbu.in. (check-in: 2906c27967 user: dan tags: trunk)
2016-04-25
21:58
Clarify restrictions on the use of PRAGMA page_size. (check-in: 44656180a0 user: drh tags: branch-3.12)
2016-04-23
16:24
Add a new hyperlink on the cli.html page. (check-in: 03e1bee6c8 user: drh tags: trunk)
2016-04-22
12:14
Update the change log for the unix temporary directory search change. (check-in: 982ce9adde user: drh tags: trunk)
2016-04-21
13:37
Fix a typo in rbu.in: "us" -> "use". (check-in: b50372204c user: dan tags: trunk)
02:35
Merge the 3.12.2 changes from the 3.12 branch. Add a change log entry for SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION. (check-in: 6a5cbbb368 user: drh tags: trunk)
2016-04-18
18:37
Add hashes to the 3.12.2 change log. (check-in: 7e800725ac user: drh tags: branch-3.12)
18:05
Update the change log and news for the 3.12.2 patch release. (check-in: cf2965ab99 user: drh tags: branch-3.12)
2016-04-15
11:43
Fix typo in partial index documentation. (check-in: 544f9ccc33 user: drh tags: branch-3.12)
2016-04-08
20:15
Merge changes from the 3.12.0 branch. Improvements to change-log rendering. (check-in: 3d991d2d4e user: drh tags: trunk)
15:12
Changes for the 3.12.1 release. (check-in: 38b637c8ea user: drh tags: branch-3.12)
2016-04-04
17:45
Update the change log. (check-in: f7f4ae78cc user: drh tags: trunk)
12:24
Merge typo fixes from the 3.12.0 branch. (check-in: 8370e949b7 user: drh tags: trunk)
12:24
Typo fixes from Johannes Laire on unreleased documents. (check-in: e3943543c8 user: drh tags: trunk)
12:21
Typo fixes from Johannes Laire. (check-in: 16f159820b user: drh tags: branch-3.12)
2016-04-01
16:08
Create a place-holder for a tutorial on the session extension. (check-in: 24e5940ece user: drh tags: trunk)
14:57
Merge changes from the 3.12.0 branch. Add the "rowidtable.html" page. Add documentation for SQLITE_ENABLE_PREUPDATE_HOOK. (check-in: 74e8dbd8bf user: drh tags: trunk)
01:05
Add a change log entry for the query planner enhancement backport to 3.9.3. (check-in: cc1675f94a user: drh tags: branch-3.12)
2016-03-30
14:26
Start a change log for version 3.13.0 (check-in: 6633347c5b user: drh tags: trunk)
2016-03-29
22:30
On second thought, remove the information disclosure clean-up policy. (check-in: f343e93d94 user: drh tags: trunk)
22:27
Add the information disclosure clean-up policy document. (check-in: 454218b20d user: drh tags: trunk)
17:55
Version 3.12.0 (check-in: 8785825a81 user: drh tags: trunk, release, version-3.12.0)
17:54
Typo fix and a new anchor in the spellfix documentation. (check-in: ab675a0b08 user: drh tags: trunk)
17:30
Break out the SHA1 hashes into a separate subheading on the change log. (check-in: c5565753d6 user: drh tags: trunk)
10:44
Add the SQLITE_SOURCE_ID and sha1sum for version 3.12. (check-in: 36f9ae056f user: dan tags: trunk)
2016-03-28
15:03
Typo fixes. Add a news entry for 3.12.0. (check-in: 1bbb7d8697 user: drh tags: trunk)
2016-03-26
23:12
Update TH3 license information. (Leaf check-in: 84f9b8afc2 user: drh tags: branch-3.11)
22:53
Update TH3 license information. (check-in: 150f52f8da user: drh tags: trunk)
2016-03-25
13:00
Additional fragments in the cli.html page. (check-in: 84a1842726 user: drh tags: trunk)
2016-03-24
23:46
Fix typo. (check-in: b4cae844cd user: mistachkin tags: trunk)
2016-03-23
11:51
Update testing statistics. (check-in: ad4c9929f2 user: drh tags: trunk)
2016-03-22
17:23
Merge fixes off of the 3.11 branch. (check-in: ad0172e592 user: drh tags: trunk)
17:23
Fix typos. Add sqlite3_system_errno() to the change log. (check-in: d5d9bb664f user: drh tags: trunk)
2016-03-21
20:02
Fix the description of the case folding performed by the unicode61 tokenizer in FTS3. (check-in: 37a01760c6 user: drh tags: branch-3.11)
2016-03-19
19:33
Fix a minor formatting issue in FTS5 documentation. (check-in: c959b23a38 user: drh tags: trunk)
18:55
Update the change log for 3.12.0 (check-in: 7bb88a1e22 user: drh tags: trunk)
2016-03-18
15:46
Merge wal.html update from the 3.11.0 branch. (check-in: 147aa03544 user: drh tags: trunk)
14:56
Update the wal.html document at the bigwal anchor to reflect improvements to large transactions in WAL mode added to version 3.11.0. (check-in: e273b7fdae user: drh tags: branch-3.11)
2016-03-17
21:10
Fix the date (off by one) on the 3.9.2 release. (check-in: 08aa54dd95 user: drh tags: trunk)
2016-03-10
18:52
Add extra documentation for fts5 incremental optimize. (check-in: b4fa1baa79 user: dan tags: trunk)
2016-03-09
20:54
Update the fts5 documentation for the 'usermerge' option and 'merge' command. (check-in: 9ed173645f user: dan tags: trunk)
16:03
Another bullet on the 3.12.0 change log. (check-in: 1b4e717575 user: drh tags: trunk)
15:56
Updates to the change log for 3.12.0. (check-in: 92353888aa user: drh tags: trunk)
2016-03-08
17:23
Correct and clarify the computation of local and overflow payload sizes in the file format documentation. (check-in: 9ec8b470d5 user: drh tags: trunk)
16:42
Update documentation for SQLITE_DEFAULT_SYNCHRONOUS and related changes. (check-in: ab3cf23c74 user: drh tags: trunk)
13:15
Clarifications in "PRAGMA synchronous". (check-in: 73e31a3096 user: drh tags: trunk)
13:11
Add documentation for the SQLITE_STMTJRNL_SPILL compile-time option. (check-in: 0449652cda user: drh tags: trunk)
2016-03-04
15:33
Application note on the default page size change. Updates to the change log. (check-in: 954e5c9945 user: drh tags: trunk)
2016-03-03
16:20
Add hashes to the change log. (check-in: 2fdaab5ed5 user: drh tags: branch-3.11)
16:13
Fix typos and improve the wording of changes for 3.11.1. (check-in: 8423b61474 user: drh tags: branch-3.11)
16:07
Changes for the 3.11.1 release. (check-in: 628be086c5 user: drh tags: branch-3.11)
2016-03-02
13:16
Tweaks to the description of the sqlite_stat1 table in the fileformat2 document. (check-in: d4c54c7ebe user: drh tags: trunk)
2016-02-27
14:20
Include "OR ROLLBACK" among the examples of how to omit statement journals. (check-in: 237bf9365d user: drh tags: trunk)
2016-02-26
15:54
Updated documentation related to fts3_tokenizer() and the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER. (check-in: 1483127f32 user: drh tags: trunk)
2016-02-23
00:26
New entries in the change log. (check-in: 38697e2bb0 user: drh tags: trunk)
2016-02-22
14:58
Avoid creating a master journal unless two or more databases in the transaction can actually benefit from the master journal. (check-in: 3f48e98ec7 user: drh tags: trunk)
2016-02-17
16:14
Fix the PRAGMA synchorous documentation. The default is always FULL even in WAL mode. (check-in: 3540d671bc user: drh tags: trunk)
04:59
Typo fix. (check-in: ab0a116d70 user: drh tags: trunk)
2016-02-15
18:26
Separate heading for hashes in the 3.11.0 change log. (check-in: b04e9be1a4 user: drh tags: trunk)
17:32
Add the sha1sum and SQLITE_SOURCE_ID for version 3.11 to changes.html. (check-in: 850ce246dc user: dan tags: trunk)
15:45
Add a news item for the 3.11.0 release. Fix a typo in the FTS5 documentation. (check-in: 26245406d3 user: drh tags: trunk)
2016-02-12
17:29
Fix a typo in the cintro.html document. (check-in: 24a90038eb user: drh tags: trunk)
05:18
Merge changes from the 3.10 branch. (check-in: 09a0fd52d7 user: drh tags: trunk)
05:17
Change "Universal App Platform" to "Universal Windows Platform". (Leaf check-in: 4802ce4c0a user: drh tags: branch-3.10)
2016-02-10
19:16
Update the change log to comment on the NOT NULL and CHECK constraint optimization. (check-in: 83657094be user: drh tags: trunk)
13:51
Merge download page enhancements from the 3.10 branch. (check-in: dd43be4bec user: drh tags: trunk)
13:38
Add the snapshot tarball to the list of possible download files. (check-in: 6af983fad9 user: drh tags: branch-3.10)
03:48
Merge typo fixes from the 3.10 branch. (check-in: f26e661484 user: drh tags: trunk)
03:47
Fix typos in the fileformat2.html document. (check-in: 7ee2137b43 user: drh tags: branch-3.10)
2016-02-09
22:53
Updates to talk about the auto-explain changes to the shell. (check-in: 5a67b7f178 user: drh tags: trunk)
14:46
Merge enhancements from the 3.10.0 branch. (check-in: 35017ac57c user: drh tags: trunk)
14:43
Update the 3.11.0 change log. (check-in: 0dc9452382 user: drh tags: trunk)
2016-02-08
19:55
Update fts3 documentation to mention that fts3_tokenzer(x,y) is only available if SQLITE_ENABLE_FTS3_TOKENIZER is defined at compile time. (check-in: 27ee6d0233 user: dan tags: trunk)
2016-02-03
19:47
Update the documentation for PRAGMA synchronous=EXTRA. (check-in: bcf687da9c user: drh tags: trunk)
2016-02-02
03:15
Update the change log. (check-in: 430d0b230f user: drh tags: trunk)
02:05
Enhance the comment on the sqlite3_index_constraint.iColumn field to help bring attention to the fact that it can be negative for a rowid column. (check-in: be35c1ae8e user: drh tags: trunk)
01:56
Add a mention of sqlite3_column() to the SQLITE_RANGE documentation. (check-in: 2111e3600c user: drh tags: branch-3.10)
2016-01-26
15:04
Update the file format document to indicate that the number of rows in an index in sqlite_stat1 can be less than the number of table rows in the case of a partial index. (check-in: 42f14ae85f user: drh tags: trunk)
2016-01-25
13:55
Merge 3.10.2 changes. Add the SQLITE_EXTRA_DURABLE=1 compile-time option. (check-in: d39c6c7cfc user: drh tags: trunk)
2016-01-21
13:33
Do not suppress links to Windows DLLs on the download page. (check-in: 70ec942b27 user: drh tags: branch-3.10)
2016-01-20
15:46
Fix the sqlite3.c hash on the change log for 3.10.2. (check-in: 65da56b099 user: drh tags: branch-3.10)
15:35
Include the minor bug fixes in the 3.10.2 patch release. (check-in: 1f9040ed82 user: drh tags: branch-3.10)
14:50
Adjust the website for the 3.10.2 patch release. (check-in: 19c959312d user: drh tags: branch-3.10)
2016-01-19
17:10
Fix to the download.in script to not disable individual shell downloads if the tool bundle is missing. (check-in: 2dcd192c8b user: drh tags: branch-3.10)
17:07
Add documentation for sqlite3_analyzer.exe and support for the "tools" download bundles. (check-in: dd586d2857 user: drh tags: branch-3.10)
2016-01-15
08:33
Update fts5.html to node that the unicode61 tokenizer is compatible with the fts3 tokenizer of the same name. (check-in: 3cc1ff72a4 user: dan tags: trunk)
2016-01-14
18:26
Merge updates from the 3.10 branch. (check-in: 885e891911 user: drh tags: trunk)
17:58
Fix another typo in the query planner document. (check-in: 47810e77ef user: drh tags: branch-3.10)
16:10
Fix typos in queryplaner.html (check-in: 316be08907 user: drh tags: branch-3.10)
15:52
Remove the AWK dependency from the amalgamation page. (check-in: fbbbdbca17 user: drh tags: trunk)
15:48
Merge the 3.10.1 documentation changes. Update the change log for 3.11.0. (check-in: e9bf814a4d user: drh tags: trunk)
2016-01-13
21:46
Add the release hashes to the change log for 3.10.1. (check-in: 9c12cf4cea user: drh tags: branch-3.10)
20:52
Add documentation for the fts5 detail= option. (check-in: 08f6990b8a user: dan tags: trunk)
18:40
Update docs for the 3.10.1 release. (check-in: b01206d6af user: drh tags: branch-3.10)
2016-01-12
13:44
Merge changes from 3.10.0. (check-in: 7d40b68595 user: drh tags: trunk)
13:44
Fix typos in the TCL interface documentation. (check-in: 217ea4895f user: drh tags: branch-3.10)
2016-01-11
13:00
Begin entering 3.11.0 changes. (check-in: 166fc2da3a user: drh tags: trunk)
2016-01-06
16:09
Fix an error regarding operator precedence in fts5.html. (check-in: a44bb18833 user: dan tags: trunk)
12:23
Update download.in to look for products with version numbers starting with "31" instead of "30". (check-in: 55ba3b7506 user: dan tags: trunk)
11:05
Add the "News" for the 3.10.0 release and fix some typos. Add hashes and correct dates to the change log. (check-in: ecbe9a0cbc user: drh tags: trunk, release, version-3.10.0)
2016-01-04
00:44
Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option to the changes log. (check-in: df761d0907 user: drh tags: trunk)
2016-01-02
04:16
Cherrypick changes off of the bubble-generator-tkpath branch that were intended for trunk. Also merge in changes to the 3.9.x branch. (check-in: e2ad1111f4 user: drh tags: trunk)
04:14
Further tweaks to the website. (Leaf check-in: 5619b986d5 user: drh tags: bubble-generator-tkpath)
2015-12-31
14:06
Update the change log with the latest enhancements. (check-in: 5077172640 user: drh tags: bubble-generator-tkpath)
2015-12-30
15:10
Fix a problem in an SQL example in fts3.html. (check-in: 4648330f75 user: dan tags: trunk)
2015-12-28
16:20
Add links to the built-in SQL function documentation to the docs.html page. (Leaf check-in: 51cd2291e6 user: drh tags: branch-3.9)
2015-12-27
14:43
Fix a typo in the file format documentation. (check-in: 1cc43dde6c user: drh tags: branch-3.9)
2015-12-22
16:03
Modify the bubble-diagram generator script to use the TkPath extension. (check-in: 08bf2dfe78 user: chw tags: bubble-generator-tkpath)
15:02
Typo fix. (check-in: 9b6bab46ee user: drh tags: branch-3.9)
2015-12-11
15:50
Improved javascript for randomizing the order of sponsor icons. Remove the document.write() calls. (check-in: 4f106d99e8 user: drh tags: trunk)
2015-12-09
14:13
Updates to the famous users list. (check-in: bf79c7d26b user: drh tags: trunk)
11:51
Merge the revised sponsor icon layout into trunk. (check-in: 7251ac0674 user: drh tags: trunk)
11:50
Omit the blurbs from sponsor icons. (Closed-Leaf check-in: f42cb2d82f user: drh tags: new-sponsors-layout)
03:53
Further experiments with a new look for the sponsors on the homepage. (check-in: 66f30d5788 user: drh tags: new-sponsors-layout)
2015-12-08
22:28
Experiment with a new look for the homepage and especially the layout of sponsor links. (check-in: f96d1199e7 user: drh tags: new-sponsors-layout)
20:11
Add Facebook to the homepage. (check-in: e8ddd92958 user: drh tags: branch-3.9)
12:03
Fix typo in the amalagmation document. (check-in: a77392c96c user: drh tags: branch-3.9)
2015-12-03
22:34
Fix requirement mark errors in the cache_spill pragma docs. (check-in: ecd3254d36 user: drh tags: trunk)
22:05
Merge the AUTOINCREMENT typo fix from the 3.9 branch. (check-in: 3dec493cba user: drh tags: trunk)
22:03
Fix a typo in the AUTOINCREMENT documentation. (check-in: 7c05c71d58 user: drh tags: branch-3.9)
2015-12-02
20:59
Update the testing document to indicate that the unix VFS now has 100% branch test coverage. (check-in: c345c5933b user: drh tags: trunk)
2015-11-30
19:36
Add information about the sqlite3_index_info.colUsed field. (check-in: 43d4cb5785 user: drh tags: trunk)
2015-11-25
18:42
Update the documentation for the LIKE/GLOB/REGEXP enhancement to virtual tables. (check-in: 6b8138c898 user: drh tags: trunk)
2015-11-13
18:14
Update the PRAGMA cache_spill documentation to show the new functionality. (check-in: 65c5ce0f21 user: drh tags: trunk)
18:04
Begin adding changes to the change log for version 3.10.0. (check-in: 5591c0216e user: drh tags: trunk)
2015-11-11
20:52
Fix a typo in the virtual table documentation. (check-in: 04edad8b2f user: drh tags: trunk)
00:22
Clarification of the checkpoint algorithm in the file format document. (check-in: 4f85463d41 user: drh tags: trunk)
2015-11-09
21:21
Clarification of rules regarding SQLITE_OMIT_ compile-time options. Other minor documentation fixes. (check-in: ff45f132a6 user: drh tags: trunk)
2015-11-03
14:58
Fix closing tag mismatch in fileformat.html. (check-in: b4a002ba34 user: dan tags: trunk)
2015-11-02
18:42
Add a News entry for the 3.9.2 release. (check-in: 9a4e60ca03 user: drh tags: trunk)
18:42
Fix typo in matrix.tcl. (check-in: 08bd5f6079 user: dan tags: trunk)
18:36
Add the SQLITE_SOURCE_ID and sha1sum for 3.9.2. (check-in: 0c15d84626 user: dan tags: trunk)
14:10
Add a note to help clarify that automatic indexes and internal indexes used to implement PRIMARY KEY and UNIQUE constraints are unrelated. (check-in: 6910bdfa2a user: drh tags: trunk)
13:51
Add version 3.9.2 to the change log. (check-in: 938ebc6962 user: drh tags: trunk)
2015-11-01
18:01
Changes all references to the "tcl.tk" domain into "tcl-lang.org" as the maintainer of the "tk" top-level domain has been hacked and seems not to care. (check-in: 25a56d695c user: drh tags: trunk)
2015-10-30
01:14
Fix a typo in the formatchng.in document. (check-in: 13dc43c3a3 user: drh tags: trunk)
2015-10-29
18:16
Bring the formatchng.html document up-to-date. (check-in: afff09ce00 user: drh tags: trunk)
2015-10-27
19:18
Update documentation to note that fts5 contentless and external content tables do not support REPLACE. (check-in: 8885fffc21 user: dan tags: trunk)
17:23
Rework the website menu to add the Purchase link. (check-in: 8ba3eb4736 user: drh tags: trunk)
2015-10-19
12:30
Add documentation for the fts5vocab module to fts5.in. (check-in: 004403f6f5 user: dan tags: trunk)
2015-10-16
17:42
Add the sha1sum and SQLITE_SOURCE_ID values for version 3.9.1. (check-in: 6113b85fce user: dan tags: trunk)
17:34
Tweak to the "news" for version 3.9.1. (check-in: 5955ab6984 user: drh tags: trunk)
17:28
Add news about 3.9.1 (check-in: c5a13cc8f4 user: drh tags: trunk)
16:59
Preliminary changes for the 3.9.1 patch release. (check-in: e2554ac473 user: drh tags: trunk)
11:35
Fix a typo. "databse" to "database". (check-in: eb3ea9a953 user: drh tags: trunk)
2015-10-15
01:25
Add a fragment for the ".dump" command in the cli.html documentation. (check-in: 2530eac4fe user: drh tags: trunk)
2015-10-14
12:45
Add sha1sum and SQLITE_SOURCE_ID values for 3.9.0 to changes.in. (check-in: 0b8a218c16 user: dan tags: trunk)
12:27
Change the date of release for 3.9.0. (check-in: afadc19de4 user: drh tags: trunk)
2015-10-13
16:08
Update fts5.in to note that FTS5 is now included in the amalgamation. And that it supports the table-valued function syntax. (check-in: d6de4c860f user: dan tags: trunk)
2015-10-12
18:25
Update test statistics. (check-in: be7c2233a2 user: drh tags: trunk)
18:04
Fix typos. (check-in: 63898e2980 user: drh tags: trunk)
17:05
Adjust dates in the change log to exactly correspond to the version control check-in dates. (check-in: cc89254370 user: drh tags: trunk)
12:24
More succinct intro text on the chronology page. (check-in: 6cb597fbc9 user: drh tags: trunk)
12:22
Update the news.html page and mostdeployed.html page for the 3.9.0 release. Add the chronology.html page. (check-in: 05dd1c74b8 user: drh tags: trunk)
05:51
More documentation updates for 3.9.0. (check-in: 1c92bfea70 user: drh tags: trunk)
04:46
Fix typos in new documents. (check-in: 110e2bb5b0 user: drh tags: trunk)
2015-10-10
09:36
Add a new example for external-content tables to fts3.html. (check-in: e68ac068e8 user: dan tags: trunk)
2015-10-09
15:46
Add a report of the SEE corruption bug to the 3.9.0 release notes. (check-in: 8b38705a3d user: drh tags: trunk)
15:01
Keep FTS5 experimental for at least one more release cycle. (check-in: 7ef90a2dde user: drh tags: trunk)
14:45
Further updates in support of 3.9.0. Mark FTS5 has being officially released. (check-in: d9e14a871b user: drh tags: trunk)
14:00
Update the documentation for the version numbering change. (check-in: 4fc9d7ce50 user: drh tags: trunk)
12:10
Fix one more typo in fts5.in. (check-in: 1bbbec6248 user: dan tags: trunk)
12:09
Fix typos in fts5.in. (check-in: cc68da99a4 user: dan tags: trunk)
2015-10-08
13:29
Proposed new version numbering scheme. (Closed-Leaf check-in: 82a2560a88 user: drh tags: new-version-numbering)
00:21
Minor English grammar changes. (check-in: 543413f753 user: drh tags: trunk)
2015-10-07
22:42
Fix a couple typos in the new docs. (check-in: 255ed0fac7 user: mistachkin tags: trunk)
19:40
Link the optoverview.html document to the new expridx.html document. (check-in: 47d33de042 user: drh tags: trunk)
19:35
Add a new documentation page that talks specifically about indexes on expressions. (check-in: 8b6ed636e3 user: drh tags: trunk)
18:25
Mention enhancements to dbstat in the change log. (check-in: e738239518 user: drh tags: trunk)
16:44
Update fts5 documentation to allow the subsitute character (codepoint 26) in unquoted query terms. (check-in: 0b83b3cde9 user: dan tags: trunk)
15:30
Add a fragment for "howtocompile" in the JSON1 documentation. (check-in: de0fb99b82 user: drh tags: trunk)
2015-10-03
12:21
Update rtree documentation to describe the way attempts to insert non-integer primary key values or non-numeric dimensions into an rtree table are handled. (check-in: 56eab0136c user: dan tags: trunk)
2015-09-23
00:55
Mention the valgrindfuzz make target in the discussion of AFL. (check-in: 1d0a599d9e user: drh tags: trunk)
2015-09-19
18:23
Remove the claim that AFL runs continuously. (check-in: 82b0b65c87 user: drh tags: trunk)
2015-09-15
12:38
Merge the Expensify logo from the previous release branch. (check-in: 9da68a0646 user: drh tags: trunk)
12:37
Fix a typo in the JSON documentation. (check-in: 833012c6a9 user: drh tags: trunk)
12:36
Add the Expensify logo to the front page. (Leaf check-in: 37e5ed4e85 user: drh tags: branch-3.8.11)
2015-09-11
22:51
Add links from the requirements.html page into the matrix. Clarifications to the CREATE INDEX and REINDEX documentation. (check-in: c1c7b5e3d1 user: drh tags: trunk)
20:19
Update the requirements.html document to provide links into the matrix for each requirement. (check-in: a6da4c726a user: drh tags: trunk)
17:17
Improvements and fixes to the eponymous virtual table documentation. (check-in: a8cbed7cc9 user: drh tags: trunk)
16:14
Minor updates to json1 and table-valued function documentation. (check-in: af1be7762c user: drh tags: trunk)
15:36
Still more typo corrections and clarification for the json1 documentation. (check-in: 854fe12156 user: drh tags: trunk)
15:23
Fix typos, improve wording, and add more examples to the json1 documentation. (check-in: 51f0e6c448 user: drh tags: trunk)
01:22
Update the json1 documentation to reflect the recent changes that make use of subtype to avoid the '$$' goofiness, and the addition of the json() function. (check-in: ad30053732 user: drh tags: trunk)
2015-09-10
19:27
Fix another typo in the json1 documentation. (check-in: 02e2ca3d77 user: drh tags: trunk)
18:51
Fix another typo in the json1 documentation. (check-in: 0fcd73bb5a user: drh tags: trunk)
18:21
Add a how-to-compile section to the json1 documentation. And fix many typos. (check-in: aafe027cf0 user: drh tags: trunk)
17:21
Update the json1 documentation to describe the new "path" column of json_tree(). (check-in: 5cc19499aa user: drh tags: trunk)
03:43
Improvements and clarification for the json1 documentation. (check-in: 4793854de9 user: drh tags: trunk)
2015-09-09
20:26
Typo fixes in the examples of the json1 document. (check-in: e5c50d4f24 user: drh tags: trunk)
19:01
Add examples to the json1 documentation. (check-in: bc16b0015f user: drh tags: trunk)
15:39
Enhance wrap.tcl to recognize <yyterm> elements in the input HTML and convert them into real HTML that renders an terminal-symbol oval around the enclosed text. Use this markup when talking about terminal symbols in the language specification. (check-in: 8e1d4f3bb5 user: drh tags: trunk)
02:06
Fix a typo in the json1 documentation. (check-in: 57b4eafa71 user: drh tags: trunk)
02:04
First draft of json1 documentation. (check-in: ea6f64590b user: drh tags: trunk)
2015-09-08
21:33
Improved documentation for table-valued functions and eponymous virtual tables. (check-in: 9b1f04e2d1 user: drh tags: trunk)
18:41
Updates to the change log for 3.8.12. Add documentation for eponymous virtual tables, for table-valued functions, and other new capabilities. (check-in: 456508e2ed user: drh tags: trunk)
16:25
Update language documentation to begin describing new features: (1) indexes on expressions (2) table-valued functions (3) column names on VIEWs. (check-in: d9a422f858 user: drh tags: trunk)
15:16
Update the syntax diagrams for new syntax: (1) table-valued functions (2) column names on CREATE VIEW statements (3) Indexes on expressions (check-in: 866fda3b5a user: drh tags: trunk)
2015-09-07
10:53
Fix two typos. (check-in: 0506240273 user: drh tags: trunk)
2015-09-02
11:30
Add missing parenthesis to an expression in fts3.html. (check-in: d366268bab user: dan tags: trunk)
2015-08-28
18:13
Improved explanation of how to build the command-line shell on the howtocompile.html page. (check-in: 501ee3f88e user: drh tags: trunk)
2015-08-23
20:46
Fix typos on the "opcodes.html" page. (check-in: bce35e487e user: drh tags: trunk)
2015-08-21
14:22
Add NDSeV to the front page as an acknowledged SQLite Consortium member. (check-in: ccecfa130e user: drh tags: trunk)
2015-08-20
08:58
Fix an error in the previous commit. (check-in: 3c56514778 user: dan tags: trunk)
05:47
Fix an error in an example in the FTS5 documentation. (check-in: 2ff6a32555 user: dan tags: trunk)
2015-08-19
13:55
Fix the argvIndex description in the virtual table documentation. (check-in: 26089f7cd9 user: drh tags: trunk)
2015-08-12
04:23
Additional information about WITHOUT ROWID tables. (check-in: 3710449fcd user: drh tags: trunk)
2015-08-11
16:38
Refinements to the undo/redo technical note. (check-in: 1bf74f2849 user: drh tags: trunk)
15:47
Enhancements to the arguments in favor of using SQLite as an application file format. Added the undoredo.html document. (check-in: 1e1b1d8101 user: drh tags: trunk)
2015-08-01
18:13
Update rbu.in with more details on using RBU with FTS tables and the sqldiff tool. (check-in: 95c97dad08 user: dan tags: trunk)
2015-07-31
18:32
Fix the link to the first mailing list archive. (check-in: 319676d3b8 user: drh tags: trunk)
2015-07-30
00:24
Add the UAP download to the download page. (check-in: 0a7863de9d user: drh tags: trunk)
2015-07-29
20:57
Version 3.8.11.1 (check-in: eb43eaf374 user: drh tags: trunk, release, version-3.8.11.1)
20:04
Add sha1sum and SQLITE_SOURCE_ID values for 3.8.11.1. (check-in: 9103f1af0d user: dan tags: trunk)
17:03
Update the change log, homepage, and news for version 3.8.11.1. (check-in: 213cc1119f user: drh tags: trunk)
2015-07-27
19:57
Fix typos in documentation found by requirements coverage testing. (check-in: d7cc0cb1e0 user: drh tags: trunk)
16:51
Version 3.8.11 (check-in: cae2f34af4 user: drh tags: trunk, release, version-3.8.11)
14:54
Add the sha1sum and SQLITE_SOURCE_ID for version 3.8.11. (check-in: 77de487a96 user: dan tags: trunk)
10:52
Add news for the 3.8.11 release. Tweaks to the testing document and to the change log. (check-in: 0b7f40e93e user: drh tags: trunk)
2015-07-24
20:37
Update the change log for the zeroblob64() interfaces. (check-in: ea601769ef user: drh tags: trunk)
2015-07-23
22:05
Improvements to the change log. (check-in: 12a7bb44f4 user: drh tags: trunk)
20:50
More OTA to RBU changes that were missed by the previous check-in. (check-in: 97e489408d user: drh tags: trunk)
20:49
Change the name of OTA to RBU. (check-in: 326066ebea user: drh tags: trunk)
2015-07-16
03:22
Add Sibsankar's second book to the books.html page. (check-in: cf7fe0f52c user: drh tags: trunk)
00:01
Fix typos. (check-in: 79a7fb1e3f user: drh tags: trunk)
2015-07-14
20:48
Clarify and correct details of the OTA documentation. Make it clear that the FTS5 extension is still experimental and subject to file format changes. (check-in: 709d5967ce user: drh tags: trunk)
15:59
Call FTS5 and OTA "experimental" on the change log, as they might yet receive incompatible changes. (check-in: 7b63ab1de7 user: drh tags: trunk)
13:46
Fix a minor syntax error in the tclsqlite document. (check-in: 0462837fe7 user: drh tags: trunk)
2015-07-13
22:07
First cut at OTA documentation. (check-in: a5dfd4a26b user: drh tags: trunk)
2015-07-10
17:04
Add an "application porting guide" describing the steps required to port fts3/4 applciations to fts5. Fix some other deficiencies in fts5.html. (check-in: f650ee44b0 user: dan tags: trunk)
2015-07-02
20:03
Add "Compiling and Using FTS5" section to fts5.html. (check-in: 59ff0eaf28 user: dan tags: trunk)
19:01
Update the change log. (check-in: eb5c390d52 user: drh tags: trunk)
17:59
Fix a missing comma in fts5.in. (check-in: b7f67421b7 user: dan tags: trunk)
2015-07-01
17:34
Fix a typo in the zero-malloc memory allocator documentation. (Leaf check-in: a3a3160989 user: drh tags: branch-3.8.10)
17:34
Fix a typo in the zero-malloc memory allocator documentation. (check-in: fb40525c2c user: drh tags: trunk)
2015-06-26
19:17
Make search.tcl more robust in the face of malformed MATCH queries. (check-in: f2337fb9a2 user: drh tags: branch-3.8.10)
19:15
Make search.tcl more robust in the face of malformed MATCH queries. (check-in: 04c0c2b5f2 user: dan tags: trunk)
18:47
Fix the opcode documentation generator so that it can handle digits at the end of opcode names. (check-in: 7a0fc411fe user: drh tags: trunk)
2015-06-20
14:29
Update description of AFL testing. (check-in: 73745849d3 user: drh tags: trunk)
2015-06-19
18:57
Fix an error in fts5.in. (check-in: 8f8e1e988f user: dan tags: trunk)
2015-06-17
16:05
Further tweaks to the matchinfo() documentation. (check-in: d0b390051e user: drh tags: trunk)
15:59
Update the change log. Better fragments for matchinfo() flags. (check-in: dcccfa67e1 user: drh tags: trunk)
2015-06-10
16:28
Update the "Differences from FTS3/4" section of fts5.html. (check-in: 22655b73bd user: dan tags: trunk)
13:01
Add documentation for the columnsize=0 option to fts5.html. (check-in: e30da64703 user: dan tags: trunk)
2015-06-02
19:27
Add syntax for multi-column matches to fts5.in. (check-in: ec116c4004 user: dan tags: trunk)
17:24
Clarify the comparison affinity documentation. Change the name of NONE affinity to BLOB. Update the Makefile so that it works with Ubuntu 14.04LTS. (check-in: 9ba9e670e1 user: drh tags: trunk)
2015-05-30
20:54
Fix a typo in the SQLITE_BUSY_SNAPSHOT documentation. (check-in: d025188e91 user: drh tags: branch-3.8.10)
20:51
Fix a typo in the SQLITE_BUSY_SNAPSHOT documentation. (check-in: fe158a6ae2 user: drh tags: trunk)
2015-05-29
19:05
Add an entry on the cell_size_check pragma. Updates to the change log. (check-in: 0bf50a0382 user: drh tags: trunk)
2015-05-26
12:26
Cherrypick several recent minor changes from trunk. (check-in: 0f4cfe6cd0 user: drh tags: branch-3.8.10)
2015-05-25
09:22
Fix typo in the "deprecated" footnote on the pragma list. (check-in: 7555c435cc user: drh tags: trunk)
2015-05-23
17:48
Enhance the file-format document to show the page type header numbers on various charts, for ease of reference. (check-in: 88dc8a8a7b user: drh tags: trunk)
02:44
Start the change log for 3.8.11. (check-in: b189725f2c user: drh tags: trunk)
2015-05-20
18:24
Add the sha1sum and SQLITE_SOURCE_ID for version 3.8.10.2. (check-in: f4e75764dd user: dan tags: branch-3.8.10)
18:20
Update the list of reserved characters in fts5.html. (check-in: d2210cd43b user: dan tags: trunk)
10:51
Update change log and news for the 3.8.10.2 patch release. (check-in: 3db83e693e user: drh tags: branch-3.8.10)
2015-05-19
14:05
Fix a typo on the testing.html page. (check-in: db6bfdf9aa user: drh tags: branch-3.8.10)
2015-05-15
15:56
Improvements to the testing.html document. (check-in: 0b4aaced39 user: drh tags: branch-3.8.10)
14:53
Link from the ATTACH documentation page to the DETACH page. Increased information about TH3. These are cherry-picks from trunk. (check-in: 643e08dfb8 user: drh tags: branch-3.8.10)
14:51
Link from the ATTACH documentation page to the DETACH page. (check-in: b3cbd71993 user: drh tags: trunk)
14:48
Increased information about TH3. (check-in: 7d4f8c9ada user: drh tags: trunk)
2015-05-11
19:12
Update fts3.html with a description of the matchinfo 'b' option. (check-in: 2dad241898 user: dan tags: trunk)
17:09
Updates to the dbstat documentation to explain how it can be used to get information about attached databases other than "main". (check-in: d33510f222 user: drh tags: trunk)
16:03
Fix a typo on the mostdeployed.html page. (check-in: 7da9280ceb user: drh tags: trunk)
2015-05-09
16:52
Include the 3.8.10 changes in the 3.8.10.1 change log. (check-in: 9262be9e83 user: drh tags: trunk)
12:19
Add the SQLITE_SOURCE_ID and sha1sum for version 3.8.10.1. (check-in: 6995552ff4 user: dan tags: trunk)
10:41
Ready for the 3.8.10.1 patch release. (check-in: 1aa5bd4021 user: drh tags: trunk)
2015-05-07
16:35
Tweaks to the list of places where SQLite is found on the mostdeployed.html page. (check-in: 7fce1378e8 user: drh tags: trunk)
16:17
Add Bosch to the Famous Users page. (check-in: 4a9969e6cd user: drh tags: trunk)
14:56
Add the SQLITE_SOURCE_ID and sha1sum for version 3.8.10. (check-in: d98c48adfd user: dan tags: trunk)
11:51
Move the 3.8.10 release forward by one day. (check-in: a7fadcc750 user: drh tags: trunk)
11:46
Update test statistics. (check-in: 3aebfb2618 user: drh tags: trunk)
11:32
Fix typos. (check-in: 73e4989d49 user: drh tags: trunk)
2015-05-06
17:25
Add news and adjust the date for the 3.8.10 release. (check-in: 854c6fc854 user: drh tags: trunk)
2015-05-05
19:59
Fix a typo in the documentation for fts3 matchinfo option 'y'. (check-in: 9dff844fd9 user: dan tags: trunk)
01:48
Add the new dot-commands to the CLI document. (check-in: 39d0f62c46 user: drh tags: trunk)
2015-05-04
21:13
Add documentation on the dbstat virtual table. (check-in: 2ea5a64156 user: drh tags: trunk)
13:26
Add support for the --lib option on sqldiff.exe. (check-in: 2924043d8c user: drh tags: trunk)
12:16
Add the matchinfo(..,'y') option addition to the change log. (check-in: 0cd02758ec user: drh tags: trunk)
12:03
Minor tweaks to documentation hyperlinks. (check-in: eefff25d55 user: drh tags: trunk)
11:38
Add a brief document on the sqldiff.exe utility. Rewrite the mostdeployed.html document. (check-in: ec5b570727 user: drh tags: trunk)
2015-05-02
09:40
Update fts3 documentation with docs for the matchinfo 'y' flag. (check-in: e6b9763fab user: dan tags: trunk)
2015-05-01
19:49
Fix an error in the fts5 documentation for the NEAR operator. (check-in: 807c985334 user: dan tags: trunk)
11:27
Update the microsoft entry on the famous-users page. (check-in: 5addc70516 user: drh tags: trunk)
2015-04-30
13:26
Clarifications to howtocompile.html and testing.html. (check-in: 81a7294781 user: drh tags: trunk)
2015-04-27
16:42
Update the description of the content= option in fts5.html. (check-in: 47550c82de user: dan tags: trunk)
2015-04-25
18:17
Add discussion of the AFL fuzzer to the testing document. (check-in: 34e2a86993 user: drh tags: trunk)
2015-04-24
20:09
Update fts5.in with the UNINDEXED option. (check-in: 0742089777 user: dan tags: trunk)
2015-04-23
16:50
Start a change log for the 3.8.10 release. (check-in: 7013e919d2 user: drh tags: trunk)
16:40
Merge changes from 3.8.9. (check-in: a0579664f6 user: drh tags: trunk)
2015-04-21
17:50
Add the UAP VSIX to the prerelease snapshots section of the download page. (Leaf check-in: fe9930b07e user: drh tags: branch-3.8.9)
2015-04-14
15:14
Update the API decoder to identify and cross-reference methods on objects. (check-in: e9c7eaba3b user: drh tags: trunk)
13:24
Improvements to the cintro.html document. (check-in: 4dfdc948ef user: drh tags: trunk)
2015-04-13
10:21
Fix a typo on the quickstart page. (check-in: 80577829a2 user: drh tags: trunk)
2015-04-10
14:39
Add a brief comment describing what the toc.db build logic is used for and why it is important. (check-in: c7671e4258 user: drh tags: trunk)
14:08
Generate the "toc.db" database containing all interfaces with links to their documentation. (check-in: 5f5f7776fc user: drh tags: trunk)
2015-04-08
14:12
Add the checksum and source-ids for version 3.8.9 to the changelog. Update the release date to the 8th. (check-in: bed24cae9a user: dan tags: trunk)
2015-04-07
01:45
Add a news entry and set the dates for the 3.8.9 release. (check-in: 4f5e3f3f7d user: drh tags: trunk)
2015-04-02
17:10
Fix typo in the shared cache documentation. (check-in: 078a97faa5 user: drh tags: trunk)
2015-03-31
14:31
Clarify the wording of the SQLITE_SECURE_DELETE documentation. (check-in: ce7c9f89a7 user: drh tags: trunk)
2015-03-27
10:58
Improved wording of a statement in the CREATE VIEW documentation. (check-in: 629e137c8d user: drh tags: trunk)
2015-03-24
21:36
Omit the SQLITE_STDCALL and SQLITE_CDECL macros from the API documentation. (check-in: c0f3adb87d user: drh tags: trunk)
2015-03-23
20:07
Add sqlite3_status64() to the change log. (check-in: 0f26ee931b user: drh tags: trunk)
13:25
Merge in fixes from the 3.8.8 branch. (check-in: a17575cedc user: drh tags: trunk)
13:24
Escape less-than characters in code examples. (check-in: b6106e65ef user: drh tags: trunk)
2015-03-16
22:22
Fix typos in the FAQ. (Leaf check-in: 973dd7c44b user: drh tags: branch-3.8.8)
20:37
Fix a typo in the queryplanner.html document. (check-in: 94ffc3e5cb user: drh tags: branch-3.8.8)
18:07
Fix a typo in the isolation.html document. (check-in: 0b012929c4 user: drh tags: branch-3.8.8)
2015-03-13
12:42
Document the -argcount and -deterministic options to the "function" method of the TCL interface. (check-in: 6307058276 user: drh tags: trunk)
2015-03-09
19:43
Merge the tempfiles.html type fix from the 3.8.8 branch. (check-in: 685ed5c5f4 user: drh tags: trunk)
19:43
Update the change log to mention VxWorks support. (check-in: ba1c4ee6c3 user: drh tags: trunk)
19:42
Fix a typo in the tempfiles.html page. (check-in: 3f2102936f user: drh tags: branch-3.8.8)
2015-03-07
11:16
Improve the documentation of fts5 auxiliary functions. (check-in: a358d9babf user: dan tags: trunk)
2015-03-06
19:29
Further enhancements to fts5.in. (check-in: 984c3483df user: dan tags: trunk)
2015-03-05
21:00
Add a couple of details to fts5.in. (check-in: 23989471bd user: dan tags: trunk)
15:35
Fix the documentation of PRAGMA index_info to omit the three extra files that were reverted. Improve the documentation of PRAGMA index_list to detail the output fields. (check-in: 8b3cf7e669 user: drh tags: trunk)
01:22
Fix a bug in matrix generation. Relax a restriction on the use of VALUES clauses - a restriction that did not actually apply. Fix a formatting problem in the FTS5 docs. (check-in: f61b2a7935 user: drh tags: trunk)
00:17
Only count duplicate requirements once when scoring, but show every usage in the matrix reports. (check-in: 61f2878145 user: drh tags: trunk)
2015-03-04
23:15
Clarifications on INDEXED BY documentation. Syntax diagrams which are default visible are always requirements even if they occur multiple times, but syntax diagrams that are default hidden now have the "data-noreq" attribute which prevents them from being marked as requirements. (check-in: 000660158c user: drh tags: trunk)
20:56
Clarification of the "INSERT OR" and "REPLACE" forms of the INSERT statement. (check-in: 58895ad201 user: drh tags: trunk)
20:49
Update the "features.html" page to the version found on trunk. (check-in: 2f5fb6f4d1 user: drh tags: branch-3.8.8)
20:19
Add fts5.html. (check-in: 519916c18a user: dan tags: trunk)
16:59
Merge typo fix from the 3.8.8 branch. (check-in: 9621e94943 user: drh tags: trunk)
16:57
Fix a typo in the new executive summary of the c-language intro. (check-in: 69e5764941 user: drh tags: branch-3.8.8)
16:53
Improvements to API documentation cherry-picked from trunk. (check-in: 246736cd96 user: drh tags: branch-3.8.8)
16:44
Improvements to API documentation. List VxWorks in the supported platforms on the features page. (check-in: c9cc354d83 user: drh tags: trunk)
15:00
Add an Executive Summary to the top of the cintro.html document. (check-in: 14d94072cd user: drh tags: trunk)
2015-03-03
18:12
Update so the alter table procedures. (Cherrypick from trunk.) (check-in: 7b774680e1 user: drh tags: branch-3.8.8)
18:11
Update so the alter table procedures. (check-in: 615b0d3f7e user: drh tags: trunk)
18:03
Merge changes from the 3.8.8 branch. (check-in: 7024b8da5d user: drh tags: trunk)
16:57
Another typo fix in the SQLITE_ALLOW_URI_AUTHORITY documentation. (check-in: fee2c72de1 user: drh tags: branch-3.8.8)
14:05
Fix a typo in the documentation for SQLITE_ALLOW_URI_AUTHORITY. And remove SQLITE_INTERRUPT as a condition for which a manual ROLLBACK is recommended. Cherrypicks from trunk. (check-in: 6da416cd71 user: drh tags: branch-3.8.8)
14:01
Fix a typo in the documentation for SQLITE_ALLOW_URI_AUTHORITY. (check-in: 8c231d16ef user: drh tags: trunk)
2015-03-02
15:31
Remove SQLITE_INTERRUPT as a condition for which a manual ROLLBACK is recommended, as an automatic ROLLBACK always occurs following an interrupt. (check-in: 79f6b17595 user: drh tags: trunk)
2015-02-27
21:52
Remove mention of the SQLITE_DEFAULT_TEMP_CACHE_SIZE compile-time option, which is no longer used and has not been used for a while. Mention that the default cache_size for TEMP databases is 0. (check-in: b23ccdfcdf user: drh tags: trunk)
20:24
The "PRAGMA temp.cache_size" statement does not currently work. So omit it from the documentation. (check-in: 54c55f5bd5 user: drh tags: trunk)
20:09
Resurrect a couple of requirements on PRAGMA journal_mode that were mistakenly dropped by one of the previous few check-ins. (check-in: a9966eadef user: drh tags: trunk)
19:02
More corrections to the PRAGMA documentation. (check-in: 08b7956b61 user: drh tags: trunk)
15:45
In the PRAGMA documentation, show the "database." prefix on all and only those pragmas for which it might make a difference. (check-in: 4a77b7e608 user: drh tags: trunk)
02:37
Clarifications and typo fixes to several web pages. (check-in: 00d095bbd5 user: drh tags: trunk)
2015-02-26
20:11
Improvements to the wording of documentation for index_info and index_xinfo pragmas. (check-in: 4fca6ea06a user: drh tags: trunk)
17:29
Add documentation for the "PRAGMA index_xinfo" command. (check-in: fb31730b59 user: drh tags: trunk)
16:50
Fix a faulty requirement mark in the WAL documentation and a typo in the AUTOINCREMENT page. (check-in: 7d8c30e639 user: drh tags: trunk)
2015-02-25
15:40
More typo fixes and simplification of the whentouse.html document. (check-in: 4cf46a5799 user: drh tags: branch-3.8.8)
15:21
Merge the 3.8.8.3 changes into trunk. (check-in: 6139a797c7 user: drh tags: trunk)
15:12
Fix typos on the whentouse.html page. (check-in: a302c3195d user: drh tags: branch-3.8.8)
13:31
Version 3.8.8.3 (check-in: e5840a16ce user: drh tags: release, branch-3.8.8, version-3.8.8.3)
2015-02-21
15:46
Merge whentouse.html enhancements from the 3.8.8 branch. (check-in: 3b4b8c681a user: drh tags: trunk)
14:23
Further improvements to the "whentouse.html" document based on community feedback. (check-in: fb810e2184 user: drh tags: branch-3.8.8)
2015-02-18
14:10
Still more tweaks to whentouse.html (check-in: 926ff6c0a2 user: drh tags: branch-3.8.8)
13:48
Still more refinement of the whentouse.html page. Split off some of the details of the "Application File Format" bullet into a separate file. Move "Internet of Things" to the first bullet because that is currently trendy. (check-in: 65d06a3e42 user: drh tags: branch-3.8.8)
03:01
Remove a stray ">" character from the whentouse.html document. (check-in: 1f8dc8b380 user: drh tags: branch-3.8.8)
02:44
More refinements to the whentouse.html document. (check-in: bac63b794b user: drh tags: branch-3.8.8)
2015-02-17
19:43
Fix typos in the whentouse.html document. (check-in: 26c13d0a75 user: drh tags: trunk)
19:38
Fix typos in the whentouse.html document. (check-in: f20a01f111 user: drh tags: branch-3.8.8)
19:35
Typo fix in the whentouse.html document. (check-in: 2783c0c3be user: drh tags: branch-3.8.8)
19:09
Pull in the whentouse.html updates without waiting for the next release. (check-in: 1dfc552b2a user: drh tags: branch-3.8.8)
19:04
Initialize the 3.8.9 change log. Add a linke to the when-to-use document on the front page. Updates and enhancements to the when-to-use document. (check-in: 970b51ea32 user: drh tags: trunk)
17:21
Enhancements to the whentouse.html document. (check-in: ddb8a3924e user: drh tags: trunk)
2015-02-11
17:28
Add a note to the date-time function documentation to say that the "s" at the end of modifiers like "days" is optional. (check-in: b800b2aa94 user: drh tags: trunk)
2015-02-03
06:14
Fix a typo in the index_info pragma documentation. (check-in: 49266aeb5b user: drh tags: trunk)
2015-01-31
15:03
In althttpd.c: Supply a Content-length header in the reply if the CGI does not provide one itself. (check-in: 9363196b1f user: drh tags: trunk)
2015-01-30
14:34
Changes for the 3.8.8.2 patch release. (check-in: 12ee06f549 user: drh tags: trunk)
2015-01-23
12:44
Further updates to the large-WAL avoidance advice. (check-in: 99079b3364 user: drh tags: trunk)
2015-01-22
17:48
Fix typos and simplify wording in the previous commit. (check-in: 9305fd78a4 user: drh tags: trunk)
17:32
Add a section to the WAL-mode documentation talking about how to avoid over-sized WAL files. (check-in: de568658d9 user: drh tags: trunk)
2015-01-20
17:58
Version 3.8.8.1 (check-in: f8d886372c user: drh tags: trunk, release, version-3.8.8.1)
17:18
Add the SOURCE_ID and sha1sum for 3.8.8.1. (check-in: f5699b6c64 user: dan tags: trunk)
16:58
Add a change log and news and other changes for the 3.8.8.1 patch release. (check-in: e024f74b99 user: drh tags: trunk)
2015-01-17
18:56
Remove Oracle from the list of active Consortium members. (check-in: ea64cbaecb user: drh tags: trunk)
17:25
Simplify the text descriptions of download products. Enhance the "amalgamation" page to talk about the split amalgamation and describe how to build the amalgamation. Add the "getthecode.html" page with descriptions on how to clone the SQLite repositories. (check-in: c2c04806c8 user: drh tags: trunk)
2015-01-16
18:33
Version 3.8.8 (check-in: acba88bd91 user: drh tags: trunk, release, version-3.8.8)
13:34
Update the changelog with the sha1sum and SQLITE_SOURCE_ID for version 3.8.8. (check-in: a5a1438553 user: dan tags: trunk)
12:04
Add news for the 3.8.8 release. Fix two typos. (check-in: ee68a396c3 user: drh tags: trunk)
2015-01-14
20:18
Add two new elements to the change log for 3.8.8. (check-in: 4feb5c4fcb user: drh tags: trunk)
2015-01-12
12:38
Merge typo fix from the 3.8.7 branch. (check-in: 8705a95364 user: drh tags: trunk)
12:37
Fix typos in the whentouse.html document. (Leaf check-in: 6ee4cecc7e user: drh tags: branch-3.8.7)
2015-01-10
19:17
Update the change log. Add descriptions of the HAVE_* compile-time options to the copmile.html page. (check-in: 5f01e4dd6c user: drh tags: trunk)
2015-01-09
17:13
Anticipated release date for 3.8.8 is sometime in January 2015. (check-in: 71bc73bbc6 user: drh tags: trunk)
17:11
Simplification of the descriptions of Prerelease build products. (check-in: 2dde2e8972 user: drh tags: trunk)
17:10
Simplification of the descriptions of Prerelease products on the download page. (check-in: 130b681d08 user: drh tags: branch-3.8.7)
16:06
Update the URL for mailing lists. (check-in: afa1785659 user: drh tags: trunk)
16:06
Update the URL for mailing lists. (check-in: 834ce49903 user: drh tags: branch-3.8.7)
2015-01-07
12:53
Write ESCAPE instead of EXCEPT as the modifier for the LIKE operator. (check-in: 1e0e7c9300 user: drh tags: trunk)
2015-01-06
16:11
Updates to the testing document. (check-in: 1193750b85 user: drh tags: trunk)
2015-01-05
21:38
Update the documentation to report that there is no limit on the number of terms in a VALUES clause. (check-in: 9cc86fd71d user: drh tags: trunk)
2015-01-02
18:43
Update documentation for the SQLITE_CONFIG_PMASZ start-time option. (check-in: 804af47bf3 user: drh tags: trunk)
2014-12-25
01:09
Fix a typo in the documentation for PRAGMA data_version. (check-in: 19930f5ff0 user: drh tags: trunk)
2014-12-22
18:41
Refine the way PRAGMA data_version works. (check-in: 5bc1374bd4 user: drh tags: trunk)
2014-12-20
14:50
Add documentation for the "PRAGMA data_version" command. (check-in: 115f3d9154 user: drh tags: trunk)
2014-12-19
12:45
In althttpd.c: Fix a comment marking a MakeLogEntry() call to include the LOG: keyword so that it is correctly picked up for recording the location of MakeLogEntry() calls. (check-in: c92bd8c857 user: drh tags: trunk)
2014-12-18
21:37
Merge recent 3.8.7 documentation fixes into the trunk branch. (check-in: 272e47f56d user: drh tags: trunk)
21:34
Pass the HTTP_ACCEPT_ENCODING parameter to CGI programs. (check-in: 3985f4812e user: drh tags: branch-3.8.7)
20:28
Change the search link on the /search page to use https. (check-in: 53758cb024 user: drh tags: branch-3.8.7)
2014-12-16
12:48
Add recent enhancements and bug fixes to the change log for 3.8.8. (check-in: d9b4a84657 user: drh tags: trunk)
00:30
Merge changes from the 3.8.7 branch. (check-in: f7bef26292 user: drh tags: trunk)
2014-12-10
20:36
Fix version leaks in news.html. (check-in: 03d9492267 user: drh tags: branch-3.8.7)
17:43
Fix minor typo on the FAQ page. (check-in: 6d1524e625 user: mistachkin tags: trunk)
03:48
Correct several typos on the result code page (rescode.html). (check-in: 069c44a28e user: drh tags: branch-3.8.7)
03:47
Updates to the change log for recent enhancements. (check-in: c49f5541f9 user: drh tags: trunk)
2014-12-09
23:45
Correct several typos on the result code page (rescode.html). (check-in: 0c60218b55 user: mistachkin tags: trunk)
18:28
Add anchors to the syntaxdiagrams.html page. (check-in: 052259eccb user: drh tags: trunk)
18:28
Add anchors to the syntaxdiagrams.html page. (check-in: b3c80950d8 user: drh tags: branch-3.8.7)
15:35
Merge the 3.8.7.4 release changes. Add the latest 3.8.8 enhancements to the change log. (check-in: aa7191431a user: drh tags: trunk)
01:41
Website changes for the 3.8.7.4 release. (check-in: 34f1feeea7 user: drh tags: branch-3.8.7)
2014-12-06
15:13
Merge the 3.8.7.3 release changes into trunk. (check-in: 8fb499552f user: drh tags: trunk)
06:53
Add the sha1sum and SQLITE_SOURCE_ID for version 3.8.7.3. (check-in: 4c00b47b5d user: dan tags: branch-3.8.7)
2014-12-05
18:34
Update the list of Consortium members. (check-in: 381383ba34 user: drh tags: branch-3.8.7)
16:18
Updates the website for the 3.8.7.3 release. (check-in: cbe10b532d user: drh tags: branch-3.8.7)
00:07
Update the change log to reflect recent progress. (check-in: 3abfd7cf87 user: drh tags: trunk)
2014-12-03
15:50
Updates related to SQLITE_CHECKPOINT_TRUNCATE and especially to the PRAGMA wal_checkpoint documentation. (check-in: 8418b34bb8 user: drh tags: trunk)
2014-12-01
13:53
Add a couple of fragment marks to the WITHOUT ROWID document. (check-in: 571ed1e986 user: drh tags: trunk)
2014-11-21
13:42
Clarification to the documentation on the reverse_unordered_selects pragma. (check-in: 3d72482e47 user: drh tags: trunk)
2014-11-20
23:19
Fix a typo in the documention for abs(). (check-in: 243484a535 user: drh tags: trunk)
19:15
Updates to the file-format document. (check-in: c17b8feb60 user: drh tags: trunk)
02:13
Further enhancements to the file format document. (check-in: 0e52679d7c user: drh tags: trunk)
2014-11-19
22:22
Minor tweaks to the file format documentation. (check-in: 63cc893eba user: drh tags: trunk)
13:50
Fix a faulty requirement mark on the previous check-in. (check-in: 5c05494072 user: drh tags: trunk)
13:42
Add documentation for the noskipscan token in sqlite_stat1. (check-in: 242e4f73aa user: drh tags: trunk)
13:40
Merge website changes from the 3.8.7.2 branch. (check-in: 52c586dfd1 user: drh tags: trunk)
12:03
Version 3.8.7.2 (check-in: df485e2cdb user: drh tags: release, version-3.8.7.2, branch-3.8.7)
07:03
Add the sha1sum and SOURCE_ID for version 3.8.7.2. (check-in: 8fe4305258 user: dan tags: branch-3.8.7)
2014-11-18
18:00
Add a news item for the 3.8.7.2 release. (check-in: 56ba9127eb user: drh tags: branch-3.8.7)
13:30
Add the change log and update the index page for 3.8.7.2. (check-in: 1f42f870e2 user: drh tags: branch-3.8.7)
2014-11-12
01:43
Update the documentation to state that CTEs are not supported inside of triggers. (check-in: a88023a792 user: drh tags: trunk)
2014-11-11
21:11
Update ROLLBACK documentation to explain that SQLITE_ABORT_ROLLBACK is avoided for read operations if the schema is unchanged. (check-in: dbad62eafd user: drh tags: trunk)
20:22
Updates to the change log (check-in: 5498f534a2 user: drh tags: trunk)
12:18
Update autoincrement documentation to make it clear that inserts that subsequently roll back can have their rowids reused. (check-in: c9b9542439 user: drh tags: trunk)
2014-11-10
13:54
Process the -logfile argument of althttpd.c using strftime(). (check-in: 1c89e1bfa7 user: drh tags: trunk)
2014-11-07
13:25
Add the SQLITE_ENABLE_STMT_SCANSTATUS compile-time option. (check-in: 6e6b64e70c user: drh tags: trunk)
13:24
Fix a typo in the amalgamation.html document. (check-in: 422590eebb user: drh tags: trunk)
2014-11-01
12:27
Search query goes to https instead of http. (check-in: 3fc391aaa7 user: drh tags: branch-3.8.7)
12:26
Search query goes to https instead of http. (check-in: 1c7a04ef3c user: drh tags: trunk)
2014-10-31
19:02
Merge in the 3.8.7.1 changes. (check-in: 1f802a1707 user: drh tags: trunk)
2014-10-29
14:08
Add sha1sum and SQLITE_SOURCE_ID for 3.8.7.1 to changes.html. (check-in: 0266552227 user: dan tags: branch-3.8.7)
11:15
Update the website for version 3.8.7. (check-in: fc792a76a2 user: drh tags: branch-3.8.7)
2014-10-28
19:51
Back out change [f9a2ecb98079]. ROWID values can indeed be changed by a VACUUM. (check-in: cfa8ce2773 user: drh tags: trunk)
12:49
Begin adding notes on the changes for 3.8.8. (check-in: c95795d137 user: drh tags: trunk)
2014-10-27
11:26
Add a small number of evidence marks to wal.html. (check-in: 461e6bbcf3 user: dan tags: trunk)
2014-10-25
13:09
Fix a paragraph number in the vtab.html document. (check-in: 66c36ec0c8 user: drh tags: trunk)
2014-10-24
19:41
Add an extra byte to the end of an allocated buffer, to make doubly-sure to avoid a buffer overrun. (check-in: 81ebf06056 user: drh tags: trunk)
2014-10-23
17:41
Change the documentation to show that ROWID values are preserved across a VACUUM. (check-in: f9a2ecb980 user: drh tags: trunk)
16:38
Make sure that "devids.net" does not appear in the referrer log. Change the name to "devids.net.smut". (check-in: 974a16487b user: drh tags: trunk)
15:04
Fix a missing "LOG:" in a comment of althttpd.c (check-in: d562f4165f user: drh tags: trunk)
14:51
Add comments to the althttpd.c source file that identify all possible "lineno" values for the 17th parameter of the log file. (check-in: ccf1203477 user: drh tags: trunk)
14:15
Althttpd enhancements: Add a 17th field to the log file that records the source-code line from which the log file message was generated. This is useful for studying the causes of request failures. Also, invoke Malfunction() on any unix API error. (check-in: 415faae9bf user: drh tags: trunk)
2014-10-17
11:28
Version 3.8.7 (check-in: 06c69dc9d2 user: drh tags: trunk, release, version-3.8.7)
2014-10-16
16:32
Fix documentation typos. Add a news article for 3.8.7. (check-in: 8076857500 user: drh tags: trunk)
2014-10-11
10:52
Add the DESC GROUP BY ORDER BY bug to the changes page for 3.8.7. (check-in: 78bc13ed79 user: drh tags: trunk)
2014-10-08
18:30
Updates to the 3.8.7 change log. (check-in: 25c7b7896e user: drh tags: trunk)
2014-10-07
12:40
Add the not-found.html page. (check-in: 2e2274895f user: drh tags: trunk)
2014-10-06
15:08
Add to the file-format documentation the constraint that stat3 and stat4 samples must be ordered. (check-in: fad8e07e26 user: drh tags: trunk)
03:07
In althttpd.c: Fix a bug such that HTTPS requests are correctly logged as such. If the "--https 1" command-line option is used, then try to read the remote IP address from the REMOTE_HOST environment variable, under the assumption that althttpd is being called from stunnel. (check-in: c34e8da80a user: drh tags: trunk)
00:35
Detect and disable a "bashdoor" attack against althttpd.c. (check-in: 389e06d34a user: drh tags: trunk)
2014-10-05
23:01
Improved documentation comments on the althttpd.c server program. (check-in: d217041b2b user: drh tags: trunk)
20:54
Update the HTTP server to prohibit malformed and possibly malicious HTTP_HOST parameters. (check-in: 5bb4dfcc73 user: drh tags: trunk)
20:07
Move the 3.8.7 release into October. Updates to URI documentation. (check-in: 55869edbde user: drh tags: trunk)
2014-09-30
12:57
Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. (check-in: a893d831f4 user: drh tags: trunk)
2014-09-25
21:14
Links to syntax diagrams now go to a page that contains just that one diagram, rather than the page of all diagrams. This is the first step toward adding descriptive text about each diagram. (check-in: 3fd4c6332b user: drh tags: trunk)
2014-09-24
13:26
Clarify that bound parameters may not appear in the DEFAULT clause of a CREATE TABLE statement. (Leaf check-in: c914be12fe user: drh tags: version-3.8.6)
13:25
Clarify that bound parameters may not appear in the DEFAULT clause of a CREATE TABLE statement. (check-in: d59078695f user: drh tags: trunk)
2014-09-21
16:58
Cherrypick typo fixes from trunk. (check-in: d72427edab user: drh tags: version-3.8.6)
16:57
Fix typos. (check-in: d2dedc4ab1 user: drh tags: trunk)
2014-09-20
00:56
Update the change log to include the latest revisions. (check-in: cb6d3fd5fe user: drh tags: trunk)
2014-09-17
04:03
Add the "vsix" mimetype to the althttpd.c server. (check-in: 881c3a3aed user: drh tags: trunk)
2014-09-08
16:40
Change "Sanskrit" to "Klingon". (check-in: 45d046a549 user: drh tags: trunk)
12:34
Fix typos in the OpenDocument case study. (check-in: 6c66d1ee77 user: drh tags: version-3.8.6)
12:33
Fix typos in the OpenDocument case study. (check-in: d1bb4a6b20 user: drh tags: trunk)
12:11
Add the OpenDocument as SQLite case study. (Cherrypicked from trunk.) (check-in: a39452f2a5 user: drh tags: version-3.8.6)
12:09
Add the OpenDocument as SQLite case study. (check-in: 2c57c78315 user: drh tags: trunk)
2014-09-05
12:50
Fix the version number of Ubuntu. (check-in: c9e67374a1 user: drh tags: trunk)
2014-09-01
18:31
Further tweaks to the change log for 3.8.7. (check-in: e3957c53b1 user: drh tags: trunk)
18:16
Add documentation about the threads pragma and the WORKER_THREADS compile-time options. Update the change log to include the latest performance numbers and mention of multi-threaded sorting. (check-in: 39b74ae928 user: drh tags: trunk)
2014-08-27
18:49
Add an initial change log for version 3.8.7. (check-in: d7f4783e95 user: drh tags: trunk)
15:25
Add the Aditya and Karn book on SQLite in Android. (check-in: 9def66ffaf user: drh tags: trunk)
2014-08-19
10:23
Add a link to the "How To Corrupt" document from the topical index. (check-in: b50b87b898 user: drh tags: trunk)
10:18
Add a link to the Facebook corruption report caused by using a closed file descriptor. (check-in: a2d97df5b9 user: drh tags: trunk)
2014-08-16
18:44
Fix some text in the limits.html page. (check-in: 26162d3d2b user: drh tags: trunk)
2014-08-15
19:06
Version 3.8.6 (check-in: e477e238b6 user: drh tags: trunk, release, version-3.8.6)
17:32
Updates to the topical documentation index. (check-in: 19359f2dd7 user: drh tags: trunk)
15:48
Update the "Appropriate Uses" page and the "Documentation" index. Fix the size information in "Distinctive Features". (check-in: a6e3e556b4 user: drh tags: trunk)
15:01
Fix a typo in a hyperlink. (check-in: 7c9241801c user: drh tags: trunk)
14:59
Fix typos and add new hyperlinks. (check-in: 415cd2bfe2 user: drh tags: trunk)
13:45
Add the sha1sum and source-id for version 3.8.6 to the changelog. (check-in: 1e9ff29172 user: dan tags: trunk)
13:36
Clarification and amplification of AUTOINCREMENT. (check-in: 60668454be user: drh tags: trunk)
00:49
Clarifications to the ON CONFLICT documentation. (check-in: 445adeb211 user: drh tags: trunk)
2014-08-14
14:39
Change an "is" to a "was" in the news. (check-in: 7ca803de2b user: drh tags: trunk)
14:37
Update the 3.8.6 news item. (check-in: 9af7ac771f user: drh tags: trunk)
13:06
Fix typos. (check-in: 09088d9a21 user: drh tags: trunk)
12:49
Set the release date for 2014-08-15. Add a News entry for the release. (check-in: 4de3b544f0 user: drh tags: trunk)
2014-08-13
18:53
Updates to the webserver source code. (check-in: 1c4aeae543 user: drh tags: trunk)
2014-08-12
22:47
Mention that the argument to pragma table_info can be a view. (check-in: 63eb2d2623 user: drh tags: trunk)
02:49
Updates to the "How SQLite Is Tested" document. (check-in: 7aa17891ac user: drh tags: trunk)
2014-08-11
23:56
Updates to the "How SQLite Is Tested" document. (check-in: b7925a9372 user: drh tags: trunk)
21:17
Fix requirements marks in the file format document. Improvements to PRAGMA documentation. (check-in: e09448dc9d user: drh tags: trunk)
18:36
Updates to expression documentation. (check-in: 5608ec77f8 user: drh tags: trunk)
2014-08-08
21:27
Fix documentation errors and typos. (check-in: 066b35fad5 user: drh tags: trunk)
17:05
First complete draft of the "rescode.html" document. (check-in: e5ea14f1ff user: drh tags: trunk)
12:50
Work-in-progress: refactoring the documentation on integer result codes. (check-in: b22f668cca user: drh tags: trunk)
2014-08-07
13:22
General documentation updates. Attempts to provide better links and improve wording for better readability. (check-in: 430bf0b418 user: drh tags: trunk)
2014-08-06
01:08
Add the DEFAULT bug to the change log. Fix a few typos. (check-in: c60ce44b02 user: drh tags: trunk)
2014-08-05
20:37
Update the amalgamation document with the latest size and file count numbers. Add yet another link to the How To Compile document. (check-in: 5b99c03910 user: drh tags: trunk)
20:22
Update the change log for the latest changes. Make it easier to find the "How To Compile" documentation. Remove Nokia from the sponsors list. (check-in: c22649df68 user: drh tags: trunk)
2014-08-01
03:11
Enhance the documentation on PRAGMA integrity_check to match recent implementation enhancements. Add the enhancements to PRAGMA integrity_check to the change log. (check-in: 6b17e6415e user: drh tags: trunk)
2014-07-31
19:04
Add the DISTINCT optimization to the change log for 3.8.6. (check-in: 06696e7778 user: drh tags: trunk)
19:02
Clarification to the "Examples" section on the CREATE TRIGGER documentation page. (check-in: bd0aa2fc3b user: drh tags: trunk)
2014-07-30
14:31
Update the change log to include the CREATE UNIQUE INDEX fix. (check-in: dfe6ec1900 user: drh tags: trunk)
2014-07-29
12:59
Update the change log and the home page for the R-Tree "rowid IN ..." bug. (check-in: e0e37413af user: drh tags: trunk)
2014-07-26
18:03
New image for the Das book. (check-in: 800e621e25 user: drh tags: trunk)
2014-07-25
18:38
Improvements to the "opcode.html" page that documents the VDBE. (check-in: e6972343b0 user: drh tags: trunk)
12:35
Add the book by Sribatsa Das. (check-in: 258b50a4d4 user: drh tags: trunk)
2014-07-24
15:44
Add a change-log not about schema indexes being preferred over transient indexes. (check-in: 3659d1f8cd user: drh tags: trunk)
15:36
Add a change log for version 3.8.6. Update the home page for version 3.8.6. (check-in: 0d81c00b9a user: drh tags: trunk)
14:39
Add documentation for sqlite3_index_info.estimatedRows, part of the virtual table interface. (check-in: 77f80a4186 user: dan tags: trunk)
14:27
Add documentation on the hexadecimal integer notation. (check-in: 4656303de6 user: drh tags: trunk)
13:50
Add documentation about the readfile() and writefile() extension functions in the command-line shell. Additional command-line shell documentation updates. (check-in: d4097ee3bf user: drh tags: trunk)
2014-07-22
12:24
Enhance the file format description to allow unrecognized text tokens at the end of the stat column in sqlite_stat1. (check-in: 3e1aad19c5 user: drh tags: trunk)
2014-07-18
19:06
Clarify that PRAGMA wal_autocheckpoint always causes a PASSIVE checkpoint. Provide clearer definitions for PASSIVE, FULL, and RESET checkpoints. (check-in: 306698cb1d user: drh tags: trunk)
2014-07-07
13:13
Clarification of the automerge documentation in FTS3. (check-in: a8e5cf50a0 user: drh tags: trunk)
10:39
Add documentation for the "^" qualifier to fts3.html. (check-in: 6a74a13c86 user: dan tags: trunk)
2014-07-03
11:15
Fix a typo in vtab.html. (check-in: 34e181958c user: dan tags: trunk)
2014-07-02
16:24
Fix some typos in queryplanner-ng.in. (check-in: 8471968fb0 user: dan tags: trunk)
2014-06-30
17:52
Enhance the description of the sqlite_stat4 format for WITHOUT ROWID tables. (check-in: d7f83670d7 user: drh tags: trunk)
16:26
Fix a couple minor typos in the download page regarding the 64-bit Windows DLL. (check-in: c908300540 user: mistachkin tags: trunk)
2014-06-27
20:49
Clarifications to the FTS4 languageid documentation. (check-in: 0a22af73df user: drh tags: trunk)
2014-06-26
21:05
Fix a typo in datatype3.html and add a new bullet to clarify the affinity for the RHS of an IN or NOT IN operator. (check-in: e89c80cd7d user: drh tags: trunk)
2014-06-16
15:11
Update the ".help" screen capture in the "cli.html" document to show the ".eqp" command. (check-in: c4d6ba9b0c user: drh tags: trunk)
2014-06-04
19:42
Version 3.8.5 (check-in: 0f7dec0517 user: drh tags: trunk, release, version-3.8.5)
19:42
Update the download page to include information about the WinPhone8.1 VSIX file. (check-in: 6d6bc21356 user: drh tags: trunk)
14:17
Add the SQLITE_SOURCE_ID and sha1 sum for version 3.8.5. (check-in: 98333ba617 user: dan tags: trunk)
11:37
Fix typos. (check-in: 909c2b99c5 user: drh tags: trunk)
11:26
Add news for the 3.8.5 release and set the date to today. (check-in: e047b026ae user: drh tags: trunk)
2014-06-02
18:31
Avoid scanning both fileformat.html and fileformat2.html for requirements since one is a copy of the other. (check-in: 51c582171c user: drh tags: trunk)
2014-05-30
18:14
Document the SQLITE_WIN32_HEAP_CREATE and SQLITE_WIN32_MALLOC_VALIDATE compile-time options. (check-in: 9816bbf88c user: mistachkin tags: trunk)
18:01
Add a section describing the Win32 native memory allocator. (check-in: ef8f1ed845 user: mistachkin tags: trunk)
17:01
Enhancements to malloc.html documentation to address concerns arising out of heartbleed. (check-in: 2bc13084bc user: drh tags: trunk)
2014-05-29
15:46
Change the default maximum POST size in althttpd to 20MB. (check-in: 35fcd6cd5b user: drh tags: trunk)
14:08
Update the cli.html document and the change log for the .system and the .once enhancements to the command-line shell. (check-in: a0826e6976 user: drh tags: trunk)
2014-05-28
19:37
Add instructions on building DLLs to the howtocompile.html page. (check-in: cec1821ade user: drh tags: trunk)
11:14
Fix the description of the notindexed problem in the change log. (check-in: 8803444b62 user: drh tags: trunk)
2014-05-27
15:31
Add the "X in (?)" optimization to the change log. (check-in: 487c297731 user: drh tags: trunk)
10:31
Fix documentation typos reported on the mailing list. (check-in: 84efe9e646 user: drh tags: trunk)
2014-05-26
23:18
Fix Win32 to say Win64 for 64-bit DLLs on the download page. (check-in: 3638ded7d1 user: drh tags: trunk)
23:18
Fix Win32 to say Win64 for 64-bit DLLs on the download page. (Leaf check-in: e56e2046b0 user: drh tags: version-3.8.4.3)
23:16
Fixes the download of pre-release DLLs. (check-in: 57d62024df user: drh tags: trunk)
23:16
Fixes the download of pre-release DLLs. (check-in: 076319aa90 user: drh tags: version-3.8.4.3)
22:56
Update the download page to support DLL snapshots. (check-in: 3cfd0f3e9a user: drh tags: version-3.8.4.3)
22:49
Update the download page to support DLL snapshots. Update the change log for 3.8.5. (check-in: 3eab08af2c user: drh tags: trunk)
21:43
Fix typos and clarify the text on the Partial Sorting Using An Index section of queryplanner.html. (check-in: fee38cf31f user: drh tags: trunk)
15:38
Talk about partial index sorting in the queryplanner.html document. (check-in: f81d69fb6a user: drh tags: trunk)
13:58
Fix typos in the new ALTER TABLE documentation and in the queryplanner.html document. (check-in: be73465c0f user: drh tags: trunk)
13:10
Fix typos and clarify the text in the TH3 document. (check-in: 8e68e11794 user: drh tags: trunk)
13:00
Additional remarks on the use of checklists in the testing.html document. (check-in: 8a2b7d834e user: drh tags: trunk)
12:43
Better support for Windows in the howtocompile.html document. (check-in: 55ab2074b0 user: drh tags: trunk)
11:56
Updates to the ALTER TABLE documentation. Provide a clear warning that RENAME TO does not rewrite referencing triggers and views. Provide two correct procedures for making other kinds of schema changes. (check-in: d4418abf42 user: drh tags: trunk)
2014-05-25
22:11
Make sure fileformat.html stays in sync with fileformat2.html. (check-in: df6145bd4e user: drh tags: trunk)
22:00
Revisions to the arbitrary table schema change text in ALTER TABLE. (check-in: b730943d19 user: drh tags: trunk)
21:54
Add instructions for how to do arbitrary schema changes to the ALTER TABLE documentation. (check-in: 227fb14d50 user: drh tags: trunk)
20:11
Another accidental fork merge. (check-in: b1b9dd90bb user: drh tags: trunk)
20:08
Enhancements to the optoverview.html document: Added discussion of partial sorting and fixed the conditions for query flattening. (check-in: fc0e9baa66 user: drh tags: trunk)
2014-05-24
17:31
Merge accidental fork (check-in: 0f2064446a user: drh tags: trunk)
17:16
Further improvements to the opcodes.html documentation generator. (check-in: 4f034b4e83 user: drh tags: trunk)
17:01
Enhance the "opcodes.html" document to include hyperlinks from to the opcodes. (check-in: 0d929c02e3 user: drh tags: trunk)
16:20
Update the change log for 3.8.5. Fix a typo in the isolation.html document. (check-in: ee616cbbb3 user: drh tags: trunk)
2014-05-22
10:00
Fix a typo in FAQ item 14. (check-in: 1b0ed95a32 user: dan tags: trunk)
2014-05-19
20:00
Clarification in the text of the release notes for 3.8.5. (check-in: c0ce61ad28 user: drh tags: trunk)
19:55
Mention the automerge enhancement in the release notes. (check-in: 5b3b975982 user: drh tags: trunk)
2014-05-16
11:28
Update fts3.html for recent changes to FTS. (check-in: ae994ce63a user: dan tags: trunk)
2014-05-09
22:27
Fix typo in VALUES clause documentation in lang.html. (check-in: fee01c2d5b user: drh tags: trunk)
2014-05-07
16:00
Add notes on the SQLITE_IOCAP_IMMUTABLE and "nolock" and "immutable" query parameter changes. (check-in: 7aa71cbb0c user: drh tags: trunk)
2014-05-01
14:44
Updates to the R*Tree documentation. (check-in: bd0fe1c3e1 user: drh tags: trunk)
2014-04-29
15:08
Added documentation for the sqlite3_rtree_query_callback() enhancement. (check-in: 89557fb903 user: drh tags: trunk)
2014-04-26
00:30
Update althttpd.c client to log SIGPIPE and SIGSEGV in addition to SIGALRM. (check-in: 5a80e1c8e7 user: drh tags: version-3.8.4.3)
2014-04-25
20:47
Fix more typos in the foreignkey.html document. (check-in: 25bc66990e user: drh tags: version-3.8.4.3)
20:46
Fix more typos in the foreignkey.html document. (check-in: 2de942054f user: drh tags: trunk)
20:23
Fix a typo in the foreign key documentation. (check-in: 821750714a user: drh tags: trunk)
2014-04-22
01:19
Clarification of one of the 3.8.5 changes lines. (check-in: 72fa86df8d user: drh tags: trunk)
01:06
Update the version number to 3.8.5. Add a change log. (check-in: aabef1a296 user: drh tags: trunk)
00:32
Rename the "sqlite.html" page to "cli.html". Keep an "sqlite.html" page that redirects to "cli.html". (check-in: a6ea023899 user: drh tags: trunk)
2014-04-21
18:20
Update the command-line shell documentation with a discussion of CSV import and export. (check-in: 070bfddab9 user: drh tags: trunk)
13:12
Update the FAQ. (check-in: eb122dda42 user: drh tags: trunk)
2014-04-05
12:04
Fix a typo on the 3.8.4.3 news page. (check-in: 7401266cf0 user: drh tags: trunk)
2014-04-03
17:07
Version 3.8.4.3 (check-in: 2482a30724 user: drh tags: trunk, release, version-3.8.4.3)
2014-04-01
17:19
Tweaks and maintenance on the various documentation pages. Improvements to wording. Updated hyperlinks. (check-in: c08c92bf98 user: drh tags: trunk)
15:02
Strengthen the disclaimers on the "speed.html" page and on the "PRAGMA stats" documentation. (check-in: 0bbad9c76b user: drh tags: trunk)
13:44
Fixes to the application file format document. (check-in: f3db82e049 user: drh tags: trunk)
2014-03-26
18:53
Version 3.8.4.2 (check-in: 2f86548772 user: drh tags: trunk, release, version-3.8.4.2)
18:12
Add notes for the 3.8.4.2 patch release. (check-in: 35bef59b0d user: drh tags: trunk)
2014-03-17
18:30
Add a note about the use of checklists to the "testing.html" page. (check-in: 835c236ee8 user: drh tags: trunk)
18:05
Fix a hyperlink to the "application file format" page. (check-in: 06eecd10f7 user: drh tags: trunk)
2014-03-15
12:25
One more pass, with a few minor corrections, over the application file format document. (check-in: 0dc508ed1b user: drh tags: trunk)
2014-03-14
22:27
More edits to the application-file-format document. (check-in: c0ac5630f2 user: drh tags: trunk)
16:35
Further tuning of the application file format document. (check-in: 1b422ce8de user: drh tags: trunk)
2014-03-13
15:38
Improvements to the application file format document. (check-in: 9e12f0cedd user: drh tags: trunk)
00:43
First complete draft of the new application file format document. Integrate with the rest of the documentation via hyperlinks. (check-in: 6d257b8d92 user: drh tags: trunk)
2014-03-12
18:12
First draft of a document that advocates for using SQLite as an application file format. (check-in: aa63d85794 user: drh tags: trunk)
2014-03-11
15:30
Version 3.8.4.1 (check-in: 103145ba79 user: drh tags: trunk, release, version-3.8.4.1)
14:53
Update change log, index, and news for version 3.8.4.1 (check-in: d1f96df9b2 user: drh tags: trunk)
2014-03-10
12:23
The 3.8.4 release. (check-in: 9ac72e3702 user: drh tags: trunk)
2014-03-08
03:21
Add a news blurb for the 3.8.4 release. (check-in: 02c3db4e28 user: drh tags: trunk)
2014-03-06
02:12
Update the index page and change log in anticipation for 3.8.4. (check-in: 2c81b82587 user: drh tags: trunk)
2014-02-28
12:26
Minor clarifications of recent documentation. (check-in: e139253c4b user: drh tags: trunk)
2014-02-22
13:55
Clarification of what it means for the expression in a DEFAULT clause to be constant. (check-in: 0b36750358 user: drh tags: trunk)
2014-02-21
13:21
Update the all-bnf.html file. (check-in: 424fd15707 user: drh tags: trunk)