Documentation Source Text

Timeline
Login

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

1376 check-ins using file search/mkscript.tcl version 2ea313b0d7

2022-12-08
22:00
A WIP. Build code and make changes done except for DB ops in inc_update.tcl . A target much like "fast" added, "faster". (Leaf check-in: 40122d32eb user: larrybr tags: docgen_speedup)
21:19
Fix formatting and other errors in profile.in. (Leaf check-in: 853663efc5 user: dan tags: trunk)
21:06
Add "profile.html", describing the query profiles generated by ".scanstats on" in the shell tool. (check-in: ca0207fee1 user: dan tags: trunk)
2022-12-07
17:49
Get fresh-checkout build to work and improve notes on how to do that in Makefile. (check-in: 6ca848f8ee user: larrybr tags: trunk)
2022-12-05
12:38
Minor typo fixes in vtab.in. (check-in: e60bcd90e5 user: stephan tags: trunk)
2022-12-03
17:10
Create incremental doc-gen for developer convience. Instead of scanning and re-rendering all page inputs, do so only for modified ones by maintaining and using a persistent DB for scanned info. A WIP just now. (check-in: a2de0ee407 user: larrybr tags: docgen_speedup)
2022-11-29
18:44
Clarify CLI doc on details of .import/.export and RFC 4180 confoermance. (check-in: 03393f1dff user: larrybr tags: trunk)
2022-11-26
14:56
Fix poor interaction with requirement marks on last commit.] (check-in: c5e33f251d user: larrybr tags: trunk)
13:41
Remove wee blemish mentioned in forum post 87dd66375a (check-in: d700d4e5ef user: larrybr tags: trunk)
2022-11-25
17:33
Break up an accidental looong line in last commit. (check-in: a660ff6324 user: larrybr tags: trunk)
17:29
Update Tcl interface doc to reflect recent revisions and some subtle aspects of behavior. (check-in: b0d39a7a77 user: larrybr tags: trunk)
2022-11-21
19:17
Document column names for pragma_table_{info,xinfo} and disclaim some meanings for the "cid" column. (check-in: ae3ab2d9be user: larrybr tags: trunk)
14:37
In the floating point documentation, observe that RTREE uses reduced precision floating point. (check-in: 9fcdcb8c90 user: drh tags: trunk)
2022-11-17
12:55
Fix typo in the 3.40.0 change log. (check-in: dd2fb1675e user: drh tags: trunk)
2022-11-16
22:21
Improved contact information on the "quirks" page. (check-in: c1aa97b105 user: drh tags: trunk)
12:23
Version 3.40.0 (check-in: 653ad114b1 user: drh tags: trunk, release, version-3.40.0)
12:07
Add a news entry for 3.40.0 and change the date to today. (check-in: 79e0e32ce2 user: drh tags: trunk)
2022-11-15
23:18
Update the speed-and-size spreadsheet with the latest measurements. (check-in: fe42f89485 user: drh tags: trunk)
22:37
Documentation for the restriction of schema_version in defensive mode. (check-in: a47332b43d user: drh tags: trunk)
2022-11-10
12:16
Specify that the projected release date for 3.40.0 is 2022-11-18. (check-in: 183d2e481f user: drh tags: trunk)
2022-11-09
20:11
Merge documentation enhancements and fixes from branch-3.39 into trunk. (check-in: deff7f46c0 user: drh tags: trunk)
20:09
Enhance the documentation to talk about the differences between PRAGMA table_info and table_xinfo with regard to generated columns. Forum post 90d7fb12ac. (Leaf check-in: 142ff38050 user: drh tags: branch-3.39)
2022-11-08
18:48
Update the speed and size graph. (check-in: e2ca819f50 user: drh tags: trunk)
2022-11-07
14:29
Hyperlink to the SQLITE_MAX_ALLOCATION_SIZE documentation from the change log. (check-in: 6fd6233d0c user: drh tags: trunk)
14:28
Document the SQLITE_MAX_ALLOCATION_SIZE compile-time option. (check-in: 65101405ce user: drh tags: trunk)
2022-11-04
15:23
Fix a duplicate label. (check-in: 756912e14e user: drh tags: trunk)
14:15
Updates to the change log for 3.40.0 (check-in: 087de07a9d user: drh tags: trunk)
2022-11-03
11:10
Link to the WASM docs from the change log. (check-in: 68a3d21403 user: drh tags: trunk)
2022-11-02
14:43
First draft of the recovery documentation completed. (check-in: c13c2b3183 user: drh tags: trunk)
10:50
Continuing work on the recovery documentation. Still much more to do. (check-in: 7bbd15fd92 user: drh tags: trunk)
2022-11-01
22:57
Fix typo in the CLI documentation. Forum post ae5a73d946. (check-in: ca45d469df user: drh tags: branch-3.39)
22:57
Fix a typo in the vtab documentation. (check-in: a7a20e71da user: drh tags: branch-3.39)
22:56
Initial (incomplete) documentation for the recovery extension. (check-in: c8e17f383d user: drh tags: trunk)
22:55
Fix typo in the CLI documentation. Forum post ae5a73d946. (check-in: 55e602d2f4 user: drh tags: trunk)
2022-10-29
17:50
Fix a typo in the vtab documentation. (check-in: 028b4422d8 user: drh tags: trunk)
2022-10-26
20:02
Fix minor typo. Forum post 1af006ebaf. (check-in: ce71f82b22 user: drh tags: branch-3.39)
18:58
Add mention of the recovery extension to the change log for 3.40.0. (check-in: ad79d1a2b3 user: drh tags: trunk)
13:30
Begin a change log for 3.40.0. (check-in: cb01c82de3 user: drh tags: trunk)
10:38
Include the WASM build on the download page. (check-in: 1304ed4369 user: drh tags: trunk)
06:05
Add download section for the wasm build. Tweak a setTimeout() call to avoid having to introduce a global-scope function. (Leaf check-in: 1bd6c2aee6 user: stephan tags: wasm-download)
06:01
anti-robot JS code: handle case that HTML element #mtimelink is missing (triggered on download.html). (check-in: 5f822ec052 user: stephan tags: trunk)
2022-10-07
10:23
Remove a paragraph from the "bindptr.html" document that is confusing and does not seem to contribute to the understanding of the interface. Forum post ac86154a61. (check-in: 10eb706fb9 user: drh tags: trunk)
2022-10-02
22:53
Fix a minor typo in the CLI documentation. (check-in: d1fe3e4879 user: drh tags: trunk)
2022-09-30
12:49
Further robustness in the anti-robot defenses and in the search CGI. Follow-up to forum post 35f4500c184fe5bf (check-in: 27be7c620c user: drh tags: trunk)
12:12
Avoid the use of the \ character in the document header, as this confuses some of the TCL code in the search CGI. (check-in: 836f642b64 user: drh tags: trunk)
2022-09-29
16:00
Version 3.39.4 (check-in: 0dda2171c3 user: drh tags: trunk, release, version-3.39.4)
2022-09-27
13:21
Put the "UTC" timezone indication on the "last modified" tags. (check-in: eb883346ce user: drh tags: trunk)
13:16
Attempt to clarify the documentation about the behavior of INSTEAD OF triggers. (check-in: b6ca1053bb user: drh tags: trunk)
2022-09-24
16:31
Fix a broken hyperlink reported by forum post aec0c9cb6d. (check-in: 43d12ec89b user: drh tags: trunk)
2022-09-23
19:18
Enhance the "Last modified" messages so that they provide a hyperlink to the source code, but also include an anti-robot defense. (check-in: b2ed58e67f user: drh tags: trunk)
18:27
Add the "This page last modified on" message to the bottom of most documentation pages. (check-in: 50342cef46 user: drh tags: trunk)
2022-09-19
12:27
Minor tweaks to query optimizer documentation. (check-in: 1ddadab8ef user: drh tags: trunk)
2022-09-13
16:24
Suppress the "Javascript Required" error message page from the list of documents. (check-in: 76038ea830 user: drh tags: trunk)
14:04
Reinstate the formatchange.html document, so as not to create broken links. But make the new formatchange.html document very simple. (check-in: c9a2bbb29c user: drh tags: trunk)
13:54
Remove the obsolete formatchng.html document. (check-in: 94d28c32be user: drh tags: trunk)
2022-09-07
11:54
Add CVE-2019-19646 to the CVE list. (check-in: 19a5432850 user: drh tags: trunk)
2022-09-05
17:01
Fix typo in the release log. (check-in: 8822ef3b87 user: drh tags: trunk)
13:33
Remove the obsolete fileio.html document. (check-in: 2acebe39da user: drh tags: trunk)
11:16
Version 3.39.3 (check-in: 1efa0d69b3 user: drh tags: trunk, release, version-3.39.3)
2022-08-30
14:26
Draft changes for the 3.39.3 patch release. (check-in: 646fe7bc36 user: drh tags: trunk)
2022-08-26
14:04
Add notes on CVE-2021-20223. (check-in: b741235d80 user: drh tags: trunk)
2022-08-15
11:37
Make the documentation more explicit that the use of shared cache mode is discouraged. (check-in: b2d294b663 user: drh tags: trunk)
2022-08-10
18:45
Fix duplicate words reported by forum post 54abbe9ccd. (check-in: 436f0088f9 user: drh tags: trunk)
18:11
Fix a typo in the FTS3 documentation. Forum post d040638562 (check-in: 5a8daeb857 user: drh tags: trunk)
2022-08-09
12:51
Fix typos in the window function documentation. Forum post 52377d35ea. (check-in: 72dc2aecd0 user: drh tags: trunk)
2022-07-29
13:35
Fix typo in "Frame Boundaries" section of windowfunctions.in. (check-in: fb1a687eda user: dan tags: trunk)
00:41
Fix a documentation typo. Also update the speed-size spreadsheet. (check-in: a55e3cc610 user: drh tags: trunk)
2022-07-22
16:50
Enhance the change log to describe the consequences to SQLITE_OPEN_NOFOLLOW for the improved symbolic link resolution. (check-in: a3a0fd572b user: drh tags: trunk)
13:37
Attempt to clarify the selection of bare column values in a query that uses min() or max() aggregates. SQLite Forum thread 4e1de86205d55444 (check-in: 16d86a4a5c user: drh tags: trunk)
2022-07-21
15:32
Version 3.39.2 (check-in: 6c12812e54 user: drh tags: trunk, release, version-3.39.2)
14:31
Preliminary changes for the 3.39.2 release. (check-in: 73d47dce56 user: drh tags: trunk)
2022-07-16
22:09
For CLI, mention features added via extension not otherwise listed. (check-in: aee154c8fc user: larrybr tags: trunk)
18:39
Say what round() does with negative 2nd argument. (check-in: 61ea8e8e19 user: larrybr tags: trunk)
2022-07-13
23:33
Omit stray markup from the docs.html page. (check-in: 3bfebbc747 user: drh tags: trunk)
19:48
Add a news entry for the 3.39.1 release. (check-in: 5311a43e41 user: drh tags: trunk)
19:44
Version 3.39.1 (check-in: 2c4120bfe0 user: drh tags: trunk, release, version-3.39.1)
18:15
Special case code to handle the sqlite3_snapshot object. (check-in: 0aa69ad50d user: drh tags: trunk)
17:40
First draft of changes for a 3.39.1 patch release. (check-in: c3c6d74d61 user: drh tags: trunk)
2022-07-06
19:41
Add a new "Try it live!" link to the "Common Links" menu. (check-in: 5dc0396070 user: drh tags: trunk)
2022-06-25
15:03
Version 3.39.0 (check-in: 4c6e3ca31f user: drh tags: trunk, release, version-3.39.0)
14:27
Add a news item for the 3.39.0 release. (check-in: 320c68033f user: drh tags: trunk)
2022-06-24
23:50
Update the speed and size graph spreadsheet. (check-in: 0ccebbd1f9 user: drh tags: trunk)
16:56
Fixes to the json_quote() documentation. (check-in: b4f619f6b0 user: drh tags: trunk)
2022-06-22
21:14
Typo fix. (check-in: 632d6e83e9 user: drh tags: trunk)
2022-06-21
18:15
Fix a simple typo in the SELECT documentation. (check-in: 2bf05a1fbc user: drh tags: trunk)
14:54
Update the change log and SELECT documentation to talk about the ability to include a HAVING clause without a GROUP BY. (check-in: c7ff8a5643 user: drh tags: trunk)
14:41
Update syntax diagrams to show that you can have a HAVING clause without a GROUP BY. (check-in: 4195254582 user: drh tags: trunk)
2022-06-18
10:05
Merge updates from the 3.38 branch. (check-in: 32c7b8b2ec user: drh tags: trunk)
09:43
Remove references to Flame malware (Leaf check-in: 6e88ae990e user: drh tags: branch-3.38)
2022-06-16
15:42
Minor spelling improvement for "How SQLite Works" (check-in: 6b4bc831bd user: larrybr tags: trunk)
2022-06-15
15:05
Improve README.md per forum post https://sqlite.org/forum/forumpost/44e979d1f6 (check-in: 13c853e5f7 user: larrybr tags: trunk)
10:18
Add bytecode and tables_used to the list of virtual tables in vtablist.html. (check-in: 5f8362e761 user: drh tags: trunk)
00:04
Grammar fix for VACUUM page (check-in: 874526a631 user: larrybr tags: trunk)
2022-06-09
21:48
Typo and minor grammar cleanup for pragma page (check-in: f44bbff888 user: larrybr tags: trunk)
2022-06-05
14:04
Correct ".main" typo in file format doc. (check-in: 0ec1c02fe0 user: larrybr tags: trunk)
2022-06-03
14:28
More precise description of how IS TRUE and IS FALSE work. (check-in: 9330592f9e user: drh tags: trunk)
2022-05-31
20:17
Update the number of release-test evaluations for TCL tests in the testing.html document. (check-in: 974ac5ed88 user: drh tags: trunk)
18:53
Update statistics in testing.html. (check-in: 1685adc8fb user: drh tags: trunk)
2022-05-25
18:55
Typo fix in quirks section of SELECT documentation. (check-in: 3342e215df user: drh tags: trunk)
18:52
Merge updates from the 3.38 branch. (check-in: 026689ac3d user: drh tags: trunk)
17:44
Mention that CVE-2022-21227 is not an SQLite bug. (check-in: da4152762a user: drh tags: branch-3.38)
2022-05-24
11:08
Fix a typo in the previous commit. (check-in: 5d0e94a346 user: drh tags: branch-3.38)
11:05
Add CVE-2022-24854 to the cves.html document. (check-in: b8bd751eba user: drh tags: branch-3.38)
2022-05-23
22:21
Fix minor flaws in nulinstr.html page. (check-in: a548e05d02 user: larrybr tags: trunk)
22:11
Fix a typo. "fo" changed to "of". (check-in: 6d703fa145 user: drh tags: branch-3.38)
11:17
Updates to the change log for 3.39.0. (check-in: fddf0bcc6b user: drh tags: trunk)
2022-05-12
15:23
Documentation for IS DISTINCT FROM and IS NOT DISTINCT FROM. (check-in: ee6304ed53 user: drh tags: trunk)
12:56
Mention the IS DISTINCT FROM operator on the change log. Still need to add documentation. (check-in: 26d925a5e3 user: drh tags: trunk)
2022-05-11
19:14
Add a mention of the symbolic link removal to the change log for 3.39.0. (check-in: 9c9cb1446c user: drh tags: trunk)
2022-05-10
18:44
New requirement marks for SELECT quirks. (check-in: cabe98be0a user: drh tags: trunk)
17:29
Tweaks to documentation in support or RIGHT and FULL JOIN. (check-in: 91f7d0cc38 user: drh tags: trunk)
2022-05-06
18:14
Merge the version 3.38.5 changes to trunk. (check-in: 101531d2d0 user: drh tags: trunk)
15:32
Version 3.38.5 (check-in: b59535ba3d user: drh tags: branch-3.38)
2022-05-04
18:42
Merge 3.38 changes into the trunk. (check-in: d48fedbd31 user: drh tags: trunk)
15:49
Version 3.38.4 (check-in: 4e3ff7c795 user: drh tags: release, branch-3.38, version-3.38.4)
15:42
Update the change log for version 3.38.4. (check-in: 386d9f25db user: drh tags: branch-3.38)
2022-04-30
19:19
Enhance the documentation for the built-in length() SQL function to talk about the fact that it returns the character length. (check-in: 31b23e6f3f user: drh tags: branch-3.38)
19:19
Enhance the documentation for the built-in length() SQL function to talk about the fact that it returns the character length. (check-in: 7ed6173ca0 user: drh tags: trunk)
19:03
Merge branch-3.38 changes into trunk (check-in: 1db17799a2 user: drh tags: trunk)
2022-04-27
12:08
Version 3.38.3 (check-in: c810e1919f user: drh tags: release, branch-3.38, version-3.38.3)
09:23
Add a news item for the 3.38.3 release. (check-in: 091d30e809 user: drh tags: branch-3.38)
09:19
Make the hyperlink to the latest change log on the landing page point to the correct change log entry. (check-in: 4b6d45df57 user: drh tags: branch-3.38)
09:17
Cherry-pick minor documentation fixes from trunk. (check-in: c869cc4a55 user: drh tags: branch-3.38)
09:14
Updates for version 3.38.3. (check-in: 86d8fca261 user: drh tags: branch-3.38)
2022-04-25
03:42
Edit an awkward sentence concerning parser generation in amalgamation write-up. (check-in: 710207eecb user: larrybr tags: trunk)
2022-04-24
19:48
Document CLI enhancements and extensibility (Leaf check-in: 0131658331 user: larrybr tags: cli_extension)
2022-04-22
11:14
Add verbiage to the SELECT documentation that describes some of the non-standard SQLite-isms. (check-in: 27679e946c user: drh tags: trunk)
2022-04-19
12:59
Typo fix in JSON doc. (check-in: 85cf758980 user: larrybr tags: trunk)
2022-04-18
21:57
Also mention integer divide truncation. (check-in: bd1210ef89 user: larrybr tags: trunk)
21:13
In expressions page, mention effects of arithmetic operators in summary form. (check-in: 87a9b238b7 user: larrybr tags: trunk)
02:55
sync w/trunk in preparation for extensible shell doc update and creation (check-in: 6614946a15 user: larrybr tags: cli_extension)
2022-04-13
13:11
Update the change log, syntax diagrams, and SELECT documentation to describe RIGHT and FULL JOIN. More work to be done on this. (check-in: 7dc766ebe1 user: drh tags: trunk)
2022-04-12
00:22
In datatypes explainer, note that "Determination of Column Affinity" section does not apply to STRICT tables. (check-in: bbba322a09 user: larrybr tags: trunk)
2022-04-10
15:38
Add poor locking to the reasons to avoid DB-over-network. (check-in: c1e2fd15ff user: larrybr tags: trunk)
2022-04-07
12:29
Update the CPU cycle reduction amount after the latest optimizations. (check-in: a11c6b3eaa user: drh tags: trunk)
2022-04-06
18:55
Updates to the debugging hints. (check-in: 9468361b47 user: drh tags: trunk)
12:31
Merge the version 3.38.2 changes into trunk. (check-in: 793b8ea988 user: drh tags: trunk)
12:25
Update debugging notes to comment on the sqlite3Show() family of interfaces. (check-in: 031fa7b401 user: drh tags: trunk)
2022-04-02
15:29
New update to the speed-size-graph spreadsheet. (check-in: 16354def56 user: drh tags: trunk)
2022-04-01
20:27
Update the speed-and-size spreadsheet with the latest 3.39.0 performance measurements. (check-in: 6846f208c0 user: drh tags: trunk)
20:22
Add the "Common Links" sidebar to the "Documentation" master page. (check-in: 9b0ae5e9c2 user: drh tags: trunk)
2022-03-30
18:01
Update the speed-and-size spreadsheet. (check-in: 2a0bdc4315 user: drh tags: trunk)
2022-03-27
00:22
Fix incorrect use of NULL instead of null in JSON function docs. (check-in: 9784cacc48 user: drh tags: branch-3.38)
2022-03-26
13:57
Version 3.38.2 (check-in: 04f27e4960 user: drh tags: release, branch-3.38, version-3.38.2)
2022-03-25
19:20
Slight improvement to the 3.38.2 change log. (check-in: e7727405a8 user: drh tags: branch-3.38)
18:49
Changes for the 3.38.2 release. (check-in: f12d809ff8 user: drh tags: branch-3.38)
2022-03-18
10:47
Start a change log for version 3.39.0. (check-in: 5f650fc6af user: drh tags: trunk)
2022-03-14
23:41
"pointer value" is a new keyword. (check-in: aa4661c0cc user: drh tags: trunk)
21:40
Move links from www.sqlite.org to just sqlite.org (check-in: e899092a4b user: drh tags: trunk)
21:37
Move pro-support links from hwaci.com to sqlite.org/com (check-in: a8bcf014c9 user: drh tags: trunk)
2022-03-12
13:54
We had a weird situation where some changes for 3.38.1 were put on a branch while others were put on trunk. Really, there are no 3.39.0-specific website changes yet, so just merge the original 3.38 branch into trunk and go off of trunk for now. We might resurrect the branch-3.38 later, if needed. (check-in: ad08759181 user: drh tags: trunk)
13:49
Version 3.38.1 (check-in: df74ea79fb user: drh tags: trunk, version-3.38.1)
2022-03-10
15:16
Update the target 3.38.1 release date to Saturday. (check-in: 8426043051 user: drh tags: trunk)
2022-03-08
09:51
Update the Bloomberg logo and hyperlink, by request. (Closed-Leaf check-in: d8b8a493e3 user: drh tags: branch-3.38)
04:57
Correct reference in "Run-Time Loadable Extensions to "xDlUnload". (check-in: 64447a456c user: larrybr tags: branch-3.38)
04:52
Correct reference in "Run-Time Loadable Extensions to "xDlUnload". (check-in: cceff0ed6f user: larrybr tags: trunk)
01:13
Do not use "n=all" on timeline links. (check-in: a3a4ebe3dd user: drh tags: branch-3.38)
01:12
Do not use "n=all" on timeline links. (check-in: bed0d03039 user: drh tags: trunk)
2022-03-07
15:31
Add the row value IN operator constraint processing fix for virtual tables to the change log for 3.38.1 (check-in: fd6f5c1aaa user: drh tags: trunk)
01:47
Update the speed-size spreadsheet with the latest performance numbers from the 3.39.0 alpha on trunk. (check-in: 4e072237ad user: drh tags: trunk)
2022-03-05
20:55
Initial changes for version 3.38.1. (check-in: 023fd6f1ac user: drh tags: trunk)
20:54
Add the new SNAPSHOT_BRANCH setting to the download.in page for better control over the timelines shown for the snapshot. (check-in: 36495ece12 user: drh tags: trunk)
20:43
Fix the LAST_MAJOR_RELEASE setting in the download.in source file. (check-in: a63581d358 user: drh tags: trunk)
2022-02-24
17:59
Add a note about CVE-2021-45346. (check-in: 08b046fb4d user: drh tags: trunk)
2022-02-23
09:40
Fix json examples as noted in forum (https://sqlite.org/forum/forumpost/f783a3f65a) (check-in: 5d05643c80 user: larrybr tags: trunk)
2022-02-22
19:03
Version 3.38.0 (check-in: 5c8c31e317 user: drh tags: trunk, release, version-3.38.0)
18:58
Add a news entry for the 3.38.0 release. (check-in: 7aae8a8c7d user: drh tags: trunk)
12:46
Update the speed-size spreadsheet with the latest figures from 3.38.0. (check-in: d4a95b0d10 user: drh tags: trunk)
2022-02-21
19:15
Change the binary size to 750KB. (check-in: 148b95505e user: drh tags: trunk)
13:17
Improvements to the 3.38.0 change log. (check-in: 858087e2ae user: drh tags: trunk)
2022-02-17
20:46
Merge changes from branch-3.37. (check-in: d28dd98076 user: drh tags: trunk)
20:46
Fix quoting of TCL code on the undoredo.html page. (check-in: 88dd77d488 user: drh tags: trunk)
20:45
Fix type on the Operators table of lang_expr.html. (Leaf check-in: b9e687671b user: drh tags: branch-3.37)
17:47
Fix formatting error on the undoredo.html page. (check-in: ac2b2fafd8 user: drh tags: branch-3.37)
10:04
Fix stray paren on lang_expr page (check-in: b106d4927c user: larrybr tags: trunk)
2022-02-16
14:48
New speed graph that only covers 2012 to 2023. (check-in: 6d7b7769b3 user: drh tags: trunk)
13:49
Fix a typo in the change log. (check-in: 5aa8d1cd13 user: drh tags: trunk)
2022-02-15
14:12
Omit the extra schema change warning associated with PRAGMA writable_schema. We reserve the right to reintroduce that warning later. (check-in: 76a5234d62 user: drh tags: trunk)
13:36
Merge version 3.37 fixes into trunk. (check-in: bd069c3808 user: drh tags: trunk)
13:32
Add the automatic disambiguation feature of .import to the change log. Change the "printf() SQL function" to "format()" in places. (check-in: d548c08378 user: drh tags: trunk)
00:09
s/DML/DDL/ in last checkin (check-in: b2bee1591b user: larrybr tags: trunk)
2022-02-14
23:42
Clarify that schema table modifiers are on their own. (check-in: 9601920175 user: larrybr tags: trunk)
2022-02-12
22:18
Fix minor typo in the howtocorrupt.html page. (check-in: f771c6937b user: drh tags: branch-3.37)
2022-02-11
19:46
Correct falsehood re binary ops and NULLs, and cover all cases. (strikable?) (check-in: dbb94aea6a user: larrybr tags: trunk)
17:04
Mention NULL effect on binary operators (check-in: cb57924a40 user: larrybr tags: trunk)
2022-02-09
20:03
Update the size and speed spreadsheet. (check-in: 61307ab42e user: drh tags: trunk)
13:46
Minor tweaks to the JSON documentation. (check-in: 7c47d9cb0c user: drh tags: trunk)
2022-02-08
19:56
Fix the pricing for tech support and consortium on the prosupport page. (check-in: 1b5da1569a user: drh tags: branch-3.37)
12:42
Merge in new-error-codes branch (check-in: 2514f40bb1 user: larrybr tags: trunk)
12:34
Remove an internal-only result code from API docs (Closed-Leaf check-in: 6e9f29aa01 user: larrybr tags: new-error-codes)
04:43
new error codes in place, but likely need some edits (check-in: 3d869f4463 user: larrybr tags: new-error-codes)
04:36
Create new branch named "new-error-codes" (check-in: 77218bb929 user: larrybr tags: new-error-codes)
2022-02-07
12:58
For CLI, unmention shebang (check-in: f93bdb7fba user: larrybr tags: trunk)
2022-02-05
12:57
Update the ALTER TABLE documentation and the change log for the new PRAGMA writable_schema=ON behavior of ALTER TABLE. (check-in: fa55f4fdba user: drh tags: trunk)
2022-02-03
16:10
Update CLI documentation to document recent changes. Add CLI enhancements to the change log. (check-in: ab56e8bea5 user: drh tags: trunk)
2022-02-02
20:05
Update the change log to provide a link to sqlite3_vtab_in(). (check-in: 7b3516c730 user: drh tags: trunk)
2022-01-29
22:27
Fix a link to the json virtual tables in the virtual table documentation. (check-in: 89ff423f8d user: drh tags: trunk)
22:20
Add documentation for the recent virtual table enhancements. (check-in: 3cca88e77e user: drh tags: trunk)
2022-01-28
19:28
Remedy off-by-1 error in how to keep Robson's n factor down. (check-in: 3618255733 user: larrybr tags: trunk)
17:19
Mention the new sqlite3_error_offset() interface in the change log. (check-in: 4891c7e52e user: drh tags: trunk)
13:33
Resolve English parsing ambiguity in Affinity of Expressions (check-in: b3ef2f0956 user: larrybr tags: trunk)
2022-01-27
15:08
Fix typo in the date/time function documentation: "data" should be "date". (check-in: 7f809741df user: drh tags: trunk)
13:52
Update requirements marks for date-time functions. (check-in: eaccf62910 user: drh tags: trunk)
12:42
Updates to requirements marks and wording of the date/time functions. (check-in: 0dbb181411 user: drh tags: trunk)
00:19
Note inexactitude of strftime() %J and %s format specifiers (check-in: 5fca4e2367 user: larrybr tags: trunk)
2022-01-26
15:41
Clarify that "Julian day number" need not be a "whole number" (check-in: 841107fc38 user: larrybr tags: trunk)
2022-01-25
20:21
Fix typo on expression operators table (check-in: cb8e7e8104 user: larrybr tags: trunk)
2022-01-24
20:42
Take CLI rules clarification from release branch (check-in: 2d8eaff57d user: larrybr tags: trunk)
20:32
Mention CLI's whole-line comment; prettify and clarify it's Rules; remove obsolete bug-avoidance in docsapp build (check-in: 48783c8d25 user: larrybr tags: branch-3.37)
2022-01-22
21:20
Swat grammar nit in last checkin. (check-in: e40159680c user: larrybr tags: trunk)
21:18
Swat grammar nit in last checkin. (check-in: 637d4a8808 user: larrybr tags: branch-3.37)
21:05
Take dot-command arg-parsing clarification (check-in: 978ca626bd user: larrybr tags: trunk)
20:55
Clarify dot-command argument parsing (check-in: a7d5cbe876 user: larrybr tags: branch-3.37)
18:30
Clarify .expert option noted in https://sqlite.org/forum/forumpost/745f7e63b3 (check-in: 7e61bb09e2 user: larrybr tags: branch-3.37)
18:22
Take .param set... clarification from trunk (check-in: adc3b9348f user: larrybr tags: branch-3.37)
18:12
In datatypes explication, correct example details and link to file format page. (check-in: b59c99c117 user: drh tags: branch-3.37)
17:02
Clarify .expert option noted in https://sqlite.org/forum/forumpost/745f7e63b3 (check-in: 72fd502948 user: larrybr tags: trunk)
2022-01-21
19:26
Add requirements marks to newer parts of the date/time documentation. (check-in: deb6d14033 user: drh tags: trunk)
2022-01-20
23:31
Grammar improvements where noted by https://sqlite.org/forum/forumpost/6712173dd2 (check-in: 921013da18 user: drh tags: branch-3.37)
21:38
Grammar improvements where noted by https://sqlite.org/forum/forumpost/6712173dd2 (check-in: 96d1781d44 user: larrybr tags: trunk)
2022-01-18
19:52
Take branch-3.37 CTE typo fix (check-in: 5ca5cda1eb user: larrybr tags: trunk)
2022-01-17
12:21
Fix minor typo in the CTE documentation. (check-in: 5c0f5a0a77 user: drh tags: branch-3.37)
2022-01-16
20:12
Clarify how schema may be passed into pragma functions (check-in: 0f053562cd user: larrybr tags: trunk)
07:37
Modernize even the straggler! (check-in: f475aa435d user: larrybr tags: trunk)
07:34
Modernize links in "Get the Code" page (check-in: 298f8d6df6 user: larrybr tags: trunk)
2022-01-14
17:39
Update and modernize docs for CLI's .import (check-in: 955f03c451 user: larrybr tags: trunk)
16:52
Correct CLI usage example noted by https://sqlite.org/forum/forumpost/e8bd8ea240 (check-in: f157179986 user: larrybr tags: trunk)
2022-01-13
12:27
For printf family, mention "*" as a precision spec (check-in: 8bd010d038 user: larrybr tags: trunk)
06:25
Improve example for .parameter set with quoted value (check-in: 109b40774c user: larrybr tags: trunk)
02:16
Clarify treatment of .parameter set values (check-in: cdd22f8ea0 user: larrybr tags: trunk)
2022-01-12
20:46
Minor grammar fix for JSON functions doc (check-in: f04d4fdb9b user: larrybr tags: trunk)
20:36
Add JSON "pointer" operators to the expression operator table (check-in: 6a5389b258 user: larrybr tags: trunk)
18:53
Fix typos in datefunc doc and clarify slightly (check-in: fa3813c824 user: larrybr tags: trunk)
2022-01-11
23:55
Update the change log with the latest features. (check-in: 7938669cbd user: drh tags: trunk)
23:39
Merge the branch-3.37 enhancements onto trunk. (check-in: 38e19dcd28 user: drh tags: trunk)
23:30
Merge the documentation changes for the -> and ->> operators. (check-in: acc42ce623 user: drh tags: trunk)
14:09
Update JSON documentation for the addition of the -> and ->> operators and because JSON functions are moved into the core. (Closed-Leaf check-in: f688a6b35c user: drh tags: json-in-core)
12:26
Enhance the documentation of json_extract() to point out the difference in behavior compared to MySQL. (check-in: cff708dfef user: drh tags: branch-3.37)
2022-01-08
21:36
In datatypes explication, correct example details and link to file format page. (check-in: ce5c357d29 user: larrybr tags: trunk)
2022-01-07
01:10
Fix a minor typo in the JSON function documentation. (check-in: 6757f3c805 user: drh tags: trunk)
2022-01-06
21:52
Updates to the 3.37.2 corruption bug description. (check-in: ff11d58c12 user: drh tags: branch-3.37)
13:29
Version 3.37.2 (check-in: 9fc107e8bf user: drh tags: branch-3.37)
2022-01-01
22:23
Expose %s/%z treatment of null poiners (check-in: 8d796ab3f3 user: larrybr tags: trunk)
2021-12-30
15:36
Version 3.37.1 (check-in: 205d900f14 user: drh tags: release, branch-3.37, version-3.37.1)
13:00
Incorporate all relevant documentation enhancements and fixes on trunk into branch-3.37. This shows up as a full merge, but some of the changes were backed out (ex: the improvements to date/time functions that do not appear in 3.37.1) before doing the commit. What remains are clarifications and typo fixes. (check-in: 4f7759af04 user: drh tags: branch-3.37)
11:55
Add a change log entry for 3.37.1. (check-in: aad83a5c97 user: drh tags: branch-3.37)
02:49
Amalgamation doc improvements (de-dupe, updates, grammar) (check-in: 0bb1d9172a user: larrybr tags: trunk)
2021-12-29
21:02
Fix a problem in an example of varint encoding in the fts3 docs. (check-in: bc7f18f221 user: dan tags: trunk)
2021-12-21
16:55
Fix to the description of how to verify a Fossil repository tarball. (check-in: b6b56980b0 user: drh tags: branch-3.37)
00:11
Fix atan2() doc per https://sqlite.org/forum/forumpost/faa3cd2ca1 (check-in: 6910fc8239 user: drh tags: branch-3.37)
2021-12-20
21:50
Fix atan2() doc per https://sqlite.org/forum/forumpost/faa3cd2ca1 (check-in: 0957672e28 user: larrybr tags: trunk)
15:06
Update the change log for 3.38.0. (check-in: 9cfef57af3 user: drh tags: trunk)
2021-12-17
23:57
Improved virtual table documentation. (check-in: fe558417b1 user: drh tags: trunk)
2021-12-13
15:03
Further refinements to the invalid utf document. (check-in: 6a87084235 user: drh tags: trunk)
14:25
Remove an extra bullet from text changes in the previous check-in. (check-in: 904f89a31e user: drh tags: trunk)
14:23
Refinements to the invalid UTF policy statement. (check-in: b3818cc3e3 user: drh tags: trunk)
14:00
Add the invalid UTF policy. (check-in: 7e0d4711f8 user: drh tags: trunk)
2021-12-12
22:55
fix 1-char typo per https://sqlite.org/forum/forumpost/dbd15b2206 (check-in: 99e87aed86 user: larrybr tags: trunk)
2021-12-10
14:23
STRICT and backup clarifications (check-in: da576ee96b user: larrybr tags: trunk)
2021-12-08
21:36
Clarify Backup API effect. (check-in: 2990899b02 user: larrybr tags: trunk)
20:56
Change the proposed release date of 3.38.0 to 2022-03-00 with a 00 date. (check-in: e09b8fd1f0 user: drh tags: trunk)
2021-12-06
14:57
During wrap processing, moan about problems near completion (not just on the fly.) (check-in: d77c6b76b2 user: larrybr tags: trunk)
01:48
Improve an example VFS usage in VFS doc (check-in: 5872d6d048 user: larrybr tags: trunk)
2021-11-30
14:49
Add a brief note to explain that a query that uses an automatic index is what other database engines might call a "hash join". (check-in: 9bb8566076 user: drh tags: trunk)
2021-11-29
18:52
First cut at improving the date/time function documentation to incorporate the new unixepoch() function and new modifiers. (check-in: 7b3c3b904e user: drh tags: trunk)
2021-11-27
14:18
Version 3.37.0 (check-in: 1595e46492 user: drh tags: trunk, release, version-3.37.0)
14:09
Merge 3.36.0 documentation enhancements into trunk. (check-in: 7953fb4e89 user: drh tags: trunk)
14:07
Add a news item for version 3.37.0. (check-in: 157a35795e user: drh tags: trunk)
2021-11-26
21:13
Minor spelling corrections. (check-in: 89f61d3ed7 user: drh tags: trunk)
14:04
Update the speed-size spreadsheet. (check-in: 071c9e56ed user: drh tags: trunk)
2021-11-20
13:21
Update the constraint documentation to clarify that constraints are checked during INSERT and UPDATE but not during query operations. See forum thread 47dae2beebf94254. (check-in: 23603e03cd user: drh tags: trunk)
12:38
Updates to the speed-size graph spreadsheet. (check-in: 40702937bb user: drh tags: trunk)
2021-11-17
15:30
Spelling fixups for Custom Builds (check-in: 708d7b3cda user: larrybr tags: trunk)
2021-11-10
19:19
Fix spelling in copyright page. (check-in: 34fef5908f user: larrybr tags: trunk)
2021-11-08
13:35
For CLI, say .dump produces UTF-8 (not ASCII) (check-in: 299986cb19 user: larrybr tags: trunk)
2021-11-05
20:03
Update the release date. Add mention of the SQLITE_OPEN_EXRESCODE option. (check-in: 551858fb43 user: drh tags: trunk)
2021-11-03
16:36
Remove a superfluous requirement mark from the STRICT documentation. (check-in: d9cb0ac27f user: drh tags: trunk)
2021-11-02
23:03
Bring CLI doc up to date, including new .archive options. (check-in: ce75cac3ba user: larrybr tags: trunk)
21:19
Clarify sqlite3_threadsafe() return in threadsafe.html. (check-in: fafb4edaa3 user: larrybr tags: trunk)
2021-11-01
21:09
Clarification of the meaning of STRICT. (check-in: d7050c6de3 user: drh tags: trunk)
2021-10-31
23:29
Add the sqlite3_autovacuum_pages() interface to the change log. (check-in: 9550cf29a1 user: drh tags: trunk)
2021-10-22
20:05
Correct result code SQLITE_MAX_SQL_LENGTH stated limit. (check-in: bc36b83f47 user: larrybr tags: trunk)
19:22
Add a note about CVE-2021-42169. (Leaf check-in: 9c2a89cd40 user: drh tags: branch-3.36)
2021-10-21
17:18
Update documentation on fuzzing. (check-in: 242615f039 user: drh tags: trunk)
2021-10-14
17:25
Fix a typo in requirement markup. Change the candidate release date for 3.37.0 to 2021-11-16. (check-in: 7da3b63866 user: drh tags: trunk)
2021-10-13
15:12
Remove SQLITE_OPEN_EXCLUSIVE from the change log. (check-in: 511bfd3675 user: drh tags: trunk)
2021-10-12
03:48
For CLI build examples, use -o to avoid some puzzlement. (check-in: a62b13320f user: larrybr tags: trunk)
2021-10-11
14:49
Combine duplicative CLI notes. (check-in: 93af46f150 user: larrybr tags: trunk)
04:27
Further detail --safe preclusions. (check-in: 531902c835 user: larrybr tags: trunk)
2021-10-08
17:02
Add documentation for "PRAGMA writable_schema=RESET". (check-in: 7cb21e6a2b user: drh tags: trunk)
2021-10-06
19:08
Fix all "TBD" marks in the qmplan.html document. This is not to say that the QM document is finished - much more detail could be added - but at least every major section now has *some* text. (check-in: 4e1cf8e022 user: drh tags: trunk)
17:40
Updates to the qmplan. (check-in: a0218a251d user: drh tags: trunk)
17:12
Grammar de-nit QM plan (check-in: c527df416c user: larrybr tags: trunk)
16:02
Grammatical de-nit (check-in: 2034fc7ee6 user: larrybr tags: trunk)
14:45
Add documentation for the .open command and the --safe option for the CLI. (check-in: 4e3774bc1f user: drh tags: trunk)
10:14
Fix typo in the sign() documentation. (check-in: 6a78846f93 user: drh tags: branch-3.36)
2021-10-05
18:01
Remove duplicative section number from Atomic Commit page. (check-in: 109c9a31c8 user: drh tags: branch-3.36)
17:51
Remove duplicative section number from Atomic Commit page. (check-in: 6ae3aa33a7 user: larrybr tags: trunk)
2021-10-01
14:35
Push the proposed release date for 3.37.0 back to 2021-12-01. Improvements to the change long and to the CLI documentation. There are TBDs in the CLI documentation that we need to return to before the release. (check-in: d67110f163 user: drh tags: trunk)
2021-09-29
16:36
Minor update to documentation of the custom rtree query API. (check-in: 44188b09f0 user: dan tags: trunk)
13:20
Merge fixes from the 3.36 branch into trunk. (check-in: 5c9ed197fb user: drh tags: trunk)
13:12
Do not try to index the context of <svg> markup for search. (check-in: 4e9e946291 user: drh tags: branch-3.36)
2021-09-28
17:15
Clarify use of xInverse method for windows functions (check-in: 7d1d0f2166 user: larrybr tags: trunk)
2021-09-27
23:42
Improve note on STRICT and de-nit ALTER TABLE overview (check-in: ab3009fd7c user: larrybr tags: trunk)
2021-09-24
23:48
Update the change log and the pragma documentation for the new table_list pragma. (check-in: 21477e3b60 user: drh tags: trunk)
00:28
Correct over-lenient delete ... order by limit syntax diagram. (Per https://sqlite.org/forum/forumpost/35b89409e5 ) (check-in: 0ab7d5fa06 user: larrybr tags: trunk)
2021-09-17
17:52
Add a section to the WITHOUT ROWID documentation that explains how to use the PRAGMA index_info command to distinguish between ordinary tables and WITHOUT ROWID tables. (check-in: 91c83c24c4 user: drh tags: trunk)
11:52
Add new requirement marks to the STRICT table documentation. Also fix a typo there. (check-in: 992b5d7660 user: drh tags: trunk)
2021-09-16
18:05
Correct a single requirement in the RTREE documentation. (check-in: 70af09cf7e user: drh tags: trunk)
2021-09-14
19:55
Typo fix in rtree documentation. (check-in: 13e88e4693 user: drh tags: trunk)
19:16
Fix some busted requirements marks in the EXPR documentation. Add the 64() suffix to sqlite3_changes and sqlite3_total_changes() in the SQL core function documentation. (check-in: a9ef8137bd user: drh tags: trunk)
18:27
RTree documentation fixes. (check-in: c2fe6c397b user: drh tags: trunk)
11:16
Scan ext/rtree/*.test for "evidence" marks. (check-in: 184fb42b4f user: dan tags: trunk)
2021-09-13
23:15
New requirements marks in rtree. (check-in: 50c0dfb34c user: drh tags: trunk)
23:06
Continuing improvement to the rtree documentation. (check-in: b253cfff16 user: drh tags: trunk)
19:22
New sample data for illustrating RTREE concepts. (check-in: 8b0f880b08 user: drh tags: trunk)
14:45
Minor fixes to the rtree documentation. (check-in: 39d61b00a3 user: drh tags: trunk)
12:01
Simplifications to the STRICT documentation. (check-in: 71c6908056 user: drh tags: trunk)
11:28
Remove three arguments about why SQLite is not coded in Rust or Go from the "whyc.html" document. (check-in: 74c43386e3 user: drh tags: branch-3.36)
2021-09-10
20:38
Documentation tweaks for RTREE and STRICT tables. Add many requirements marks to RTREE. (check-in: 9f2bb99cd2 user: drh tags: trunk)
2021-09-09
12:53
Update the CVE list with a new CVE that mentions SQLite but has nothing to do with SQLite. (check-in: e972ac344f user: drh tags: branch-3.36)
2021-09-08
19:01
Another typo fix - this time in datatype3.html. (check-in: 1d20e141ec user: drh tags: trunk)
18:52
Fix typo in the STRICT documentation. (check-in: 9f82e552fd user: drh tags: trunk)
2021-09-07
19:28
Clarify schema comparisons for sqldiff. Mention (new) --table sqlite_schema option. (check-in: 16ae2db841 user: larrybr tags: trunk)
2021-08-25
23:23
Change the cves.html document due to the fact that a correction and clarification to CVE-2021-36690 was received and implemented. (check-in: 78013d22aa user: drh tags: branch-3.36)
2021-08-24
21:13
Rename and tweak the "Advantages of Flexible Typing" document. (check-in: 6d8f3f7ffb user: drh tags: trunk)
19:48
Add CVE-2021-36690 to the list. (check-in: 0c07b234f9 user: drh tags: branch-3.36)
19:00
More improvements to datatype documentation. (check-in: d574ce1f35 user: drh tags: trunk)
14:31
First draft of a document defending flexible typing against its critics. (check-in: de16ee6a9e user: drh tags: trunk)
2021-08-23
10:35
Typo fixes. (check-in: c8e3641fb4 user: drh tags: trunk)
2021-08-22
22:48
Proposed new definition of STRICT tables. (check-in: 26a4727f29 user: drh tags: trunk)
2021-08-21
21:04
Fix a typo in the lemon.html documentation page. (check-in: 7d8e36e6eb user: drh tags: branch-3.36)
20:50
De-typo in Lemon doc (check-in: afc57c1161 user: larrybr tags: trunk)
2021-08-20
15:48
Initial documentation for STRICT tables. (check-in: a62eba124d user: drh tags: trunk)
15:27
First bits of documentation about STRICT tables. (Closed-Leaf check-in: 0b842e6e48 user: drh tags: strict-tables)
00:18
Document new STRICT table option (check-in: e668c1ce28 user: larrybr tags: strict-tables)
2021-08-12
10:50
Fix some grammar issues in fts5.in. (check-in: 053c63ecc5 user: dan tags: trunk)
2021-08-11
16:12
Further enhancements to fts5 shadow table data format documentation. (check-in: c5d7ec9a1d user: dan tags: trunk)
2021-08-10
21:18
Further enhancements for fts5 documentation. (check-in: 05ad966e28 user: dan tags: trunk)
2021-08-09
22:00
Begin documenting the fts5 on-disk format. (check-in: 018ff48a67 user: dan tags: trunk)
2021-08-06
22:22
Enhanced SELECT documentation: State explicitly that the value of a bare column in an aggregate query with no input rows is arbitrary. (check-in: cf8be0cd71 user: drh tags: trunk)
2021-08-01
21:40
For .expert command, indicate how to deal with schema using extension functions. (check-in: f1c94aeb9c user: larrybr tags: trunk)
2021-07-30
22:55
Address wee language nits in sqlite3_snprintf() history explication (check-in: f43c4eb1f1 user: larrybr tags: trunk)
2021-07-27
23:51
Bring FAQ on ALTER TABLE up to date (check-in: 9ea300daac user: larrybr tags: trunk)
2021-07-21
12:08
Update the ALTER TABLE ADD COLUMN documentation to discuss its new behavior of verifying CHECK and NOT NULL constraints against preexisting rows. (check-in: 3f4ef35f32 user: drh tags: trunk)
11:50
Add the change log for version 3.37.0. (check-in: ae09c6cd46 user: drh tags: trunk)
2021-07-19
17:02
For the download.html page, add the set the variable LAST_MAJOR_RELEASE directly. We'll have to change this manually with each release. (check-in: 759479fcf6 user: drh tags: trunk)
16:49
Improvements to the documentation on how to enforce required parameters to table-valued functions using SQLITE_ERROR returns from xBestIndex. (check-in: 234ddab3ec user: drh tags: trunk)
16:45
Improvements to the description of how to get good error messages out of xBestIndex for required table-valued function parameters. (Leaf check-in: f6864997ba user: drh tags: xbestindex-errors)
16:44
More precision in the description of operator precedence in the lang_expr.html page. (check-in: faee65e4fa user: drh tags: trunk)
16:36
Minor formatting enhancements to the new precedence description in the Expression documentation. (Closed-Leaf check-in: 43247e25e1 user: drh tags: operator_traits)
16:18
In operators table, colorize (as before). Zap a bad footnote ref. (check-in: 62be0ee30f user: larrybr tags: operator_traits)
02:08
Merge operator precedence/associativity clarifications/additions instigated by forum thread https://sqlite.org/forum/forumpost/b9902fe09a . (check-in: 5b3ed74e59 user: larrybr tags: trunk)
01:58
Op-prec partly reverted to get linkage working. (To be made more organized and coherent later.) (check-in: 11e0ea3d16 user: larrybr tags: operator_traits)
00:03
Operator precedence done, text revised to match, but 5 links broken. (check-in: bd8fb1f74f user: larrybr tags: operator_traits)
2021-07-18
17:27
In big expr railroad chart, make only LIKE get an ESCAPE clause. (check-in: 6fa8195610 user: larrybr tags: trunk)
01:27
reorg operator precedence/associativity/aryness, and for more of them (check-in: 71f8627b5c user: larrybr tags: operator_traits)
2021-07-16
17:20
Update the generate_series() documentation to show that the first argument is now required. Enhance the virtual-table documentation to explain in detail how to construct an xBestIndex method that forces some arguments to a table-valued function to be required. (check-in: 3008d3fbc2 user: drh tags: trunk)
2021-07-15
16:18
Revise TCL integration. (cleaner) Prepare for tool and extension detail doc. (check-in: b6057aff5f user: larrybr tags: cli_extension)
04:48
More on TCL, both as extension and another execution option. (check-in: 1fadb0c3ad user: larrybr tags: cli_extension)
2021-07-14
20:57
Create predecssor of shell extensibility doc. (check-in: a01e599239 user: larrybr tags: cli_extension)
01:18
Restore accidental delete of deprecated compile option. (check-in: 97db38da0c user: larrybr tags: trunk)
01:11
Correct ancient typo, correct interface function macro exclusiveness assertion (check-in: 3341553596 user: larrybr tags: trunk)
00:33
Update 'Compiler ... Control' section in 'Compile-time Options' (check-in: 466497f575 user: larrybr tags: trunk)
2021-07-05
12:14
Add the word "the" into the title "defense against the dark arts". (check-in: 5b06972cc9 user: drh tags: trunk)
2021-06-30
19:14
Revise HTLM comment CSV table and document it. (check-in: 6260f34689 user: larrybr tags: trunk)
2021-06-28
22:32
Shed extranous div close tag. (check-in: eec2c7dec4 user: larrybr tags: trunk)
2021-06-26
21:20
Add an HTML comment to the download.html page that is easy for scripts to read and extract build product names and metadata. (check-in: a5c082a634 user: drh tags: trunk)
2021-06-23
17:42
Document SQLITE_ENABLE_NORMALIZED option. (check-in: 49eb960b86 user: larrybr tags: trunk)
2021-06-21
04:46
Conform sqlite_parameters schema to implementation. (check-in: 458aa9aa0a user: larrybr tags: trunk)
03:17
Correct name of lsmode() (check-in: 500fb25afc user: larrybr tags: trunk)
2021-06-18
18:45
Version 3.36.0 (check-in: 1207f6c70f user: drh tags: trunk, release, version-3.36.0)
18:34
Add a news item for the 3.36.0 release. (check-in: bcdc3680a5 user: drh tags: trunk)
13:44
Merge the wapp.tcl fix. (check-in: dd65eef797 user: drh tags: trunk)
13:43
Update the built-in copies of wapp.tcl to the latest version that fixes the backslash problem reported by SQLite forum post 8fb639b5ad. (Leaf check-in: a92de28e5e user: drh tags: branch-3.35)
2021-06-17
22:41
Update the speed and size spreedsheet. (check-in: 4b2bf80ec6 user: drh tags: trunk)
16:11
Fix typos in recent changes. (check-in: 340f253778 user: dan tags: trunk)
2021-06-15
13:15
Bring CLI command list up to date. (check-in: 03b21f389f user: larrybr tags: trunk)
2021-06-12
18:40
Merge 3.35 fixes into trunk. (check-in: 01f903cf1a user: drh tags: trunk)
18:32
Fix the expression syntax diagram. DISTINCT is not required for the first argument of a function. (check-in: 12118bdbb8 user: drh tags: branch-3.35)
2021-06-11
16:58
Update the built-in Pikchr formatter to the latest version that includes support for alternative spellings for "<-" and "->" tokens. Make use of this new feature to omit "<" characters from embedded Pikchr text on documentation pages. (check-in: 5a0eb23b3e user: drh tags: trunk)
2021-06-10
19:09
Add new text to queryplanner-ng.html to talk about the newer and better approach to query optimization in Fossil using PRAGMA optimize. (check-in: 31f540fa7a user: drh tags: trunk)
18:46
Also convert the second diagram in queryplanner-ng.html into Pikchr. (check-in: 7684d973c9 user: drh tags: trunk)
17:28
Convert the TPC-H Q8 diagram from a GIF into PIKCHR. (check-in: e484b8b83a user: drh tags: trunk)
00:24
Merge in fixes from branch-3.35. (check-in: a91ad6f8ef user: drh tags: trunk)
2021-06-07
23:44
Extend the discussion of the minimum precision for printf() to the compilation options document. (check-in: 97d7ef69b6 user: drh tags: branch-3.35)
23:33
Raise the recommended security value for SQLITE_PRINTF_PRECISION_LIMIT from 1000 to 100000, as this limit also limits the maximum size of a CREATE statement. (check-in: f3fa151b44 user: drh tags: branch-3.35)
00:42
Fix a typo in the printf() documentation. (check-in: 7127279460 user: drh tags: trunk)
2021-06-04
00:59
Update the change log for 3.36.0 (check-in: eedf040d0d user: drh tags: trunk)
2021-06-03
20:37
Update the estimated number of cellphones. (check-in: e3af443deb user: drh tags: trunk)
2021-06-02
14:34
Amplify the warning about mixing affinities in a compound SELECT by giving that paragraph its own heading and by adding a link to the recent bug report that was caused by this indeterminacy. (check-in: 3de5232216 user: drh tags: branch-3.35)
14:18
Add a #fragment anchor to the paragraph on compound view affinities. (check-in: 9653e63b4c user: dan tags: branch-3.35)
2021-05-25
16:27
Cherrypick vtable xBestIndex to xFilter communication clarification. (check-in: 5c67f4e57d user: larrybr tags: branch-3.35)
16:22
Clarify vtable xBestIndex to xFilter communication. (check-in: 495a1efae0 user: larrybr tags: trunk)
2021-05-21
00:17
Fix the "addtoc" TCL routine that adds a table-of-contents to each document so that it passes through SVG unchanged. This fixes the display of the geopoly documentation. (check-in: 55abd1c581 user: drh tags: trunk)
2021-05-17
18:22
Mention the improvement to the constant-propagation optimization in the change log. (check-in: 563e46304a user: drh tags: trunk)
2021-05-12
15:48
Update the 3.36.0 change long with the memdb VFS enhancement. (check-in: 5f66fbfc54 user: drh tags: trunk)
2021-04-28
05:08
Cherry pick add materialization hints to CTE syntax chart. (check-in: 01fdd97047 user: larrybr tags: branch-3.35)
04:35
Add materialization hints to CTE syntax chart. (check-in: 5d087a7e27 user: Larry tags: trunk)
2021-04-27
19:34
The "window-defn" on the syntax diagrams for select-core and select-stmt should be a box, not an oval, because it has substructure. (check-in: b57f867fa6 user: drh tags: branch-3.35)
2021-04-24
12:38
Add a bullet about the BOM enhancement to the change log. (check-in: 469332939f user: drh tags: trunk)
2021-04-23
13:15
Merge in the latest branch-3.35 changes. (check-in: 1545c4fd49 user: drh tags: trunk)
2021-04-22
11:54
Clarify some of the language on the copyright page. (check-in: dc3302e267 user: drh tags: branch-3.35)
2021-04-19
18:36
Version 3.35.5 (check-in: 2bca055d13 user: drh tags: branch-3.35)
2021-04-16
18:10
Mention CVE-2021-28305 in the CVE list, even though the bug is in third-party software, because SQLite is mentioned by name in CVE description. (check-in: ff1c5e57dc user: drh tags: branch-3.35)
2021-04-13
18:51
Provide a link to the GitHub mirror from the download.html page. (check-in: 025ff9e6c2 user: drh tags: branch-3.35)
17:26
Correct minor CLI doc discrepencies mentioned at https://sqlite.org/forum/forumpost/e6ba917f72 . (check-in: f63662814c user: larrybr tags: branch-3.35)
2021-04-12
21:18
Document result column selection via integer constants in GROUP BY. (check-in: 78d2dd4520 user: larrybr tags: branch-3.35)
2021-04-11
20:03
Omit the code of conduct and code of ethics from the FTS index, to make them harder for haters to find. (check-in: 247c8e7c25 user: drh tags: branch-3.35)
2021-04-07
17:45
State CLI shell's argument parsing and quoting rules. (check-in: f0f68ff272 user: larrybr tags: branch-3.35)
17:33
Attempt to fix a typo in search. (check-in: 809cbde355 user: drh tags: branch-3.35)
11:02
Typo fix in privatebranch.html. (check-in: 73f166efb9 user: drh tags: branch-3.35)
2021-04-05
22:58
Insert a rebuttal of the grossly exaggerated impact of CVE 2021-20227. (check-in: db3d49b2a7 user: drh tags: branch-3.35)
2021-04-02
16:19
Mention piped source option for .import command. (check-in: 3a66d34730 user: larrybr tags: branch-3.35)
15:31
Enhancement to the RETURNING documentation. (check-in: 9f935a41c1 user: drh tags: branch-3.35)
15:30
Version 3.35.4 (check-in: 6f6f2ff5ee user: drh tags: branch-3.35)
2021-04-01
18:24
Mention piped source option for .import command. (check-in: 7652db76ff user: larrybr tags: trunk)
2021-03-31
17:25
Fix a typo on the frame-spec.pikchr syntax diagram. (check-in: 3617d4f844 user: drh tags: branch-3.35)
2021-03-26
18:29
Merge the documentation updates on the 3.35 branch into trunk. (check-in: da382790f1 user: drh tags: trunk)
18:25
Clarification of the harm statement of CVE-2021-20227. (check-in: 178512ed42 user: drh tags: branch-3.35)
12:19
Version 3.35.3 (check-in: 62dcfe1803 user: drh tags: release, branch-3.35, version-3.35.3)
2021-03-23
20:19
Revise the EXPLAIN QUERY PLAN documentation to conform to the new output format. (check-in: e2da609e66 user: drh tags: trunk)
20:08
Add an entry for CVE 2021-20227 to the vulnerabilities page. (check-in: 2706ba81b8 user: drh tags: branch-3.35)
20:02
Begin recording changes for the 3.36 development cycle. (check-in: 39e6c41006 user: drh tags: trunk)
19:57
Changes associated with 3.35 patches. (check-in: 0e56b31f8c user: drh tags: branch-3.35)
2021-03-22
14:12
Proposed changes for the 3.35.3 patch release. (check-in: a1325c8133 user: drh tags: trunk)
01:28
Clarity tweaks to FROM clause diagrams. (check-in: 53e9fbe353 user: larrybr tags: trunk)
00:46
Add join-clause into empty FROM clause list path of SELECT syntax diagrams. (check-in: 53a0a96734 user: larrybr tags: trunk)
2021-03-17
21:11
Discussion of the bug fix to non-deterministic date/time functions. (check-in: e315d802ed user: drh tags: trunk)
20:00
Record the check-in and date for 3.35.2 in chronology.in. (check-in: d8f7573d12 user: drh tags: trunk)
19:08
Version 3.35.2 (check-in: d935787014 user: drh tags: trunk, release, version-3.35.2)
2021-03-15
17:13
Update the SQLITE_SOURCE_ID value in the changelog for version 3.35.1. (check-in: f030340c31 user: dan tags: trunk, release, version-3.35.1)
17:04
Version 3.35.1 (check-in: ce12450bbd user: drh tags: trunk)
12:20
Fix the keyword list to include MATERIALIZED and RETURNING. (check-in: 83dcb37d7f user: drh tags: trunk)
2021-03-12
23:40
Adjust the omitted.html page to indicate that DROP COLUMN is now supported. (check-in: 6400fd54e4 user: drh tags: trunk)
15:17
Version 3.35.0. (check-in: 8cce67de75 user: drh tags: trunk, release, version-3.35.0)
2021-03-11
21:42
Update the speed-size spreadsheet. (check-in: bcb11bed7e user: drh tags: trunk)
2021-03-09
22:03
Clarify the operation of the trunc() function. (check-in: fc350731cd user: drh tags: trunk)
2021-03-05
18:34
Update the change log to mention that SQLITE_DBCONFIG_ENABLE_VIEW now allows TEMP views, by analogy to the SQLITE_DBCONFIG_ENABLE_TRIGGER change. (check-in: de7d1ae0cd user: drh tags: trunk)
14:54
Minor documentation updates. (check-in: 32a238d5ca user: drh tags: trunk)
2021-03-04
18:48
Fixes to docapp. Improvements to the makefile. (check-in: 07cd8ab1c0 user: drh tags: trunk)
18:43
Minor comment fix in testing.in. (check-in: d74da90907 user: drh tags: trunk)
18:38
Temporary work-around for sqlite3 shell bug. (.ar -c with sqlite3 -append fails.) (Closed-Leaf check-in: 9fb7386101 user: larrybr tags: build_de-nit)
00:53
For pragma encoding doc, indicate how the default encoding is determined. (check-in: ee3112fbee user: larrybr tags: trunk)
2021-03-03
14:21
Cure contradiction regarding table content alteration. (check-in: e59b0c2241 user: larrybr tags: trunk)
13:53
Clarify check constraint interaction with column drop. (check-in: 61dec51655 user: larrybr tags: trunk)
2021-03-02
16:57
Mention atanh(), too. (check-in: a7b0387a7d user: larrybr tags: trunk)
16:27
Fix some grammar, improve clarity, correct mathematical nits. (check-in: 4ee13c6f67 user: larrybr tags: trunk)
01:56
Get docsapp to work (again), faster, with some --help output. More cleanup degrees. (check-in: 9b916b865b user: larrybr tags: build_de-nit)
2021-03-01
18:08
In how-to-compile, add -lm to gcc builds (because math functions are in by default.) (check-in: a70b2f3fc2 user: larrybr tags: trunk)
16:42
Formatting detail on the change log. (check-in: bb8f139f8e user: drh tags: trunk)
15:44
Improvements to the change log. (check-in: a587c167b5 user: drh tags: trunk)
14:24
Enhancements to the testing.html document. (check-in: c39ee51720 user: drh tags: trunk)
12:57
Merge AS MATERIALIZED documentation enhancements. (check-in: 87a0f4972f user: drh tags: trunk)
12:55
Fix broken link to the mailing list. Replace it with a link to the forum. (check-in: 2974911cfa user: drh tags: trunk)
12:52
Clear up docapp dir/app collision, speed caret removal and make it portable. (check-in: 64789d0218 user: larrybr tags: build_de-nit)
12:43
Create new branch named "build_de-nit" (check-in: 43b2a0c1fc user: larrybr tags: build_de-nit)
2021-02-28
18:41
Typo fix, plural to possessive. (check-in: d9df475a24 user: larrybr tags: trunk)
2021-02-26
21:00
Provide a "Search" feature on the "docs.html" page. This is the same as the search feature from the Search menu item, but is in the user's face rather than requiring the user to find the "Search" button. (check-in: 7f769c42ba user: drh tags: trunk)
2021-02-25
14:48
Clarify: [NOT] MATERIALIZE is a hint, not a dictate. (Closed-Leaf check-in: a0fb8ec14b user: larrybr tags: as-materialized-redux)
05:41
Fixed min/max scalar/aggregate confusion reported at https://sqlite.org/forum/forumpost/7b60ca0b85 . This was an obvious error with knarly causation and a somewhat less knarly solution. (check-in: dd7fe37832 user: larrybr tags: trunk)
2021-02-24
12:48
Update obsolete hash type for sqlite_source_id() function. (Flagged by Mr. Beal.) (check-in: 94c9aa9fe9 user: larrybr tags: trunk)
2021-02-22
15:59
Merge the materialization hint documentation to trunk. (check-in: 9fc8e65396 user: drh tags: trunk)
15:27
Documentation on the materialization hints. (check-in: 01faf091f4 user: drh tags: as-materialized-redux)
2021-02-21
12:53
Fix typos and missing items in the change log for 3.35.0 (check-in: e029a818bd user: drh tags: trunk)
2021-02-19
14:47
Merge typo fixes from the 3.34 branch. (check-in: 23825af9b8 user: drh tags: trunk)
14:28
Clarification of the DROP COLUMN restrictions. (check-in: e79dca4a51 user: drh tags: trunk)
14:17
Add documentation for ALTER TABLE DROP COLUMN. (check-in: 9682d5370f user: drh tags: trunk)
2021-02-17
13:13
Typo fix and clarification on the description of the ".width" argument in the CLI. (Leaf check-in: fdb416d609 user: drh tags: branch-3.34)
2021-02-12
20:43
Merge updates to "SQLite Over a Network" doc and related tweaks. (check-in: e721bf01af user: larrybr tags: trunk)
19:05
Mention NFS fsync() issues in How To Corrupt ... section. (Closed-Leaf check-in: 518e2ac357 user: larrybr tags: use_over_network)
02:17
Spell checker should have been run. 3 mispellings fixed. (check-in: 17cdffda9b user: larrybr tags: use_over_network)
00:39
Prolixity reduction, 10.0% by word count. "ACID" is now in indices. (check-in: 7b6ddd6c57 user: larrybr tags: use_over_network)
2021-02-11
18:21
New target, doc/<whatever>.html , for speedy, single docpage development. (Leaves red links now.) (Leaf check-in: 45149b39ce user: larrybr tags: faster_make)
18:12
Create new branch named "build_streamline" (Leaf check-in: 8438309f9a user: larrybr tags: build_streamline)
2021-02-10
11:43
Create new branch named "faster_make" (check-in: aa700e13d1 user: larrybr tags: faster_make)
11:24
Merge typo fix from the 3.34 branch. (check-in: a85f388e6c user: drh tags: trunk)
11:12
Merge the new "useovernet.in" document and enhancements to "sqldiff" documentation. (check-in: 8cc6798f37 user: drh tags: trunk)
04:38
Add a page on issues associated with DB access over a network filesystem. (check-in: c9703f6dd4 user: larrybr tags: use_over_network)
2021-02-09
15:31
Create new branch named "use_over_network" (check-in: fc8de90ffc user: larrybr tags: use_over_network)
00:10
Modify sqldiff docs to mention empty --changeset output for certain rowid-hidden and PK-less tables. (Closed-Leaf check-in: 1b2ddbe529 user: larrybr tags: sqldiff_changeset)
2021-02-08
23:37
Create new branch named "sqldiff_changeset" (check-in: 25a3db0d3c user: larrybr tags: sqldiff_changeset)
13:46
Relax the subquery naming restriction on RETURNING clauses, due to enhancements added to the core code. (check-in: 9b1da78091 user: drh tags: trunk)
2021-02-06
15:33
Fix typo: "INDEX BY" should be "INDEXED BY" (check-in: 2aa06b0fc1 user: drh tags: branch-3.34)
2021-02-05
18:06
Update the RETURNING documentation to define the processing order. (check-in: 1d12f68d85 user: drh tags: trunk)
2021-02-04
23:29
Update the Forwards Compatability warning on RETURNING to reflect the change of implementation. (check-in: dab7baa72a user: drh tags: trunk)
2021-02-03
16:09
Merge fixes from the 3.34 branch. (check-in: 0bb116294e user: drh tags: trunk)
16:07
Merge the RETURNING changes. (check-in: bcc98c0be1 user: drh tags: trunk)
01:12
Add the SQLITE_DBCONFIG_ENABLE_TRIGGER change to the change log. Updates to the RETURNING documentation. (Closed-Leaf check-in: e95fde2606 user: drh tags: returning)
2021-02-02
21:04
Update docs to indicate that SQLite does detect and error-out of aggregates in a RETURNING clause. Also fix a typo. (check-in: 939b7340fb user: drh tags: returning)
18:33
Forwards compatibility statement on RETURNING. (check-in: 6b4d4d38c1 user: drh tags: returning)
15:06
More refinement of RETURNING documentation. Trying to make it more precise and cover all possible angles. (check-in: a77c85bf1c user: drh tags: returning)
14:20
More detail in the RETURNING documentation. (check-in: da6e56a86c user: drh tags: returning)
12:11
Preliminary documentation for RETURNING. (check-in: faa8501a4a user: drh tags: returning)
2021-02-01
21:53
Add the RETURNING clause to the UPDATE/DELETE statements with LIMIT. (check-in: d3182cdbb6 user: drh tags: returning)
19:25
Typo fix and clarification to PRAGMA analysis_limit. (check-in: f8e651e0eb user: drh tags: branch-3.34)
19:20
Update the DELETE, INSERT, and UPDATE syntax diagrams to show the RETURNING clause. Still need to do delete-stmt-limited and update-stmt-limited. (check-in: fc9711b569 user: drh tags: returning)
13:50
Add a syntax diagram for the RETURNING clause. (check-in: afce2544ec user: drh tags: returning)
13:25
Merge changes from the 3.34 branch. (check-in: 4b3068b294 user: drh tags: trunk)
2021-01-28
19:22
Fix typo in the CREATE TABLE documentation. (check-in: 193ce12863 user: drh tags: branch-3.34)
14:42
Update links to show all changes since the last *major* release. (check-in: e17f14a170 user: drh tags: branch-3.34)
14:38
Tighten up the language and simplify the why-not-git document. (check-in: cc3966e34b user: drh tags: branch-3.34)
2021-01-27
19:46
Merge changes from the 3.34 branch. Add mentions to two significant bug fixes in the change log. (check-in: d0fe9d2144 user: drh tags: trunk)
19:36
Rig the description of the "Prerelease Snapshot" to show a timeline back to the last release that ends with ".0". (check-in: dcfd7f1ba5 user: drh tags: branch-3.34)
2021-01-20
14:14
Version 3.34.1 (check-in: 792e30d4b7 user: drh tags: branch-3.34)
2021-01-18
13:20
Update the change log to show the latest enhancements. (check-in: e242010054 user: drh tags: trunk)
2021-01-16
12:18
The links to the forum on the support page changed to go directly to the list of recent threads. (check-in: fffcdce8f1 user: drh tags: branch-3.34)
2021-01-04
00:51
Merge enhancements from the 3.34 branch. (check-in: 75f07e5d08 user: drh tags: trunk)
00:49
If a missing "expr" box on the unary-operator branch of the expr syntax diagram. SQLite forum post 866a754699 (check-in: 8164556750 user: drh tags: branch-3.34)
2020-12-31
18:16
Better hyperlink on whynotgit.html - makes use of the new df= query parameter on the Fossil /timeline. (check-in: a300cc936e user: drh tags: branch-3.34)
2020-12-30
14:24
Merge 3.34 documentation improvements to trunk. (check-in: db10f6fcd3 user: drh tags: trunk)
14:10
Minor improvements to the why-not-git page. (check-in: dfa59a0c91 user: drh tags: branch-3.34)
2020-12-24
12:30
Update the upper size limit of an SQLite database in the When To Use document. (check-in: c19bcbed55 user: drh tags: branch-3.34)
2020-12-21
13:18
Clarification of the conflict resolution on a DO UPDATE clause. (check-in: 3f5013ed32 user: drh tags: branch-3.34)
2020-12-18
13:14
Fix typo in optoverview.html (check-in: a10f56ec91 user: drh tags: branch-3.34)
2020-12-17
23:48
Fix typos in SQL in the optoverview.html. (check-in: daa9d19197 user: drh tags: branch-3.34)
2020-12-16
23:14
Merge 3.34 enhancements into trunk. (check-in: 49bd6aaecf user: drh tags: trunk)
23:13
Editorial changes to the optoverview.html document. (check-in: 0b0f215c92 user: drh tags: branch-3.34)
2020-12-14
15:44
Merge date/time function clarifications from branch-3.34. (check-in: f80d76cbb1 user: drh tags: trunk)
15:02
Merge the UPSERT enhancements. Update the change log. (check-in: 9d0d26d35f user: drh tags: trunk)
2020-12-13
19:57
Update the date/time function documentation to avoid the use of the term "time string", which is confusing to some readers. (check-in: 733790e205 user: drh tags: branch-3.34)
2020-12-10
10:53
Fix a typo in cksumvfs documentation. (check-in: 25de4c7f3d user: dan tags: trunk)
2020-12-08
15:30
Documentation for the proposed generalizations to UPSERT. (Closed-Leaf check-in: d7320caafa user: drh tags: generalized-upsert)
2020-12-07
23:55
Start the change log for the next release. Add documentation for the math functions. (check-in: 6654cf2187 user: drh tags: trunk)
21:29
Create new branch named "branch-3.34" (check-in: c3fb1b50b1 user: drh tags: branch-3.34)
14:28
Two years post-controvery, the code of conduct and code of ethics documents are updated to provide a more accurate history of the provenance. (check-in: 59de622500 user: drh tags: trunk)
2020-12-03
15:34
Add text to clarify the behavior of hex() when given a numeric argument. (check-in: 2fe27dbb3a user: drh tags: trunk)
2020-12-02
18:42
Fix typos in the sqlar.html document. (check-in: ed88ac665a user: drh tags: trunk)
17:35
Fix typo in the 3.34.0 change log. (check-in: dec6418c71 user: drh tags: trunk)
2020-12-01
19:58
Added emphasis on the fact that SQLite database files are stable across platforms, architectures, and SQLite releases. (check-in: 6f789b6989 user: drh tags: trunk)
16:18
Version 3.34.0 (check-in: 7543902bc1 user: drh tags: trunk, release, version-3.34.0)
14:20
Move the althttpd webserver source code into its own source repository. (check-in: 3f4ac9a6bf user: drh tags: trunk)
2020-11-30
18:55
Initial News post for version 3.34.0 (check-in: db957ad9f6 user: drh tags: trunk)
18:21
Update the speed-and-size spreadsheet. (check-in: 80c49a4955 user: drh tags: trunk)
2020-11-26
21:15
Fix a typo in the cli.html document. (check-in: 40ae2b975d user: drh tags: trunk)
2020-11-25
18:23
Remove obsolete GIF syntax diagram processing logic (check-in: 77e66d0f02 user: drh tags: trunk)
13:10
Clarify the differences between xFindFunction and xBestIndex with regard to handling the argument swapping behavior of LIKE, GLOB, REGEXP, and MATCH. See forum post 9440862379. (check-in: 2d468b65df user: drh tags: trunk)
2020-11-24
23:40
Fix typos. (check-in: 89ad8f9c2c user: drh tags: trunk)
2020-11-23
14:55
Allow substring() as an alias for substr(). (check-in: 33b7cf7178 user: drh tags: trunk)
2020-11-19
16:35
Fix some errors in the window functions documentation. (check-in: 29a58418bc user: dan tags: trunk)
2020-11-18
14:36
Fix a hyperlink in the carray documentation. (check-in: 46262280d2 user: drh tags: trunk)
2020-11-17
15:09
Add documentation for the single-argument variant of carray. Fix a broken hyperlink in rescode.in. (check-in: 8ac0887660 user: drh tags: trunk)
2020-11-16
12:03
Merge changes from the 3.33 branch. (check-in: 8bdbb88c52 user: drh tags: trunk)
2020-11-15
13:16
In althttpd.c, fix a potential NULL ptr dereference following a CGI that returns an empty string. (check-in: c1e08a3709 user: drh tags: trunk)
2020-11-09
13:42
Update the rescode.html document with recently added result codes. (check-in: c57bdcc203 user: drh tags: trunk)
2020-11-02
14:01
Clarify wording of recursive CTE documentation. (check-in: 6dc65b8b9b user: drh tags: trunk)
2020-10-31
19:26
Add the addition of --tabs to the change log. (check-in: 56c9757fd3 user: drh tags: trunk)
14:46
Put a public domain notice on the althttpd.c file. (check-in: 46a8eeecdf user: drh tags: trunk)
2020-10-23
16:07
Add semrushbot to the list of disallowed user agents in althttpd.c. (check-in: 6da69d0669 user: drh tags: trunk)
2020-10-21
04:40
Fix typos in lang_with.html (check-in: 1e7aae0b46 user: drh tags: trunk)
2020-10-20
19:05
Enhance the "timeline" link on the prerelease snapshot to use the p= and bt= query parameters in order to see all branches that have contributed to the build product. (Leaf check-in: 6346afca54 user: drh tags: branch-3.33)
18:58
Fix typos and improve wording in release notes. (check-in: 470ac01c42 user: drh tags: trunk)
2020-10-19
13:20
Document the ability to use a compound SELECT for the recursive portion of a recursive CTE. (check-in: 92cd57163d user: drh tags: trunk)
2020-10-14
19:14
Update the change log for 3.34.0 (check-in: ecc48e8715 user: drh tags: trunk)
2020-10-13
15:50
Minor tweaks to the whynotgit document. (check-in: d9a09974a2 user: drh tags: trunk)
2020-10-11
01:24
Remove a test file accidentally committed. (check-in: 8ded4bd270 user: drh tags: trunk)
2020-10-09
15:05
Merge changes from the 3.33 branch. (check-in: 57b76a1da9 user: drh tags: trunk)
15:02
Update the purchase options to the new purchase scripts. (check-in: 5ca88ff9db user: drh tags: branch-3.33)
2020-10-05
17:03
When building the full-text index, ignore <svg> blocks. (check-in: dd8aef912e user: dan tags: trunk)
16:42
Add documentation for the new experimental fts5 tokenizer "trigram". (check-in: a1963591a6 user: dan tags: trunk)
2020-10-04
00:24
Clarifications on the behavior of the NUMERIC affinity and on the affinity of result columns in compound SELECT statements. (check-in: b19a0e3fa8 user: drh tags: trunk)
2020-10-02
15:55
Merge 3.33 documentation fixes into trunk. (check-in: 04cbabd493 user: drh tags: trunk)
15:51
Fix typos in the floatingpoint.html document. (check-in: 103f72eade user: drh tags: branch-3.33)
15:47
Fix typos in the floatingpoint.html document. (check-in: 1d1c9d7ad7 user: drh tags: trunk)
2020-10-01
20:13
Enhance the renderer so that any Pikchr source text with <pikchr>...</pikchr> is automatically converted into SVG. (check-in: 15b15f7ace user: drh tags: trunk)
19:39
Add the ability to translate Pikchr text to the TCL interpreter used to build the website. Omit all of the *.svg files from the check-in because they are now generated at compile-time directly from the *.pikchr files. All SVG is inline instead of being in separately loaded files. (check-in: 64e6c50273 user: drh tags: trunk)
18:23
Put all of the syntax diagrams in-line rather than loading them as separate files. (check-in: 285efd6656 user: drh tags: trunk)
2020-09-30
12:16
Fix typos in the arch.html document. (check-in: b6873d1f98 user: drh tags: branch-3.33)
2020-09-27
11:54
Fix typo in famous.html (check-in: 9013ecdf63 user: drh tags: branch-3.33)
2020-09-26
22:45
Update the FAQ to describe the new syntax diagram technology. (check-in: 2966044012 user: drh tags: trunk)
22:31
Generate syntax diagrams using Pikchr (check-in: 9f5383c824 user: drh tags: trunk)
22:29
Create a TCL script that converts all *.pikchr files into *.svg files and constructs syntax_linkage and syntax_order. Clean up legacy. (Closed-Leaf check-in: c877e0ff4a user: drh tags: svg-syntax)
2020-09-25
17:27
Fix syntax diagram linkage so that it always goes to SVGs, never to GIFs. (check-in: 2280617160 user: drh tags: svg-syntax)
16:45
Remove the old Tk script for generating syntax diagrams. Patch up the Makefile. Still to do:
  1. Automate generation of the syntax_linkage.tcl file
  2. Include pikchr source code in the source tree
  3. README.md file explaining how to implement the syntax diagram pikchr scripts and how to build the SVG files
  4. Improve some of the existing diagrams
(check-in: ec5c7e80fa user: drh tags: svg-syntax)
16:39
Last three GIFs converted. (check-in: 05c85f544f user: drh tags: svg-syntax)
16:17
upsert-clause, vacuum-stmt, and window-definition (check-in: c864439cba user: drh tags: svg-syntax)
15:23
type-name, update-stmt, and update-stmt-limited (check-in: 9d6aaa6c11 user: drh tags: svg-syntax)
13:03
table-or-subquery (check-in: 1776394058 user: drh tags: svg-syntax)
2020-09-24
20:53
table-constraint (check-in: 34d929e01e user: drh tags: svg-syntax)
14:37
sql-stmt-list (check-in: 8f63a61ff7 user: drh tags: svg-syntax)
14:24
sql-stmt (check-in: 7ea65ac585 user: drh tags: svg-syntax)
13:46
simple-function-invocation and simple-select-stmt. (check-in: 305dc14430 user: drh tags: svg-syntax)
13:11
signed-number (check-in: 65b46ed928 user: drh tags: svg-syntax)
12:39
Minor tweaks to select-stmt. (check-in: 73084eb917 user: drh tags: svg-syntax)
11:53
No background color at all on the select-core subset of select-stmt - just a gray border. (check-in: aa884bd27e user: drh tags: svg-syntax)
11:25
Lighter background color for "select-core" within "select-stmt" (check-in: e8177053e8 user: drh tags: svg-syntax)
05:31
select-stmt, with a tinted background for the select-core. (check-in: 296f548eeb user: drh tags: svg-syntax)
04:22
select-core (check-in: 405151ac80 user: drh tags: svg-syntax)
01:14
savepoint-stmt (check-in: 8698f49d49 user: drh tags: svg-syntax)
01:11
release-stmt, result-column, and rollback-stmt (check-in: 0fa36afc9b user: drh tags: svg-syntax)
00:45
raise-function, recursive-cte, and reindex-stmt (check-in: 25e8db2da4 user: drh tags: svg-syntax)
00:14
pragma-stmt, pragma-value, and qualified-table-name (check-in: 197fb70d06 user: drh tags: svg-syntax)
2020-09-23
21:26
over-clause (check-in: 03e44f6545 user: drh tags: svg-syntax)
20:00
Unmanage a couple of unused and obsolete syntax GIFs (check-in: ec5f4852e3 user: drh tags: svg-syntax)
19:51
numeric-literal and ordering-term (check-in: e5ef88d2b2 user: drh tags: svg-syntax)
18:44
Four new smaller diagrams. (check-in: 81e15dd8f8 user: drh tags: svg-syntax)
15:16
insert-stmt (check-in: b2c60f5d3a user: drh tags: svg-syntax)
12:59
indexed-column (check-in: 9437f9afd4 user: drh tags: svg-syntax)
12:39
frame-spec (check-in: 5c4e4507e5 user: drh tags: svg-syntax)
01:02
factored-select-stmt, filter-clause, and foreign-key-clause (check-in: 2ffb8b43ab user: drh tags: svg-syntax)
2020-09-22
23:11
Add the expr diagram. (check-in: 8b533b0b3d user: drh tags: svg-syntax)
18:34
Add the various DROP statements (check-in: fc300ff912 user: drh tags: svg-syntax)
17:56
Add cte-table-name, delete-stmt, and delete-stmt-limited. (check-in: 2b6dd6d053 user: drh tags: svg-syntax)
16:52
Add the create-view-stmt and create-virtual-table-stmt diagrams. (check-in: 107702e238 user: drh tags: svg-syntax)
15:44
Add the create-trigger-stmt. The arrows on FOR EACH ROW and WHEN expr seem a little confused. We might want to revisit the design later. (check-in: 91293e0c33 user: drh tags: svg-syntax)
14:39
Minor tweaks to create-table-stmt (check-in: 73f92ad202 user: drh tags: svg-syntax)
13:49
Adding conflict-clause, create-index-stmt, and create-table-stmt (check-in: 7c5c929fe7 user: drh tags: svg-syntax)
02:56
Minor tweaks to the compound-select-stmt diagram. (check-in: abec402383 user: drh tags: svg-syntax)
02:50
Add the Pikchr version of compound-select-stmt (check-in: 44f0ca00e5 user: drh tags: svg-syntax)
00:40
Add syntax diagrams through compound-operator (check-in: aa50764739 user: drh tags: svg-syntax)
2020-09-21
22:56
Add the column-def and column-name-list diagrams in SVG (check-in: 18d0a89fc6 user: drh tags: svg-syntax)
20:53
Add the column-constraint diagram. 151 lines of Pikchr. (check-in: fe260f0054 user: drh tags: svg-syntax)
19:49
Add pikchr scripts for attach-stmt and begin-stmt. (check-in: 7b336eb761 user: drh tags: svg-syntax)
19:20
Add analyze-stmt.pikchr (check-in: 95d38371c5 user: drh tags: svg-syntax)
18:57
Fix teh syntax.html and syntaxdiagrams.html page so that they use either the SVG or the GIF, whichever is available. But both depend upon the syntax_link.tcl data. This is sufficient for now. After all diagrams have been converted into Pikchr, we need to go back and revisit all of the legacy logic. (check-in: a9f58cd9f5 user: drh tags: svg-syntax)
17:49
Add Pikchr for aggregate-function-invocation. Realize now that I need to work on replicating the syntax_linkage.tcl data. (check-in: e25d0c295b user: drh tags: svg-syntax)
15:02
Update documentation for fts5 integrity-check command. (check-in: 179ade5492 user: dan tags: trunk)
14:56
Extract the width of each SVG and add a max-width to the <img> (check-in: c82a99b440 user: drh tags: svg-syntax)
14:23
Add infrastructure for porting syntax diagrams to SVG. (check-in: 277011128a user: drh tags: svg-syntax)
2020-09-20
12:35
Fix markup errors an appfunc.in. (check-in: 2cda5fcaf9 user: drh tags: branch-3.33)
11:42
Documentation typo (check-in: f581b7f6be user: drh tags: branch-3.33)
2020-09-14
11:04
Two more typo fixes. (check-in: 3d6dfc9933 user: drh tags: branch-3.33)
11:00
Fix typo in Json documentation. (check-in: 21a593daf3 user: drh tags: branch-3.33)
2020-09-10
11:36
Typo fix in lang_altertable.in (check-in: 05526832f0 user: drh tags: branch-3.33)
2020-09-07
22:29
Fix documentation typos. (check-in: 84df4e3535 user: drh tags: branch-3.33)
2020-08-28
15:34
Remove obsolete contract link from the consortium page. (check-in: 53d98374ae user: drh tags: branch-3.33)
2020-08-27
19:44
Add an entry in the change log about improved error messages on CHECK constraints. (check-in: 15ec3fe739 user: drh tags: trunk)
13:32
Clarify the behavior of the "%" operator when presented with non-integer operands. (check-in: 153857859d user: drh tags: branch-3.33)
2020-08-26
19:41
Clarify the long-standing behavior of the "PRAGMA query_only=TRUE;" command. (check-in: 52e85453bb user: drh tags: trunk)
14:05
Rearrange the sections of the CLI documentation, slightly. (check-in: 33bc7b858b user: drh tags: trunk)
13:53
Begin changes for the 3.34.0 release. Add a new changelog entry with notations of the enhancements since the previous release. (check-in: 13335de219 user: drh tags: trunk)
2020-08-25
16:49
Fix the display of constructors and destructors in the object documentation. (check-in: ba732954be user: drh tags: trunk)
2020-08-20
11:32
Fix formatting error in the optoverview.html document. (check-in: c5f5f967d1 user: drh tags: trunk)
2020-08-16
19:18
Fix typos in the floatingpoint.html document. (check-in: ec6ebb5204 user: drh tags: trunk)
11:16
Fix some broken hyperlinks. (check-in: ea43e17478 user: drh tags: trunk)
11:14
Clarify the value of "K", the number of keys on an interior node of a b-tree in the file format documentation. (check-in: 14768fbd25 user: drh tags: trunk)
2020-08-14
13:28
Version 3.33.0 (check-in: 21c05e9d58 user: drh tags: trunk, release, version-3.33.0)
2020-08-13
20:26
Add a news entry for 3.33.0. (check-in: 079e262d86 user: drh tags: trunk)
20:21
Fix typos in documentation. (check-in: 5e73e48d33 user: drh tags: trunk)
20:13
Update testing statistics for 3.33.0. (check-in: b901bab566 user: drh tags: trunk)
19:52
Update the speed-size data for the 3.33.0 anticipated release. (check-in: fa525972cb user: drh tags: trunk)
2020-08-12
22:06
New filtering rules in althttpd.c for aggressive Chinese bots. (check-in: 8bf987cd16 user: drh tags: trunk)
2020-08-11
17:01
Minor nomenclature changes. (check-in: c0be8169a7 user: drh tags: trunk)
2020-08-08
15:37
Fix a requirement mark formatting error on the integrity_check docs. (check-in: 70e6eb5281 user: drh tags: trunk)
15:13
Improvements to wording and typo fixes in pragma documentation. (check-in: 91ba2807f5 user: drh tags: trunk)
2020-08-07
20:08
Merge fixes from the 3.32 branch. (check-in: 7f7cb02e96 user: drh tags: trunk)
2020-08-06
11:12
In the search script, remove all punctuation from the search string before injecting it into TCL. (Leaf check-in: 382a046780 user: drh tags: branch-3.32)
2020-08-01
00:14
Fix the max database size on the about.html page. (check-in: 4ad59ef382 user: drh tags: trunk)
2020-07-30
17:46
Update the database size limit to 281 terabytes. (check-in: b752742d9c user: drh tags: trunk)
2020-07-28
19:39
Update the size-and-speed spreadsheet. (check-in: 1c1f5f5f3b user: drh tags: trunk)
17:30
Update the change log for the unlocked-recovery enhancement. (check-in: 77c08efc0e user: drh tags: trunk)
2020-07-26
16:11
Merge branch-3.32 fixed into trunk. (check-in: ace42c454f user: drh tags: trunk)
16:08
On the download page, use sha3 instead of sha1. And deemphasize the text. (check-in: 0de47c19a5 user: drh tags: branch-3.32)
13:35
Improved wording of the floatingpoint.html document. (check-in: 010e930cc2 user: drh tags: trunk)
13:24
Fix typos in the new floating point document. (check-in: e26caafc33 user: drh tags: trunk)
2020-07-23
09:32
Add documentation for partial integrity_check. (check-in: 95ab7854dd user: drh tags: trunk)
2020-07-20
17:18
Fix typo on the quirks.in page. (check-in: 586df7805b user: drh tags: branch-3.32)
2020-07-18
16:35
Documentation for UPDATE FROM. (check-in: ba3810c515 user: drh tags: trunk)
2020-07-17
17:35
Revise syntax diagrams to include the FROM clause on UPDATE statements. (Closed-Leaf check-in: bd9cdee968 user: drh tags: update-from)
2020-07-15
15:03
Tweaks to the floatingpoint.html page. (check-in: dcd828be81 user: drh tags: trunk)
01:43
Merge fixes from the 3.32 branch. (check-in: bd3dff05f9 user: drh tags: trunk)
01:42
Update the change log. Typo fixes in the floating-point documentation. (check-in: 846fd3a3f7 user: drh tags: trunk)
2020-07-14
00:20
Initial draft of documentation on floating point, IEEE 754 binary64, and the ieee754 and decimal extensions. (check-in: 448d185aac user: drh tags: trunk)
2020-07-11
00:03
Fix hyperlink problem in the lang.html page. (check-in: afb2b13396 user: drh tags: branch-3.32)
2020-07-09
15:12
Fix minor typo in the transaction documentation. (check-in: fd1f6c62f7 user: drh tags: trunk)
2020-07-03
09:57
Typos in the shared-cache mode documentation. (check-in: f79cc54f25 user: drh tags: branch-3.32)
2020-06-29
11:40
Merge fixes from the 3.32 branch. (check-in: e3d95c44b7 user: drh tags: trunk)
01:26
Update the CVE list. (check-in: 7565236dfd user: drh tags: branch-3.32)
2020-06-28
16:36
Correction to how Knuth names B-Tree algorithm variants in the file format document. (check-in: ea334221a0 user: drh tags: trunk)
2020-06-19
16:19
Fix typo. (check-in: 4bcbd4ac5e user: drh tags: branch-3.32)
13:05
Create a new documentation page devoted to describing the use and purpose of the sqlite_schema table. Work-in-progress. (check-in: 29b01bac87 user: drh tags: trunk)
2020-06-18
21:18
Terminology adjustments. (check-in: e01d8c6144 user: drh tags: trunk)
20:30
Merge fixes from the 3.32 branch. (check-in: b48705423b user: drh tags: trunk)
19:12
Improved hyperlink to the change graph for 3.32.3. (check-in: a7e284e0ea user: drh tags: branch-3.32)
15:15
Update the CVE list. (check-in: 461fc0f2bb user: drh tags: branch-3.32)
15:00
Merge documentation fixes from the 3.32 branch. Updates to the change log. (check-in: 1d22b3977e user: drh tags: trunk)
14:54
Add a link to a the graph of 3.32 changes on the 3.32.3 news item. (check-in: ff42d8f2f7 user: drh tags: branch-3.32)
14:05
Version 3.32.3 (check-in: ee6ff4d4d4 user: drh tags: release, version-3.32.3, branch-3.32)
13:32
Draft changes for the 3.32.3 release. (check-in: 4cd53a483c user: drh tags: branch-3.32)
2020-06-14
17:05
Fix typo in the cksumvfs document. (check-in: 46fc601ee6 user: drh tags: branch-3.32)
2020-06-13
17:39
Fix typo on the prosupport page. (check-in: 50f0077137 user: drh tags: branch-3.32)
2020-06-10
16:04
Fix a markup typo in the WITH documentation. (check-in: 9edcd33d7a user: drh tags: branch-3.32)
2020-06-06
23:36
Typo on the title of lang_expr.html (check-in: 49bc712623 user: drh tags: branch-3.32)
2020-06-05
00:54
Improvements to CLI document to talk about the new output modes. (check-in: 8df47c7f07 user: drh tags: trunk)
2020-06-04
13:20
Update the change log for 3.33.0. (check-in: 6732f1b4a3 user: drh tags: trunk)
13:12
Merge changes from the 3.32 branch. (check-in: 395f6a5ed8 user: drh tags: trunk)
13:08
Version 3.32.2 (check-in: 1cc621326d user: drh tags: release, version-3.32.2, branch-3.32)
2020-05-27
20:26
Change the "Report A Bug" on the "Common Links" menu, to just "Bugs". (check-in: 3ec64302c5 user: drh tags: branch-3.32)
18:27
Strenghten the executive summary for the CVE page. (check-in: f01d05d1ca user: drh tags: branch-3.32)
18:08
Typo fix. (check-in: d9677b1a4d user: drh tags: branch-3.32)
17:56
Merge fixes from the 3.32 branch. (check-in: 201fa09b9c user: drh tags: trunk)
17:53
Clarification and typo fixes for the SQLITE_PRINTF_PRECISION_LIMIT macro discussion on the security.html page. (check-in: f5279a88e3 user: drh tags: branch-3.32)
17:17
New more CVEs added. (check-in: 39d7d5ff1c user: drh tags: branch-3.32)
16:58
Add information about CVE-2020-13630. (check-in: 11f990aa4a user: drh tags: branch-3.32)
2020-05-26
17:52
More typo fixes. (check-in: bb341aaddb user: drh tags: branch-3.32)
14:38
Typos in lang_transaction. (check-in: 12ea451a69 user: drh tags: branch-3.32)
12:05
Add version 3.33.0 as the "latest release" in order to begin the next development cycle. (check-in: 1e233aef21 user: drh tags: trunk)
2020-05-25
19:05
Further enhancements to the change log display. (check-in: affe7e5d6e user: drh tags: trunk)
17:19
Improved formatting of the change log. (check-in: 8334ca7a45 user: drh tags: trunk)
16:23
Version 3.32.1 (check-in: 734e79389b user: drh tags: trunk, release, version-3.32.1)
15:51
Spelling fix. Improved wording of the change log. (check-in: 91e7f50627 user: drh tags: trunk)
15:05
Improvement to the description of CVE-2020-13434. (check-in: cdd85ef5d4 user: drh tags: trunk)
12:54
For the 3.31.1 change log, add a bullet about compiler warning fixes. (check-in: 510d0a179b user: drh tags: trunk)
11:50
Add notes about SQLITE_PRINTF_PRECISION_LIMIT. (check-in: b7b7f39852 user: drh tags: trunk)
01:05
Update the limits page to talk about the new higher limit for the maximum number of host parameters. (check-in: 4c8d521776 user: drh tags: trunk)
00:48
Update docs for the 3.32.1 release. (check-in: a850000db3 user: drh tags: trunk)
2020-05-24
23:50
Updates to the speed-and-size chart. (check-in: 22f0b93b75 user: drh tags: trunk)
2020-05-23
02:05
Fix typo in SQLITE_USE_ALLOCA documentation. (check-in: 5a6f07e675 user: drh tags: trunk)
02:01
Typo: iff() should be iif(). (check-in: 93257a1a8d user: drh tags: trunk)
2020-05-22
17:48
Version 3.32.0 (check-in: d816b04a78 user: drh tags: trunk, release, version-3.32.0)
12:21
Fix typos. (check-in: bf4a56342e user: drh tags: trunk)
12:12
Add a news item for the 3.32.0 release. Change the release date to today. (check-in: 4e9d9494bb user: drh tags: trunk)
12:05
Make dbsqlfuzz one of the primary test harnesses for SQLite. (check-in: b56e6bd246 user: drh tags: trunk)
11:43
Update testing metrics. (check-in: f09dcc9b65 user: drh tags: trunk)
2020-05-21
19:16
Fix typo in the query planner documentation. (Leaf check-in: c3875b77fa user: drh tags: branch-3.31)
19:16
Fix typo in the query planner documentation. (check-in: f246e9b589 user: drh tags: trunk)
2020-05-20
17:42
Documentation updates based on code review. (check-in: 0bdeed702c user: drh tags: trunk)
16:59
An extra sentence of clarification on explicit collating sequences on an IN operator. (check-in: 568e2f047e user: drh tags: trunk)
15:02
Update the change log. (check-in: 18e8d6c077 user: drh tags: trunk)
01:27
Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause. (check-in: 8b88f8f240 user: drh tags: branch-3.31)
01:24
Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause. (check-in: e42edf1dd3 user: drh tags: trunk)
2020-05-19
19:37
Improvements to the CVE page. (check-in: 1cb2a5b6bc user: drh tags: trunk)
12:37
Update the speed and size charts. (check-in: 386621474b user: drh tags: trunk)
2020-05-18
14:37
Fix a minor typo in the rtree documentation. (check-in: f073620ff2 user: drh tags: branch-3.31)
14:36
Fix a minor typo in the rtree documentation. (check-in: da19a96616 user: drh tags: trunk)
2020-05-16
00:12
Merge the branch-3.31 changes into trunk. (check-in: 2f7a35660e user: drh tags: trunk)
00:10
Remove the FAQ about the round() function. (check-in: b064af7596 user: drh tags: branch-3.31)
2020-05-15
17:41
Update the round() question in the FAQ. (check-in: 2beb2b13f2 user: drh tags: trunk)
17:10
Merge changes from the 3.31 branch. (check-in: 16c2b9405d user: drh tags: trunk)
17:09
Mention the improvements to rounding behavior in 3.29.0. (check-in: 6c04530c49 user: drh tags: branch-3.31)
16:44
Documentation typo. (check-in: 246fd6ec6d user: drh tags: trunk)
2020-05-14
14:41
Merge recent fixes from the 3.31 branch. (check-in: f43bf45ac3 user: drh tags: trunk)
14:40
Fix a typo in the whyc.html document. (check-in: 450b55927b user: drh tags: branch-3.31)
00:36
Update the change log to include new features added but previously not mentioned. (check-in: 4c96725f43 user: drh tags: trunk)
2020-05-13
18:19
Add documentation for the iif() SQL function. (check-in: 7d28d65e60 user: drh tags: trunk)
2020-05-11
15:42
Attempt to provide yet another tutorial introduction to how SQLite (and other SQL database engines) work in the howitworks.html document. (check-in: dc87da6361 user: drh tags: trunk)
2020-05-09
22:32
Althttpd: do not send a content-length for 304 Not Changed reply. (check-in: ad2370ccce user: drh tags: trunk)
20:04
Further enhancements to the cve and security pages. (check-in: 7027c3e122 user: drh tags: trunk)
19:29
Enhancements to the CVE document. (check-in: e5b5670379 user: drh tags: trunk)
18:47
Fix typo in documentation for PRAGMA analysis_limit. (check-in: 33a99a578b user: drh tags: trunk)
2020-05-08
17:18
CVE typos (check-in: d35025c4c1 user: andygoth tags: trunk)
16:57
Clarify that SQLite does not have DISTINCT ON, instead a functional equivalent (check-in: 25d90d6568 user: andygoth tags: trunk)
00:04
Fix typos in the CVE page. (check-in: 837ad3aa78 user: drh tags: trunk)
00:00
First complete draft of the CVE document. (check-in: 00eaac1236 user: drh tags: trunk)
2020-05-07
15:28
Initial draft of a CVE reporting page. Very incomplete. (check-in: f488981a6e user: drh tags: trunk)
12:52
Update the "common links" to provide a link to Quirks. (check-in: 1b98f299ae user: drh tags: trunk)
11:16
Minor improvements to wording in quirks.html. (check-in: 38dbb90b4f user: drh tags: trunk)
2020-05-06
18:39
Clarify that PRAGMA legacy_alter_table is a per-connection setting. (check-in: d8587f5d39 user: drh tags: branch-3.31)
13:19
Merge fixes from the 3.31 release branch. (check-in: 67d4da0615 user: drh tags: trunk)
13:17
Correct a misstatement about the default value of --enable-fts5 in the FTS5 documentation. (check-in: d9ed737ccf user: drh tags: branch-3.31)
2020-05-05
17:26
Minor typos (check-in: 6462cea7f8 user: andygoth tags: trunk)
2020-05-04
23:40
Add documentation about the checksum VFS shim. (check-in: 98066e131a user: drh tags: trunk)
23:18
Initial documentation of the bytecode and tables_used virtual tables. (check-in: 708a0633a2 user: drh tags: trunk)
16:17
Correct a few minor typos in recent changes (check-in: ebdb4df7d1 user: andygoth tags: trunk)
2020-05-02
18:12
Documentation for approximate ANALYZE. (check-in: 88c3a54623 user: drh tags: trunk)
2020-05-01
17:58
Improvements to the limits.html page. (check-in: 8f3b36e4be user: drh tags: trunk)
2020-04-29
04:02
Name another situation where REINDEX is useful, and take the opportunity to link to the indexes-on-expressions page. Note: the inconsistency between saying "indexes" and "indices" is intentional in order to make the page link work right, and I did not dare mess with sentences beginning with "^". (check-in: 769f1fe673 user: andygoth tags: trunk)
2020-04-28
13:12
Typo-fix "IS0" should be "ISO". (check-in: 9aa683ce57 user: drh tags: branch-3.31)
13:07
In althttpd.c, if the client sends a "Host:" parameter that is a FQDN (with a "dot" at the end - "sqlite.org." instead of "sqlite.org") then omit the final "." when computing the document root. See the bug report on the fossil forum. (check-in: 13343b49cc user: drh tags: trunk)
2020-04-23
15:42
Enhancements to quirks.html and lang_createtrigger.html. (check-in: d734b7b070 user: drh tags: trunk)
14:44
Merge changes from the 3.31 branch. (check-in: 80ab6c051c user: drh tags: trunk)
14:14
Improvements to the "Keywords can be used as identifiers" section of the "quirks.html" document. (check-in: 9ea30fe517 user: drh tags: branch-3.31)
2020-04-21
01:32
Fix typo in the optoverview.html document. (check-in: b2b73614f4 user: drh tags: branch-3.31)
2020-04-20
23:07
Fix a typo in the CREATE TRIGGER documentation. (check-in: 79b74d138c user: drh tags: trunk)
2020-04-18
20:02
Fix documentation on the geopoly_within() function - the order of the parameters was reversed prior to this fix. (check-in: c3705ed80b user: drh tags: branch-3.31)
2020-04-14
22:15
Merge branch-3.31 fixes into trunk. (check-in: 15a047bc79 user: drh tags: trunk)
21:45
Fix fork on trunk. (check-in: a9da99ea1c user: drh tags: trunk)
16:00
Change "null-terminated" to "zero-terminated" in contexts that are referring to a C-language string. (check-in: ab201643e5 user: drh tags: branch-3.31)
15:35
Fix a typo in rescode.html. (check-in: 786d2dc899 user: dan tags: trunk)
14:08
Fix a typo in limits.in. (check-in: 2664eaab37 user: dan tags: trunk)
2020-04-13
23:56
Fix typo in limits. (check-in: 4a8aadfb81 user: drh tags: branch-3.31)
2020-04-11
19:40
Fix a scripting error in the generator script for rescode.html (check-in: 982001679b user: drh tags: branch-3.31)
2020-04-10
17:30
Merge fixes from the 3.31 branch. (check-in: cc882f6d6c user: drh tags: trunk)
00:26
Fix typo in the TCL interface documentation. (check-in: 1fef0132cb user: drh tags: branch-3.31)
2020-04-06
18:59
Fix various minor HTML coding errors pointed out by Gisbert on the forum. (check-in: de7905fcbb user: drh tags: branch-3.31)
2020-04-05
19:14
Include a timeline link in the prerelease snapshot description. (check-in: bda8dd11a5 user: drh tags: branch-3.31)
2020-04-01
19:40
Fix a typo in the JSON1 documentation. (check-in: e754041fb1 user: drh tags: branch-3.31)
2020-03-30
14:32
Merge fixes from the 3.31 branch. (check-in: 6155753faf user: drh tags: trunk)
14:22
Fix typo in the JSON documentation. (check-in: a9b40f21bb user: drh tags: branch-3.31)
14:21
Remove unintential control character from the unlock_notify.html document. (check-in: 8f5ade2031 user: drh tags: branch-3.31)
13:05
Updates to the speed-and-size chart. (check-in: ff60a85843 user: drh tags: trunk)
2020-03-27
13:02
Fix a typo in the "compile.html" document. (check-in: ea92357277 user: drh tags: branch-3.31)
2020-03-25
11:25
Fix a memory allocation error in CGI handling of althttpd.c. (check-in: e9a50836bc user: drh tags: trunk)
2020-03-24
16:08
Steer users more strongly toward the SQLite Forum. Remove links to mailing list signup. (check-in: 81624489f5 user: drh tags: branch-3.31)
2020-03-20
12:44
Provide more accurate elapse time measurements in the output log of althttpd.c (check-in: f474634ac8 user: drh tags: trunk)
2020-03-16
15:07
Performance improvement on CGI handling in althttpd.c (check-in: 1ec2d586fc user: drh tags: trunk)
2020-03-15
18:17
Enhance althttpd to support Range: attributes in the HTTP request header. (check-in: 1d3579379c user: drh tags: trunk)
2020-03-12
20:03
Update the support page to direct users to the SQLite Forum instead of to the mailing lists. (check-in: 2a8e648db7 user: drh tags: branch-3.31)
2020-03-06
00:13
Update the NOCASE documentation to make it clear that it uses sqlite3_strnicmp() for comparison and thus stops at the first embedded zero character in the string. (check-in: e751b0c91a user: drh tags: trunk)
2020-03-04
20:27
Small update to deterministic.html to mention generated columns. (check-in: 37b0c51a67 user: drh tags: trunk)
2020-03-03
18:22
Fix documentation typo in fileformat.html. (check-in: 5dacf1a573 user: drh tags: branch-3.31)
14:07
Update the althttpd documentation. (check-in: c7f0891d15 user: drh tags: trunk)
13:59
In the althttpd.c webserver, relax the constraint that filenames cannot begin with "." or "-" for the special "/.well-known/" path. The constraint remains for any URL that does not begin with "/.well-known/". And ".." is still disallowed. This change is necessary due to recent changes to the LetsEncrypt certbot. (check-in: 7027e3e86d user: drh tags: trunk)
2020-02-26
11:09
Fix a formatting problem in rescode.html. (check-in: d35032eb7f user: drh tags: branch-3.31)
2020-02-25
20:57
Initial documentation explaining the NUL characters can appear in the middle of TEXT strings and what to do about it. (check-in: e2299b8b80 user: drh tags: trunk)
2020-02-22
21:35
Fix a typo in datatype3.html. (check-in: ea9656e7d7 user: drh tags: trunk)
12:54
Fix a typo in the when-to-use page. (check-in: ee17d2f67b user: drh tags: branch-3.31)
12:53
Fix a typo in the when-to-use page. (check-in: 556d3bb6c4 user: drh tags: trunk)
2020-02-21
15:57
Fix typos in the testing.html document. (check-in: d4e9b24066 user: drh tags: branch-3.31)
15:27
Fix typos and improve phrasing in testing.in. (check-in: 80df0299e7 user: drh tags: trunk)
2020-02-20
04:01
Workaround for older web browsers that may not always set the 'location.origin' DOM property. (check-in: 5f54ffe04b user: mistachkin tags: trunk)
2020-02-18
20:24
Update the change log. (check-in: baac09c5a2 user: drh tags: trunk)
20:11
Fix the multi-column list display so that it works with documents that have both main and aux outputs. (check-in: 4e47b407a1 user: drh tags: trunk)
2020-02-10
20:43
Improvements to the built-in function lists. (check-in: 8ff2f2f334 user: drh tags: trunk)
20:33
Finish splitting the lang.in source file into separate parts. (check-in: ca272c33f2 user: drh tags: trunk)
17:23
Work toward splitting up the "lang.in" source file into individual source files, one for each language topic. (check-in: 90730870c5 user: drh tags: trunk)
2020-02-08
21:52
Lists with varying numbers of columns depending on screen width are converted to work off of CSS rather than using javascript. (check-in: bae1400568 user: drh tags: trunk)
2020-02-06
23:40
Clarification the UPSERT documentation. (check-in: 271f686636 user: drh tags: branch-3.31)
2020-02-03
16:23
Add change log for 3.32.0. (check-in: 69840d9eb5 user: drh tags: trunk)
2020-01-31
20:15
Attempt to clarify the CREATE TABLE documentation. In the generated column documentation, make it clear that SQLite deliberately ignores the collating sequence of the AS expression when determining the collating sequence of the generated column. (check-in: 91fa93da86 user: drh tags: trunk)
2020-01-29
23:04
Enhancements to the FTS3/4 documentation about the limitations of BOMs in string literals with the simple tokenizer in a UTF16 database. (check-in: 4d11f30804 user: drh tags: trunk)
21:29
Add the SQLITE_OMIT_AUTOINIT compile-time option to the set of recommended compile-time options. (check-in: f250d55692 user: drh tags: trunk)
20:19
Document the byte-order-mark limitation of fts3/4. (check-in: 7e55864b0a user: dan tags: trunk)
2020-01-27
20:02
Version 3.31.1 (check-in: 2ab23690d8 user: drh tags: trunk, release, version-3.31.1)
18:06
Initial changes for the 3.31.1 patch release. (check-in: 505d43b621 user: drh tags: trunk)
2020-01-26
18:03
Fix two documentation typos. (check-in: a7a8ecb98d user: drh tags: trunk)
2020-01-22
19:04
Version 3.31.0 (check-in: 44e1ce5453 user: drh tags: trunk, release, version-3.31.0)
17:53
Add news for the 3.31.0 release. (check-in: 0e92e9f7c1 user: drh tags: trunk)
17:49
Fix documentation typos. (check-in: 1894a02a1f user: drh tags: trunk)
17:13
Updates to the generated column documentation. (check-in: 2d23316bb5 user: drh tags: trunk)
2020-01-21
20:14
Update the speed-and-size spreadsheet. (check-in: 6639a1d518 user: drh tags: trunk)
2020-01-18
22:24
Enhanced documentation for the TCL interface, and especially warnings about the importance of using the -directonly option for application-defined functions. (check-in: 0d0e8a024d user: drh tags: trunk)
00:56
Documentation of two-size lookaside. (check-in: 668d3ca782 user: drh tags: trunk)
2020-01-17
19:03
Add documentation for SQLITE_OMIT_GENERATED_COLUMNS (check-in: df79d373f6 user: drh tags: trunk)
2020-01-15
13:20
Update the speed-size-graph to include timeline graphs. Output the chronology.json file when building. (check-in: e4f8c1c60f user: drh tags: trunk)
02:44
Update the speed-and-size chart. (check-in: 09b9c916d4 user: drh tags: trunk)
2020-01-14
01:57
Finish a first draft of the application-defined function document. (check-in: 66d5ec93a6 user: drh tags: trunk)
2020-01-13
20:33
Continue working to improve the documentation. (check-in: 264d9eef33 user: drh tags: trunk)
15:26
Template for the new "application-defined SQL function page". Improvements to security documentation. (check-in: 36399c3c34 user: drh tags: trunk)
13:33
Typo fixes. (check-in: 19599a7e1b user: drh tags: trunk)
2020-01-10
00:00
Reference the trusted_schema capability in the 3.31.0 change log. (check-in: 0fc93d49ce user: drh tags: trunk)
2020-01-08
11:12
Further clarification that collating functions only work on string values. (Leaf check-in: ba755cbcaa user: drh tags: branch-3.30)
2019-12-26
01:22
Push back the proposed release date for 3.31.0 by a month. (check-in: 157fdd299b user: drh tags: trunk)
2019-12-24
02:33
Document the fact that the R-Tree extension is not capable of doing simultaneous reads and writes. (check-in: a8afb2f905 user: drh tags: trunk)
2019-12-21
17:23
Enhancements and updates to the discussion of fuzzing in the testing document. (check-in: 3bf90e0caa user: drh tags: trunk)
15:22
Enhance CLI documentation to talk more about reading ZIP archives as database files. (check-in: e92fb43396 user: drh tags: trunk)
2019-12-14
11:02
Fix typo on the schema_version pragma documentation. (check-in: 2a413e2e3e user: drh tags: branch-3.30)
2019-12-07
12:14
Update the rtree documentation to report that type affinity is ignored for auxiliary columns. (check-in: 6958f518ec user: drh tags: trunk)
2019-12-06
13:08
Enhance the rtree documentation with more detail about the rules for column names and the affinity of columns in the rtree virtual table. (check-in: 8199b59a39 user: drh tags: trunk)
02:35
Enhance the rtree auxiliary column documentation to point out that constraints such as NOT NULL on auxiliary columns are silently ignored. SQLite ticket https://www.sqlite.org/src/info/8bf76328ac940d52 (check-in: c3ab325994 user: drh tags: trunk)
2019-12-02
21:36
Fix another incorrect date on 3.30.1. (check-in: c2a33222f0 user: drh tags: branch-3.30)
21:35
Fix the date on the 3.30.1 release, which was off by 3:21. (check-in: 12a0fc2e35 user: drh tags: branch-3.30)
2019-11-23
16:36
Fix the CLI documentation to always use ".headers" instead of sometimes using the abbreviated ".header". (check-in: a2762f0319 user: drh tags: trunk)
00:22
Documentation updates for new features. (check-in: 604ac8689d user: drh tags: trunk)
2019-11-19
19:15
Update the documentation to include information about aggregated mode for the DBSTAT table. (check-in: 8abf78baf9 user: drh tags: trunk)
2019-11-18
17:43
Mention the new SQLITE_OPEN_NOFOLLOW option in the change log. (check-in: d3ba10d894 user: drh tags: trunk)
2019-11-14
18:57
Documentation on hard-heap-limit. (check-in: 2252627a39 user: drh tags: trunk)
2019-11-07
12:48
Clarify what the file format ought to be when a WITHOUT ROWID table contains a PRIMARY KEY with redundant columns. This is not a change, but a filling in of previously omitted information. (check-in: 8cd33c0c9d user: drh tags: trunk)
2019-11-02
18:17
Update the keyword list. (check-in: 6904f495e9 user: drh tags: trunk)
12:10
Fix typo on the download page. (check-in: 037e7f6d68 user: drh tags: branch-3.30)
2019-11-01
23:58
Fix documentation for the ".explain auto" command. (check-in: c6125c2ae7 user: drh tags: branch-3.30)
2019-10-29
19:47
Fix typos in generated column documentation. (check-in: 3ec77ae315 user: drh tags: trunk)
16:31
Updates to the generated column documentation. Notate that the legacy_file_format pragma has been removed and replaced by the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). (check-in: 4b80493d37 user: drh tags: trunk)
09:03
Fix typo in the generated columns description. (check-in: eaa1cd343f user: drh tags: trunk)
03:35
Tighten the requirement so that every table must have at least one non-generated column. A STORED column does not count. (check-in: 3103f83e9e user: drh tags: trunk)
01:24
Begin adding documentation for generated columns. (check-in: a558a79107 user: drh tags: trunk)
2019-10-22
13:26
Fix a typo on the whentouse.html page. (check-in: 8b5ba0e2b1 user: drh tags: trunk)
2019-10-21
14:57
Update the CREATE TRIGGER documentation to acknowledge the fact that columns in the UPDATE OF syntax of CREATE TRIGGER need not exist in the table, and that the trigger only fires if one of the columns named in the UPDATE OF clause appear on the left-hand side of one of the terms in the SET clause of the UPDATE statement. (check-in: 998c5310eb user: drh tags: trunk)
2019-10-18
02:16
Fix a typo in the "quirks.html" document. (check-in: 7dce3c2f8a user: drh tags: trunk)
2019-10-16
18:07
Fix typos in the lemon documentation. (check-in: 85bc3983a5 user: drh tags: trunk)
2019-10-14
00:26
Further clarification of automatic affinity conversion rules. (check-in: 3a3335a61e user: drh tags: trunk)
00:20
Clarification of the automatic conversion rules for inserting TEXT into a NUMERIC column. (check-in: 9840457b31 user: drh tags: trunk)
2019-10-11
03:26
Version 3.30.1 (check-in: bb0f52c956 user: drh tags: trunk)
2019-10-10
17:35
Preparing for the 3.30.1 patch release. (check-in: d161e25a2e user: drh tags: trunk)
2019-10-06
15:33
Update the speed-and-size spreadsheet with 3.30.0 data. (check-in: 7a74244235 user: drh tags: trunk)
2019-10-04
15:08
Update chronology.in and changes.in with the correct release hashes. (check-in: 1433012434 user: drh tags: trunk)
14:58
Add a News entry for 3.30.0. Set the release date. (check-in: 0cbc8d6315 user: drh tags: trunk)
2019-10-02
12:39
Fix the history hyperlinks on the checklist app. (check-in: 5cb74ba705 user: drh tags: trunk)
11:41
Merge branch-3.29 enhancements into trunk, and in particular the hd_adunit change. (check-in: caa36aeea0 user: drh tags: trunk)
11:36
Add the ability to put an ad unit at the top of the index page and the download page. If the file "adunit.txt" exists in the build directory, then the content of that file is copied into the appropriate spot on those two pages. (Leaf check-in: ea232463fc user: drh tags: branch-3.29)
10:40
Typos and minor enhancements to the althttpd.md document. (check-in: 5140eb346c user: drh tags: trunk)
2019-09-28
19:02
Typo fixes. (check-in: 7a37431be5 user: drh tags: trunk)
2019-09-27
17:55
Updates so that documentation agrees with requirement marks. (check-in: f1a1831162 user: drh tags: trunk)
11:30
Merge fixes from the 3.20 branch. (check-in: de8b5d698b user: drh tags: trunk)
11:30
Type fixes (check-in: 003eb4df17 user: drh tags: trunk)
2019-09-26
19:34
Update the RBU documentation to remove the constraint about it not working with indexes on expressions. (check-in: e7771db6cc user: drh tags: trunk)
19:24
More documentation on how PRAGMA index_info and PRAGMA index_xinfo handle indexes on expressions. (check-in: d9d337b927 user: drh tags: trunk)
19:02
Fix introspection pragma documentation to show that they are now on by default. Add documentation for the TCL Interface config method. (check-in: a94ea31acb user: drh tags: trunk)
15:24
Adjustments to the document indexes. (check-in: ede6ba1df3 user: drh tags: trunk)
2019-09-24
10:30
Use single-quoted strings in the documention for PRAGMA encoding. (check-in: 4c6aa056b7 user: drh tags: branch-3.29)
2019-09-20
17:37
Fix a minor typo in the transaction documentation. (check-in: 83b8745219 user: drh tags: branch-3.29)
2019-09-16
14:49
Add SQLITE_DIRECTONLY to the change log and documentation. Fix a typo in changes to the index_info pragma. (check-in: 518f7b3bdd user: drh tags: trunk)
14:09
Remove documentation fixes from the release branch. (check-in: b10a80aacd user: drh tags: trunk)
2019-09-13
17:55
Fix a bug in the documentation generator for PRAGMAs. (check-in: d83262cc8b user: drh tags: branch-3.29)
2019-09-04
15:18
Update the speed-and-size spreadsheet with the latest figures. (check-in: 33e05d1299 user: drh tags: trunk)
2019-08-29
17:19
Add a description of NULLS FIRST and NULLS LAST. Add a note about the addition of sqlite3_drop_modules(). (check-in: a7856e4125 user: drh tags: trunk)
2019-08-15
23:05
Mention new defensive capabilities in the security.html page. (check-in: b714ca6b96 user: drh tags: trunk)
22:48
Update the change log with the latest enhancements. (check-in: b3e162d6ec user: drh tags: trunk)
16:12
Update the change log and the SQLITE_ENABLE_STAT3 documentation. (check-in: 4c942f942c user: drh tags: trunk)
16:03
More precise description of when SQLITE_MASTER can be updated in the FAQ. (check-in: 5a6c1fea3c user: drh tags: branch-3.29)
2019-08-14
17:19
In dashboard output, group outcomes by platform. (check-in: 76662698a8 user: drh tags: trunk)
16:54
Merge the test dashboard development line into trunk. (check-in: ed6e0d08a7 user: drh tags: trunk)
2019-08-12
11:54
Trying to improve the documentation on transactions. (check-in: ead5e472f0 user: drh tags: branch-3.29)
10:27
Minor improvements to dashboard. (Closed-Leaf check-in: 44eb5d574e user: drh tags: test-dashboard)
2019-08-07
21:59
Fix typo in comment. (check-in: b0c5406903 user: mistachkin tags: trunk)
19:23
Minor changes to the dashboard. (check-in: 90a47a80c2 user: drh tags: test-dashboard)
18:00
Improvements to the outcome display in the dashboard app. (check-in: ed3480d864 user: drh tags: test-dashboard)
17:46
The "outcomes" page on the dashboard automatically reloads every 5 minutes. (check-in: 448a7b73d2 user: drh tags: test-dashboard)
16:43
Updates to the dashboard.tcl app and its client-side library. First working code. (check-in: c773092c19 user: drh tags: test-dashboard)
2019-08-06
17:02
Improved documentation on how EXPLAIN only affects run-time but some PRAGMA statements operate at prepare-time and are thus unaffected by EXPLAIN. (check-in: e167521765 user: drh tags: branch-3.29)
2019-08-05
20:39
Back out the previous change. We are instead going to modify the code to match the documentation. (check-in: 3578d6c47b user: drh tags: branch-3.29)
20:39
Back out the previous change. We are instead going to modify the code to match the documentation. (check-in: e16ada80d6 user: drh tags: trunk)
12:55
Update the documentation on the affinity of the columns of VIEWs and subqueries that are generated from expressions to match the actual implementation of 10 years standing - namely such columns have BLOB affinity, not no affinity. Ticket https://www.sqlite.org/src/info/d52a29a9e6bc55c5 (check-in: 16a418966a user: drh tags: branch-3.29)
12:54
Update the documentation on the affinity of the columns of VIEWs and subqueries that are generated from expressions to match the actual implementation of 10 years standing - namely such columns have BLOB affinity, not no affinity. Ticket https://www.sqlite.org/src/info/d52a29a9e6bc55c5 (check-in: 07b7749da8 user: drh tags: trunk)
11:51
Show a table of outcomes in the dashboard.tcl app. (check-in: 1f66b2f1a9 user: drh tags: test-dashboard)
2019-08-02
17:54
In the checklist application, improve the submenu and simplify the login processing. (Originally checked in on the wrong branch.) (check-in: ee656f1e92 user: drh tags: trunk)
17:49
In the checklist application, improve the submenu and simplify the login processing. (check-in: 20a5bb3601 user: drh tags: test-dashboard)
15:52
Add an initial version of the client-side uplink library. (check-in: 4e0da90810 user: drh tags: test-dashboard)
2019-08-01
20:50
Initial code for a testing dashboard application. Not yet functional. (check-in: 67d3af93de user: drh tags: test-dashboard)
16:46
Update the /env method of the checklist application to work better with the latest version of Wapp for CGI. (check-in: b1400ebb42 user: drh tags: trunk)
16:36
Fix the checklist editing function on the checklist application so that it works correctly with Fossil CGI. (check-in: 9d872b74d9 user: drh tags: trunk)
02:44
Update the change log. (check-in: 6ec9f2a9c8 user: drh tags: trunk)
2019-07-27
16:09
Improvements to the header comment on the checklist application, bringing it up-to-date with the actual implementation. Added a prototype checklist database file. (check-in: e8d378f753 user: drh tags: trunk)
15:39
Add the CGI-Environment and Source-code submenu links to the checklist application. (check-in: a5c38ef1bf user: drh tags: trunk)
15:28
In the checklist application, add a /self method and make the magic database name "top" refer to the lexically largest database file. (check-in: 752d433361 user: drh tags: trunk)
15:13
Fixes to the checklist CGI so that it works better as a Fossil CGI extension. (check-in: 41933da084 user: drh tags: trunk)
2019-07-26
20:22
Update the checklist.tcl script to align with the latest code on the website. (check-in: ef7dae4ce8 user: drh tags: trunk)
2019-07-17
13:02
Preliminary documentation for the enhancements to index_info and index_xinfo to support viewing the on-disk representation of WITHOUT ROWID tables. (check-in: 296e23a4b8 user: drh tags: trunk)
2019-07-16
13:44
Updates to the testing document. (check-in: 0d69a8d268 user: drh tags: branch-3.29)
2019-07-15
19:25
Update syntax diagrams to show the FILTER clause on aggregate functions. Start a change log for version 3.30.0. (check-in: ba9800704d user: drh tags: trunk)
17:48
Minor typos fixes in the lemon documentation. (check-in: bd1181fb39 user: drh tags: trunk)
17:17
Fix a missing space in the selfcontained.html webpage. (check-in: 127e0a0347 user: drh tags: trunk)
2019-07-13
16:24
Remove obsolete and unsupported BNF and TEXT representations of the grammar. (check-in: b02f76d76f user: drh tags: trunk)
2019-07-11
16:31
More typo fixes in quirks.html (check-in: f6681985cd user: drh tags: trunk)
16:01
Fix typos in the quirks document. (check-in: 596c4951a0 user: drh tags: trunk)
14:15
Add the "quirks.html" document to the list of overview documents in the documentation summary. (check-in: 085c470f26 user: drh tags: trunk)
13:28
Add another example of using a stale file descriptor to the howtocorrupt page. (check-in: 8a4435f7ae user: drh tags: trunk)
2019-07-10
17:38
Version 3.29.0 (check-in: 059d7ea707 user: drh tags: trunk, release, version-3.29.0)
12:40
Update the speed-and-size spreadsheet. (check-in: ab8568d80c user: drh tags: trunk)
12:02
Add news for the 3.29.0 release. (check-in: c3bd426c86 user: drh tags: trunk)
11:45
Fix typos (check-in: 7a5056a138 user: drh tags: trunk)
2019-07-09
13:13
Minor tweaks to the change log and to the documentation for SQLITE_DQS. (check-in: d3b763b6a7 user: drh tags: trunk)
09:50
Merge documentation fixes from the 3.28 release. (check-in: 02ab9d6bd3 user: drh tags: trunk)
09:48
Fix documentation typo. (Leaf check-in: ee5e3f5b43 user: drh tags: branch-3.28)
2019-07-02
13:25
Fix to the 12-step procedure for generalized schema modifications. Additional text trying to describe why schema modifications are hard in SQLite. (check-in: df84d97d7b user: drh tags: trunk)
12:47
Add documentation for the SQLITE_DQS compile-time option. Adjust the documentation so that the default is now -DSQLITE_DQS=3. (check-in: e2807b06c2 user: drh tags: trunk)
2019-06-17
14:14
Add notes about the new sqlite3_db_config() interfaces. Enhanced discussion of the double-quoted string literal misfeature. (check-in: ab87f9f72b user: drh tags: trunk)
13:56
Track the revised DQS interface. (Closed-Leaf check-in: 09cea3924b user: drh tags: new-dbconfig-options)
2019-06-15
15:24
Documentation on the new SQLITE_DBCONFIG options. (check-in: 4ebc1051c2 user: drh tags: new-dbconfig-options)
2019-06-12
20:31
Fix the description of how collation is computed to indicate that the collation is not blocked by a CAST operator. Fix for ticket https://www.sqlite.org/src/info/b148fa61059fb6c2. (check-in: 9f887f15e5 user: drh tags: trunk)
10:55
Enhancements to the change log. (check-in: 06b9f7898d user: drh tags: trunk)
2019-06-11
15:54
Clarify the semantics of a CAST to NUMERIC. Ticket https://www.sqlite.org/src/tktview/afdc5a29dc (check-in: 7a51b32537 user: drh tags: trunk)
13:40
Clarify how mathematical operators function given string or blob operands. Ticket https://www.sqlite.org/src/tktview/1819598c09 (check-in: e0f700bb6c user: drh tags: trunk)
02:59
Augment the affinity rules to state that the affinity of a COLLATE operator is the same as the affinity of its left-hand side. Ticket https://www.sqlite.org/src/tktview/d60b3cd7cb (check-in: 722f0828b3 user: drh tags: trunk)
02:51
State that the COLLATE operator does not change affinity. (Leaf check-in: 5395fed295 user: drh tags: mistake)
2019-05-23
19:37
Add a row for 3.29.0 to the speed-and-size chart. (check-in: 7502249d01 user: drh tags: trunk)
2019-05-21
11:14
IE11 does not understand a 308 redirect, so always use a 301 redirect instead. (check-in: 91021e98e3 user: drh tags: trunk)
02:48
Use the <!DOCTYPE html> header on all pages. (check-in: b5aef4cfad user: drh tags: branch-3.28)
2019-05-17
20:39
Enhance the PRAGMA journal_mode=OFF documentation to make it clear that ordinary SQL can corrupt the database file while in that mode. See ticket https://www.sqlite.org/src/info/f4ec250930342e0c (check-in: 5f361950a7 user: drh tags: trunk)
17:22
Fix a harmless compiler warning about the return value of freopen() in althttpd. (check-in: 445195faaf user: drh tags: trunk)
17:20
Some redirects are now permanent. (check-in: dd8def223f user: drh tags: trunk)
2019-05-10
11:38
Fix a typo in the documentation for ANALYZE. (check-in: 0917d5f9d6 user: drh tags: branch-3.28)
2019-05-08
17:26
Document the fact that using PRAGMA case_sensitive_like in a database that uses LIKE operators in the schema can lead to problems. (check-in: bc4c1a7626 user: drh tags: trunk)
16:53
Clarify the ON CONFLICT clause documentation to make clear that FK violations always work as ABORT or ROLLBACK, never FAIL, IGNORE, or REPLACE. (check-in: 90a2cca5d0 user: drh tags: trunk)
2019-05-02
19:03
Use freopen() rather than assigning to "stdin" in althttpd.c. (check-in: 229fda6dfb user: drh tags: trunk)
16:25
Attempt to clarify the scope of when UPSERT processing applies. (check-in: aae75b6ac2 user: drh tags: branch-3.28)
2019-04-30
20:37
More "whynotgit.html" updates. (check-in: 71cccf3d65 user: drh tags: branch-3.28)
20:15
Further enhancements to the whynotgit.html page. (check-in: 763fc99770 user: drh tags: branch-3.28)
2019-04-29
19:27
Further clarification to the assert.html document. (check-in: ef3822f76d user: drh tags: branch-3.28)
18:45
Add documentation for the ".recover" command to the shell tool page. (check-in: 51202caa59 user: dan tags: trunk)
16:21
Merge changes from the 3.28 branch. (check-in: d220b2f30c user: drh tags: trunk)
15:46
Soften the criticism of Go because of their decision to omit assert() from the language. (check-in: 4a40995c05 user: drh tags: branch-3.28)
13:51
Update the file-format document to indicate that de-duplication of index columns in WITHOUT ROWID tables does not occur if the columns have different collating sequences. (check-in: 3047c99f8a user: drh tags: trunk)
2019-04-28
00:46
Fix althttpd.c so that it builds on non-linux machines. (check-in: 02b0d4d406 user: drh tags: trunk)
2019-04-27
21:01
Start a change log for version 3.29.0. (check-in: 4e1bc9c5f0 user: drh tags: trunk)
18:42
Updates to the althttpd.md documentation. (check-in: 7dcc5545d1 user: drh tags: trunk)
11:27
Fix a typo in althttpd.c - restore the behavior of index.cgi. (check-in: 8cda91e897 user: drh tags: trunk)
2019-04-24
19:28
The attack that the previous check-in sought to mitigate has stopped. So comment-out the change of the previous check-in. (check-in: 4e3b689944 user: drh tags: trunk)
17:18
In althttpd.c, disallow a single particular user-agent string that is recently appearing in spider attacks. (check-in: 01c0f297c1 user: drh tags: trunk)
2019-04-19
23:40
Clarify the documentation on PRAGMA cache_size to explain that the cache size will go up or down in proportion to a change in page size. (check-in: 184e897473 user: drh tags: trunk)
2019-04-18
16:39
Althttpd now prefers /home over /index.html if it exists. (check-in: 87856f6c54 user: drh tags: trunk)
16:34
Change althttpd.c to search for /home after /index.html if not filename is given. (check-in: efdc1b8e66 user: drh tags: trunk)
2019-04-17
19:17
Remove unmatched close parenthesis from fileformat.html. (check-in: 41027bf4a9 user: dan tags: trunk)
15:17
Additional information about the SQLITE_IOERR_SHMSIZE error code. (check-in: 5c5e6f523a user: drh tags: trunk)
2019-04-16
19:52
Version 3.28.0 (check-in: 8084bf3aaf user: drh tags: trunk, release, version-3.28.0)
17:15
Fix typos. (check-in: 5bdcbe6918 user: drh tags: trunk)
17:08
Add a news entry for the 3.28.0 release. (check-in: 4136052d27 user: drh tags: trunk)
15:20
Updates to the change log. (check-in: 1309ba3c39 user: drh tags: trunk)
2019-04-15
22:32
Update the speed-and-size spreadsheet. (check-in: 3fc49bdac0 user: drh tags: trunk)
2019-04-13
15:45
Wording changes in defense-against-dark-arts. (check-in: adb3c10d3e user: drh tags: trunk)
15:33
Additional suggestions for defense against dark arts. (check-in: b41d1c753f user: drh tags: trunk)
2019-04-08
18:08
Fix a minor error in the datatype documentation. (Leaf check-in: 87bef3d123 user: drh tags: branch-3.27)
18:06
Fix a minor error in the datatype documentation. (check-in: a5590f5f81 user: drh tags: trunk)
2019-04-05
21:18
Remove an obsolete reference to the addopcodes.tcl script. (check-in: efe862885f user: drh tags: trunk)
2019-04-04
19:07
Fix a typo. (check-in: e6f195d6f4 user: drh tags: trunk)
2019-04-02
13:26
Add the four new keywords: EXCLUDE GROUPS OTHERS TIES (check-in: 8db10efb63 user: drh tags: trunk)
01:06
Update the fts3_tokenizer() documentation to describe how it now wants parameters to be bound. (check-in: 30e7de5540 user: drh tags: trunk)
2019-04-01
14:45
Merge changes from the 3.27 branch. (check-in: 50513b6f28 user: drh tags: trunk)
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-29
16:41
Fix spelling error in the previous check-in. (check-in: cfd3eb70b4 user: drh tags: trunk)
16:40
Mention the ON parsing ambiguity of UPSERT on the UPSERT documentation page. (check-in: c3bcaaf1e5 user: drh tags: trunk)
2019-03-28
20:22
Remove the "expr FOLLOWING" case from frame-specs that only describe the starting boundary. (check-in: 5eff6feebc user: drh tags: trunk)
15:23
In the window-defn bubble diagram, change "existing-window-name" to "base-window-name" and make it an indentifier instead of a non-terminal. (check-in: 67d1075ce3 user: drh tags: trunk)
15:15
Improved railroad diagram for frame-spec. (check-in: 6598d28114 user: drh tags: trunk)
01:20
Minor tweak to the window function documentation. (check-in: 7113d8b989 user: drh tags: trunk)
00:46
Work on the window function documentation. (check-in: 4b4ef30fa6 user: drh tags: trunk)
2019-03-27
19:02
Fix problems in windowfunctions.in. (check-in: dac96e63bd user: dan tags: trunk)
2019-03-26
14:47
Update the changes long to show the enhancements to window functions. (check-in: 1a7fda4c1f user: drh tags: trunk)
13:11
Update window functions documentation. (check-in: bdc2a67078 user: dan tags: trunk)
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)
20:49
Update documentation to match the proposed window function changes. (Closed-Leaf check-in: 783032878d user: dan tags: window-functions)
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)
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)