Documentation Source Text

Timeline
Login

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

500 most recent check-ins

2022-08-15
11:37
Make the documentation more explicit that the use of shared cache mode is discouraged. (Leaf 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)