Documentation Source Text

Timeline
Login

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

836 check-ins using file docapp/main.tcl version 82269a5c60

2024-03-28
14:56
Improved wording in the change log for the VALUES-as-coroutine optimization. (Leaf check-in: 33ef696a6a user: drh tags: trunk)
2024-03-27
20:33
Add "Custom Auxiliary Functions API Overview" section to fts5.in. (check-in: 37e33a83a0 user: dan tags: trunk)
2024-03-22
16:28
Fix a typo on the change log. (check-in: e37777f78d user: drh tags: trunk)
2024-03-18
23:31
Improvements to query planner documentation. (check-in: 8daf6750f4 user: drh tags: trunk)
18:59
Adjust download parameters to the assumption that the next release will be version 3.46.0. (Leaf check-in: 993b056b97 user: drh tags: branch-3.45)
18:09
Add mention of the VALUES-as-coroutine optimization to the 3.46.0 change log. (check-in: 5725078ac1 user: drh tags: trunk)
2024-03-14
14:17
Improvements to the json_pretty() documentation. (check-in: 8599ff66d8 user: drh tags: trunk)
11:05
Clarify documentation of date/time functions. (check-in: 07fa5fc08f user: drh tags: trunk)
2024-03-13
17:43
Merge the latest 3.45 branch enhancements into the trunk. (check-in: 4cbac6e9df user: drh tags: trunk)
17:39
Fix a typo - a missing "the". (check-in: 70cdb08c16 user: drh tags: trunk)
2024-03-12
11:10
Version 3.45.2 (check-in: 383a49293e user: drh tags: release, branch-3.45, version-3.45.2)
10:50
Failed attempt at version 3.45.2 (Closed-Leaf check-in: 45a1292817 user: drh tags: mistake)
2024-03-11
09:47
Update the description of how precision works for floating point conversions in printf. (check-in: 3509ea1fae user: drh tags: branch-3.45)
2024-03-09
19:19
Change a URL to take advantage of the new to2= query parameter on the Fossil /timeline page. (check-in: 572800e461 user: drh tags: branch-3.45)
15:06
First draft of the change log for the 3.45.2 release. (check-in: 61f4bd1a27 user: drh tags: branch-3.45)
10:40
Correct version number in which CVS 2023-7104 was fixed (3.43.1 instead of 3.43.2), as reported in [forum:5f3c098d95|forum post 5f3c098d95]. (check-in: 021f60cd9b user: drh tags: branch-3.45)
2024-03-08
19:31
Correct version number in which CVS 2023-7104 was fixed (3.43.1 instead of 3.43.2), as reported in [forum:5f3c098d95|forum post 5f3c098d95]. (check-in: 478b394e60 user: stephan tags: trunk)
2024-03-06
20:59
Add documentation for json_pretty(). (check-in: 3fa054c734 user: drh tags: trunk)
2024-03-04
14:26
Updates to date/time documentation to cover the new ceiling and floor modifiers. (check-in: 755f0ef018 user: drh tags: trunk)
2024-03-02
20:58
Document the (no yet landed) "mnth" and "yr" date interval modifiers. (check-in: a69e7c0dfe user: drh tags: trunk)
2024-02-27
20:24
Typo fix and remove a superfluous distinction made between hex and decimal digits (the goal being to preclude the need to edit that part if more numeric literal formats are added). (check-in: 77b157a6a3 user: stephan tags: trunk)
20:15
Document the added support for readablility underscores in numeric literals. (check-in: c92361d424 user: drh tags: trunk)
2024-02-25
16:48
Typo fixes in json1.in reported in the forum. (check-in: dc18e48b7a user: stephan tags: trunk)
16:46
Fix typos in JSON document, as pointed out on the forum. (check-in: f69258e1a6 user: drh tags: branch-3.45)
2024-02-22
16:13
More precise description of when the sqlite_sequence table is created and written. (check-in: 5a179beae5 user: drh tags: branch-3.45)
16:13
More precise description of when the sqlite_sequence table is created and written. (check-in: 7352924d4a user: drh tags: trunk)
15:53
Typo fix reported in the forum. (check-in: 7d74022e2d user: stephan tags: trunk)
2024-02-21
13:43
Still more tweaks to the PRAGMA optimize documentation and usage recommendations. (check-in: 4c0d69d594 user: drh tags: trunk)
13:18
Minor tweak to the PRAGMA optimize suggested use docs. (check-in: a5f7dfa489 user: drh tags: trunk)
2024-02-20
20:58
More tweaks to PRAGMA optimize documentation. (check-in: a78e7b04fe user: drh tags: trunk)
18:47
Update documentation to talk about enhancements to PRAGMA optimize. (check-in: 8442623cb4 user: drh tags: trunk)
2024-02-16
18:52
Activate the table-of-contents for the ANALYZE documentation page. (check-in: 19e26c0a78 user: drh tags: trunk)
18:51
Updates to the change log. (check-in: bf8f13e01e user: drh tags: trunk)
18:43
New hyperlinks and refinements to the enhanced ANALYZE documentation. (check-in: da19a9e007 user: drh tags: trunk)
18:31
Clarify and expand the documentation on the use of PRAGMA optimize and ANALYZE and the query planner stability guarantee. (check-in: b101c6c0fb user: drh tags: trunk)
2024-02-13
18:06
Minor WAL mode clarification for an SQLITE_BUSY case suggested in the forum. (check-in: ae6dc63646 user: stephan tags: trunk)
17:39
Correct 'Azure Cosmos' typo reported in the forum. (check-in: 5cda9cfe68 user: stephan tags: trunk)
2024-02-01
18:38
Fix a markup typo on the compile.html page. (check-in: f5f9122b7d user: drh tags: branch-3.45)
2024-01-31
23:45
Cure a few grammatical flaws reported in the forum, and zap trailing whitespace. (check-in: 9de0929942 user: larrybr tags: trunk)
11:30
Further fixes to the grammar in the sentence just modified. (check-in: 0076754655 user: drh tags: branch-3.45)
11:29
Fix typo in CREATE TABLE documentation. Forum post d910f407b2f2a35d. (check-in: 6dcc4a1d38 user: drh tags: branch-3.45)
11:23
Update the text about Manuel Rigger and his fuzzers. (check-in: 2e59a89947 user: drh tags: branch-3.45)
2024-01-30
18:09
Fix typo in testing document. (check-in: 64334a29da user: drh tags: branch-3.45)
16:05
Version 3.45.1 (check-in: 41e4b53be2 user: drh tags: release, branch-3.45, version-3.45.1)
13:53
Updates to news and change log for the 3.45.1 release. (check-in: f7e27bf3ff user: drh tags: branch-3.45)
2024-01-29
11:00
Typo fixes for the 3.45.0 release. (Leaf check-in: d74c032847 user: drh tags: branch-3.45.0)
04:50
SQL result typo fix reported in the forum and confirmed in /fiddle. (check-in: 822b36a31a user: stephan tags: branch-3.45)
04:49
SQL result typo fix reported in the forum and confirmed in /fiddle. (check-in: 5acd77fc59 user: stephan tags: trunk)
2024-01-28
23:26
Fix typos. (check-in: c1d63bacb4 user: drh tags: branch-3.45)
23:24
Fix typos. Forum post c3dfc31075. (check-in: 39f4b7bcaa user: drh tags: trunk)
2024-01-24
11:29
Improvements to the JSON BLOB input bug documentation. (check-in: e8dccbef95 user: drh tags: branch-3.45)
11:20
Documentation for the JSON BLOB input bug. (check-in: 09820fbd5a user: drh tags: branch-3.45)
2024-01-23
13:42
Change log and chronology entries for the 3.45.1 patch release. (check-in: 1805399fa6 user: drh tags: branch-3.45)
13:08
Add a note to foreignkeys.in that fk references may not span schemas. (check-in: 03744fae7e user: stephan tags: branch-3.45)
13:07
Add a note to foreignkeys.in that fk references may not span schemas. (check-in: 5eef8cf0b5 user: stephan tags: trunk)
2024-01-21
18:05
Fix typos in the JSON documentation. (check-in: 256a6e16f5 user: drh tags: branch-3.45)
2024-01-19
01:09
Start recording changes for 3.46.0. Add documentation for the enhancements to strftime(). (check-in: f184d6507b user: drh tags: trunk)
2024-01-16
16:06
Add CVE-2024-0232 to the cves.html page. (check-in: ebd7b980c5 user: drh tags: trunk)
14:06
Fix action-item numbering in the security.html document. Forum thread ecd26c46dd. (check-in: b59e5a0b23 user: drh tags: trunk)
2024-01-15
17:13
Fix the LAST_MAJOR_RELEASE entry on the download page generator. (check-in: 69109a6f11 user: drh tags: trunk)
17:05
Version 3.45.0 (check-in: a8792c31c4 user: drh tags: trunk, release, version-3.45.0)
16:38
Fix documentation typos. (check-in: 6be2bb0eca user: drh tags: trunk)
15:08
Update the speed and size spreadsheet. (check-in: b052d9c1d2 user: drh tags: trunk)
2024-01-13
19:04
Fix typos. Add a new CVE. (check-in: 029459bd0b user: drh tags: trunk)
19:04
Fix typos. Add a new CVE. (Leaf check-in: 0b88a38dfd user: drh tags: branch-3.44)
2024-01-12
15:40
Add news about the 3.45.0 release. (check-in: 911b544e27 user: drh tags: trunk)
15:30
Add CLI enhancements to the 3.45.0 change log. (check-in: c3347c35d7 user: drh tags: trunk)
2024-01-09
20:59
Merge typo fixes from branch-3.44 (check-in: 01061bb92b user: drh tags: trunk)
20:02
Typo fixes. (check-in: a808fb2778 user: drh tags: branch-3.44)
2024-01-03
11:05
Update the change log to show the increase in the default MAX_PAGE_COUNT. (check-in: d7fa4e60f6 user: drh tags: trunk)
2024-01-02
14:14
Update the change log to reflect the most recent enhancements. (check-in: f9e1e7f98e user: drh tags: trunk)
2023-12-28
12:49
Document the SQLITE_JSON_MAX_DEPTH compile-time option. Improved cross-referencing of compile-time size limits. (check-in: f23e682856 user: drh tags: trunk)
2023-12-22
14:38
Update a 404 Threads Are Evil link in the faq, as reported in [forum:890a69f4b5|forum post 890a69f4b5]. (check-in: f044506cff user: stephan tags: trunk)
00:30
Fix typo in json documentation. (check-in: d6ad496d9a user: drh tags: trunk)
2023-12-21
18:54
More refinements to the JSONB documentation. (check-in: 035da7a439 user: drh tags: trunk)
18:44
Further backing off of JSONB formatting details. Go full-in on calling it just an SQLite internal parse-tree format. (check-in: 3bfd93c03c user: drh tags: trunk)
18:08
Undocument the JSONB format. Application developers should not know what the internal design of JSONB looks like. JSONB should be just a proprietary internal data structure for SQLite. (check-in: 95010ca778 user: drh tags: trunk)
15:28
Minor clarifications and typo fixes in the JSON documentation. (check-in: d7107682a0 user: drh tags: trunk)
2023-12-16
21:28
Enhancements to JSON documentation. (check-in: 275938caa9 user: drh tags: trunk)
15:16
Fix typos in JSON function documentation. (check-in: df2e20f27b user: drh tags: trunk)
2023-12-14
20:51
Updates to the change log and compile-time options page. (check-in: 3d18c85874 user: drh tags: trunk)
2023-12-13
14:27
Updates to JSON documentation. (check-in: 8b9039994b user: drh tags: trunk)
2023-12-09
19:19
download.in: update http: links to https: and add a link to sqlite.org/android in the "precompiled binaries for Android" section, per request from a user who was looking for their source code. (check-in: cd0269eebd user: stephan tags: trunk)
2023-12-06
18:07
Update fts5 docs with description of tokendata=1 option. (check-in: baeaef00b7 user: dan tags: trunk)
2023-12-05
19:57
Merge the JSONB enhancements. (check-in: b9c149e41a user: drh tags: trunk)
16:07
Further tweaks for the JSONB documentation. (Closed-Leaf check-in: f6fad8006b user: drh tags: jsonb)
15:39
Updates to JSONB documentation. (check-in: 83e6af3514 user: drh tags: jsonb)
14:43
Merge the latest trunk changes into the jsonb branch. Update with the latest documentation about JSONB. (check-in: 3b673fad86 user: drh tags: jsonb)
2023-12-02
22:40
Enhance the download page. Fix a typo on lang_attach.html (check-in: 150e715cda user: drh tags: trunk)
2023-11-24
11:48
Fix the 3.44.2 hash in chronology.tcl. (check-in: 9780baadfd user: drh tags: trunk)
11:45
Version 3.44.2 (check-in: 1a7db4c0a1 user: drh tags: trunk, version-3.44.2)
2023-11-23
12:23
Preliminary changes for version 3.44.2. (check-in: b506bf9011 user: drh tags: trunk)
2023-11-22
21:33
Revise CLI .help list again. (check-in: 6aad1eabd0 user: larrybr tags: trunk)
21:02
For CLI, revise mention of -utf8 and -no-utf8 options to reflect current and past translation situation. (check-in: afbabc55bc user: larrybr tags: trunk)
14:33
Fix the "patchagainst" for the 3.44.1 release. (check-in: d238bbfa6d user: drh tags: trunk)
14:23
Version 3.44.1 (check-in: 47530dc24b user: drh tags: trunk, release, version-3.44.1)
2023-11-21
13:04
Stronger wording on the change log for 3.44.1. Fix a typo on a hyperlink in the threadsafe.html document. (check-in: 6fcd6f894e user: drh tags: trunk)
12:16
Preliminary documention for the 3.44.1 patch release. (check-in: 20ce5dbf86 user: drh tags: trunk)
2023-11-16
14:05
Add entry for compile option SQLITE_DISABLE_PAGECACHE_OVERFLOW_STATS. (check-in: c0ce05e589 user: dan tags: trunk)
2023-11-15
03:17
Typo fix reported in the forum. (check-in: 78a117e9b9 user: stephan tags: trunk)
00:07
Mention SQLITE_ENABLE_HIDDEN_COLUMNS in the compile options page. (Absence noted in a forum post.) (check-in: 87e83af84e user: larrybr tags: trunk)
2023-11-14
19:01
Fix typo in VACUUM documentation. (check-in: fafbac70c1 user: drh tags: trunk)
2023-11-04
22:48
Fix grammos in Flexible Typing essay. (check-in: a2c4fc9cef user: larrybr tags: trunk)
17:47
Update fts5 documentation with the new trigram tokenizer remove_diacritics option. (check-in: 8820f9fbb7 user: dan tags: trunk)
2023-11-01
13:59
Fix the download.in page generator to recognize -x64- instead of -x86- for Linux and OSX builds. (check-in: 559cb867c3 user: drh tags: trunk)
12:06
Update the download page so that it accepts -win- instead of -win32- for Windows build package names. (check-in: 461836db31 user: drh tags: trunk)
11:28
Version 3.44.0 (check-in: 19a104d013 user: drh tags: trunk, release, version-3.44.0)
10:55
Tweaks to the change log. Add a news entry for 3.44.0. (check-in: da9ff0fe71 user: drh tags: trunk)
03:41
Fix broken hyperlink in oldnews.* (check-in: 243d4fb2bc user: larrybr tags: trunk)
2023-10-31
20:32
Update the speed and size spreadsheet. (check-in: 6b4f37949b user: drh tags: trunk)
20:24
Update to the change log. (check-in: 91a5c72585 user: drh tags: trunk)
2023-10-28
14:50
Fix wanna-be links, noted in a forum post, in Documentation overview. (check-in: 60a306d5a0 user: larrybr tags: trunk)
12:07
Further clarification of the policy of invalid UTF in the database schema. (check-in: 2d01e28aac user: drh tags: trunk)
11:47
Add a section in the invalidutf.html page that describes what happens when schema elements that are invalid UTF are included in SQLite-generated error messages. (check-in: 6985f9b1b9 user: drh tags: trunk)
11:35
Merge documentation enhancements from branch-3.43 onto trunk. (check-in: 4af2300ef1 user: drh tags: trunk)
2023-10-26
19:49
Revise CLI doc on --no-utf8 to reflect splitting of input/output effects and recent default to UTF-8 console I/O. (check-in: 042929470a user: larrybr tags: trunk)
17:50
Push back the 3.44.0 release date until Nov 8. (check-in: 3591964f4a user: drh tags: trunk)
01:12
Fix typo in the strftime() documentation. Forum post dcbb75d3e3. (check-in: e1bb367b33 user: drh tags: trunk)
2023-10-25
19:08
Improvements to VTAB documentation regarding xIntegrity. (check-in: 1d9044b16d user: drh tags: trunk)
11:34
Clarification of a few bullets in the change log for 3.44.0. (check-in: cd7980aae5 user: drh tags: trunk)
11:22
Update the xIntegrity documentation to describe the new parameters. (check-in: 96096bc9c6 user: drh tags: trunk)
2023-10-24
19:38
Additional detail and cross-linking of SQL function documentation. (check-in: 21f2c6d95f user: drh tags: trunk)
19:12
Add the new "function-arguments" non-terminal to the bubble diagrams. (check-in: 4cf6e8d252 user: drh tags: trunk)
18:19
Improved hyperlinking between the various SQL function documentation pages. (check-in: 9d3f151177 user: drh tags: trunk)
18:03
New text and hyperlinks associated with aggregate ORDER BY. (check-in: 908071d8d5 user: drh tags: trunk)
17:23
Update syntax_linkage.tcl so that the new ordering-term non-terminal is linked from aggregate-function-invocation. (check-in: e028522ec2 user: drh tags: trunk)
17:10
Get ORDER BY into aggregate function invoke diagram. (check-in: 1391a28657 user: larrybr tags: trunk)
13:21
Another typo fix. (check-in: 67cdf9d5c7 user: drh tags: trunk)
13:15
Fix typos (check-in: d93476022f user: drh tags: trunk)
11:39
Adjust the download page generator so that it can accept snapshot builds of the windows utility problems. (Leaf check-in: eeb54d184d user: drh tags: branch-3.43)
2023-10-20
22:32
Update the change log for version 3.44.0. (check-in: 41f546be6a user: drh tags: trunk)
2023-10-19
17:13
Cure grammos noted in forum post 71b50c00ad. (check-in: e46ed2bbb4 user: larrybr tags: trunk)
2023-10-17
22:48
In UPDATE with limit syntax diagram, get returning-clause independent of WHERE. See forum post d8f57775be. (check-in: 855a4e88ef user: drh tags: branch-3.43)
22:10
In UPDATE with limit syntax diagram, get returning-clause independent of WHERE. See forum post d8f57775be. (check-in: 2aab6634b5 user: larrybr tags: trunk)
2023-10-16
15:30
Add the deprecation of PRAGMA case_sensitive_like to the change log. (check-in: 274c9142ab user: drh tags: trunk)
15:24
Tweaks to the deprecation warning on PRAGMA case_sensitive_like. (check-in: 7f8395a8ad user: drh tags: trunk)
15:17
Change documentation to say that the case_sensitive_like pragma is deprecated. (check-in: 2bfc682559 user: drh tags: trunk)
2023-10-14
13:41
Added a link to external references to fasterthanfs.html. (check-in: 09b9021e39 user: drh tags: branch-3.43)
2023-10-12
11:46
Further clarification of JSONB and typo fixes. (check-in: e95f7ea68f user: drh tags: jsonb)
11:40
Further clarification to what JSONB is and why it is useful. (check-in: 3f84dd678e user: drh tags: jsonb)
2023-10-11
16:07
Further enhancements to the JSONB documentation to help clarify its design and purpose. (check-in: 0ae7f4829c user: drh tags: jsonb)
10:57
Enhancements to the JSONB documentation in response to feedback. (check-in: be93ea1043 user: drh tags: jsonb)
2023-10-10
17:29
Merge trunk enhancements into the jsonb branch. (check-in: 1582eb9d1d user: drh tags: jsonb)
17:28
Merge the branch-3.43 changes (especially the 3.43.2 release) into trunk. (check-in: 4e7f3c639a user: drh tags: trunk)
12:21
Version 3.43.2 (check-in: 7d684fc635 user: drh tags: release, branch-3.43, version-3.43.2)
12:10
Preparing for the 3.43.2 patch release. (check-in: 6641d4f5d5 user: drh tags: branch-3.43)
12:10
Amplify the intent of SQLITE_ENABLE_API_ARMOR. (check-in: 7e4ac9271f user: drh tags: branch-3.43)
2023-10-06
12:30
End-of-header-line period usage consistency and Windows capitalization tweaks. (check-in: 9e03a5a3fb user: stephan tags: trunk)
10:46
Global replace http://www.sqlite.org with https://www.sqlite.org in pages/*.in. (check-in: 57bf6c4ae7 user: stephan tags: trunk)
2023-10-05
18:20
Increase the prices of SDS to 2500/year. (check-in: 535f4fef0d user: drh tags: branch-3.43)
2023-10-02
19:08
Use "primitive" rather than "singleton" as that is what RFC8259 uses. (check-in: 08df2095bc user: drh tags: jsonb)
18:57
Fix the spelling of PostgreSQL. (check-in: 943ec0eecd user: drh tags: jsonb)
18:51
Initial cut attempt at JSONB documentation. (check-in: 686b8716f9 user: drh tags: jsonb)
2023-09-16
13:28
Merge typo fix in the CLI document from branch-3.43. (check-in: d8e78b65da user: drh tags: trunk)
13:27
Fix typo in the CLI document. (check-in: 801f1184f2 user: drh tags: branch-3.43)
2023-09-14
14:42
Merge branch-3.43 fixes into trunk. (check-in: 241501a523 user: drh tags: trunk)
14:41
Fix typos in the result code documentation. Problem reported by https://sqlite.org/forum/forumpost/173ebd7dc1. (check-in: 6cea079c40 user: drh tags: branch-3.43)
2023-09-12
13:40
Fix rendering of embedded SVG. See forum post https://sqlite.org/forum/forumpost/9834724f0f4d4a (check-in: 762ef93f09 user: drh tags: branch-3.43)
13:38
Fix rendering of embedded SVG. See forum post https://sqlite.org/forum/forumpost/9834724f0f4d4a (check-in: d045fbf93a user: drh tags: trunk)
2023-09-11
17:57
Fix a harmless typo in the 3.42.0 change log. (check-in: dc2a11f63b user: drh tags: branch-3.43)
16:51
Avoid duplicating entries returned by changelog searches in all minor versions. (check-in: b5d3147243 user: dan tags: trunk)
15:43
Fix the timeline hyperlink for the snapshot tarball on the download page. (check-in: 0e083481a3 user: drh tags: branch-3.43)
15:38
Merge 3.43.1 changes. Update the change log. (check-in: 1bfa4ba9f4 user: drh tags: trunk)
12:11
Version 3.43.1 (check-in: c4cf636236 user: drh tags: branch-3.43, version-3.43.1)
2023-09-08
14:56
Update change log and news in preparations for a patch release. (check-in: 72388c464e user: drh tags: branch-3.43)
12:42
Fix grammo reported in forum. (check-in: b827623d78 user: drh tags: branch-3.43)
2023-09-07
20:42
Fix grammo reported in forum. (check-in: bb23eb2b79 user: larrybr tags: trunk)
2023-09-05
14:39
Improvements to the descriptions of threading modes, in an attempt to avoid confusion. (check-in: c93628caf3 user: drh tags: branch-3.43)
2023-08-29
19:12
Document the new conversion letters for strftime(). (check-in: ffcfef0089 user: drh tags: trunk)
15:38
Start the 3.44.0 development cycle. Add documentation for CONCAT() and CONCAT_WS(). (check-in: 87a39b4d6d user: drh tags: trunk)
2023-08-28
15:17
Document the fact that SUM() and related functions may return NULL if the input sequence contains both positive and negative infinities. (check-in: ae9b1ad384 user: drh tags: trunk)
13:50
Fix fts5 docs to correctly say that the structure record has id=10 and the averages record id=1. (check-in: 99a9efae59 user: dan tags: trunk)
2023-08-24
12:42
Version 3.43.0 (check-in: 93a4599cf8 user: drh tags: trunk, release, version-3.43.0)
2023-08-23
21:38
News article for 3.43.0 added. Release dates updated to tomorrow. (check-in: 32ea92a241 user: drh tags: trunk)
14:08
Minor tweaks to the change log for 3.43.0. (check-in: a7a2b39e99 user: drh tags: trunk)
2023-08-22
14:52
Update the speed-size spreadsheet with data for 3.43.0. (check-in: 35c6c21dba user: drh tags: trunk)
2023-08-21
10:27
Add new CVEs that mention SQLite but that are not about SQLite to the cves.html document. (check-in: dd7672ca1e user: drh tags: trunk)
2023-08-18
15:40
Rename the decimal_sci() function to decimal_exp(). (check-in: 6821cc7bdf user: drh tags: trunk)
2023-08-14
13:36
Remove the ".binary" dot-command from the CLI documentation. (check-in: 376df9af0f user: drh tags: trunk)
12:22
Change the target release date for 3.43.0 to 2023-08-29. (check-in: b3d03ceba2 user: drh tags: trunk)
11:30
Added a note about SQLITE_USE_SEH to the change log. (check-in: 05829e9376 user: drh tags: trunk)
10:57
Merge branch-3.42 changes into trunk. (check-in: cbf4d1a766 user: drh tags: trunk)
10:54
Fix indentation of the menu on the docs page. Forum post b44b6e3547. (Leaf check-in: 5836f51eb9 user: drh tags: branch-3.42)
09:50
Remove the sh_mark styling from docs.in, as it has almost zero visible effect except for certain browsers where it's causing the whole /docs.html page to render incorrectly (reported in [fourm:b44b6e3547]). (check-in: cc3929fa24 user: stephan tags: trunk)
2023-08-11
20:15
Be explicit that json_valid() returns NULL on a NULL input. (check-in: 83c1de26ae user: drh tags: trunk)
2023-08-08
16:52
Update documentation of fts5 contentless-delete tables. (check-in: 1444addab4 user: dan tags: trunk)
02:07
Replace some http:// with https://. (check-in: 74762ee361 user: stephan tags: trunk)
2023-08-07
09:44
Rename pContext to pUserData in the fts5 docs, to match the same change in [src:2ca064d8eb37252e16b]. (check-in: fc20f99c7f user: stephan tags: trunk)
2023-08-05
19:13
Tiny typo fixes from [forum:31eb707250|forum post 31eb707250] and adjacent end-of-line white cleanups. (check-in: 3a4f309162 user: stephan tags: trunk)
2023-08-03
14:10
Add documentation for the verify-source makefile target. (check-in: 504eefdace user: drh tags: trunk)
2023-08-02
12:55
Clarification of the behavior of the MATERIALIZED hints on common table expressions. (check-in: 6de000dfa3 user: drh tags: trunk)
2023-08-01
17:34
New examples of using the -> and ->> operators. (check-in: abce4ae7d0 user: drh tags: trunk)
14:01
Next release will occur from trunk. (check-in: 2be349a191 user: drh tags: branch-3.42)
13:58
Enhancements to the date/time documentation and expecially regarding the new timediff() function. (check-in: de7ff77b42 user: drh tags: trunk)
2023-07-30
10:50
Merge 3.42.0 changes into trunk. (check-in: 69df2ed48f user: drh tags: trunk)
10:48
Updates to the change log for 3.43.0 (check-in: 80512efd52 user: drh tags: trunk)
2023-07-27
20:27
Add documentation for ".scanstats vm" to profile.html. (check-in: 2958c3e869 user: dan tags: trunk)
18:01
Add documentation for the fts5 contentless_delete=1 and 'deletemerge' options. (check-in: 73ab6b2b65 user: dan tags: trunk)
2023-07-26
17:26
Fix another typo in fts5.html. (check-in: f39548c42e user: dan tags: trunk)
11:14
Fix problems in fts5 documentation. (check-in: 025d350331 user: dan tags: trunk)
2023-07-19
19:13
Lower the performance estimate for JSON parsing to a more conservative 250 MB/s, which is a number we can easily meet. I'm not sure where the 1 GB/s figure came from. (check-in: 561c0607e9 user: drh tags: branch-3.42)
2023-07-10
11:52
Attempt to improve the wording of the Contentless Table documentation for FTS5. (check-in: e5af001918 user: drh tags: trunk)
2023-07-04
20:07
Simplify the footprint.html page. (check-in: 367bad9f22 user: drh tags: branch-3.42)
2023-06-29
23:49
Talk about decimal_sum() in the sum() documentation and provide a hyperlink over to the floating-point documentation. (check-in: 5e348e167c user: drh tags: trunk)
23:23
Notate the decimal extension enhancements in the change log. (check-in: a4459d5a47 user: drh tags: trunk)
23:18
Update the decimal extension and printf() documentation to reflect the latest changes and comments. (check-in: 080037ba17 user: drh tags: trunk)
2023-06-23
13:30
Merge version 3.42 updates into trunk. (check-in: 2cbb7ed123 user: drh tags: trunk)
13:20
Remove the statement about PGO from the footprint.html document. (check-in: 43c1154ec6 user: drh tags: branch-3.42)
11:37
Documentation for octet_length(). (check-in: d61235143a user: drh tags: trunk)
11:26
Updates to the speed-size chart. (check-in: 63aa5788cf user: drh tags: trunk)
2023-06-19
20:32
Add a license for SDS-SEE.exml to the prosupport options. (check-in: 5815443a19 user: drh tags: branch-3.42)
17:16
Minor enhancement to the date/time examples. (check-in: 9ed168eaff user: drh tags: trunk)
17:09
Initial draft of support page for System.Data.SQLite. (Leaf check-in: 8d1d330648 user: mistachkin tags: sds)
2023-06-16
10:11
Remove a stray parenthesis, reported in the forum. (check-in: c271a46440 user: stephan tags: trunk)
2023-06-13
18:56
Improve explanation of SQLITE_ENABLE_FTS3 as noted in forum post b10cd8312f. (check-in: 97210f4fce user: larrybr tags: trunk)
13:23
Point the bare column documentation to the recent forum discussion. (check-in: d3a21bf2aa user: drh tags: trunk)
2023-06-10
17:29
Documentation for SQLITE_DBCONFIG_STRICT_AGGREGATE. (Closed-Leaf check-in: 1d597840ae user: drh tags: newbie-safe-aggregates)
2023-06-07
13:17
Fix problem with example of inserting a symbolic link in zipfile.in. (check-in: 9546f48b09 user: drh tags: branch-3.42)
11:24
Fix problem with example of inserting a symbolic link in zipfile.in. (check-in: 68bb2c8a3e user: dan tags: trunk)
2023-06-01
20:46
Document the enhancement to the OUTER JOIN strength reduction optimization. (check-in: 1486a61269 user: drh tags: trunk)
18:28
Generalize the documentation on the LEFT JOIN strength reduction and omit-LEFT-JOIN optimizations to talk about RIGHT and FULL JOINs as well. The implementation of those optimizations still only works for LEFT JOIN, so in some sense the documentation is getting ahead of the implementation. (check-in: 4635dbba87 user: drh tags: trunk)
2023-05-30
16:54
Update the version number and start the 3.43.0 change log. (check-in: 307b763072 user: drh tags: trunk)
16:43
Documentation on the timediff() enhancement. (check-in: 09231d045c user: drh tags: trunk)
12:46
Preliminary documentation for the new timediff() function. (Closed-Leaf check-in: 71097e7496 user: drh tags: timediff)
2023-05-29
17:38
Add examples to fts5.html. (check-in: e043cdf1a1 user: dan tags: trunk)
2023-05-27
15:39
Fix a typo in the "search.d/admin" script. (check-in: a5fe4561cf user: drh tags: trunk)
2023-05-24
20:57
Fix typo in the file format document. forum post 93cc6c6e46. (check-in: f410802c23 user: drh tags: trunk)
2023-05-20
19:19
Fix a typo in the flextypegood.html documentation page. (check-in: 4ddba86c59 user: drh tags: trunk)
2023-05-16
15:07
Fix the generation of the toc.db file. Bug report against 3.42.0 reported by Roger Binns. (check-in: f77cf5a868 user: drh tags: trunk)
12:42
Version 3.42.0 (check-in: 24990dc445 user: drh tags: trunk, release, version-3.42.0)
10:48
Add News for the 3.42.0 release. (check-in: c0a70a8fb8 user: drh tags: trunk)
2023-05-12
17:36
Typos fixed and phrasing improved for the new JSON documentation. (check-in: 6d15d8641c user: drh tags: trunk)
2023-05-10
20:21
Update the stats in testing.html. (check-in: eba6dace26 user: drh tags: trunk)
15:55
Updates to the speed-size chart. (check-in: a985d90904 user: drh tags: trunk)
2023-05-08
20:17
Fix a typo in JSON documentation. (check-in: 43d43a2b97 user: drh tags: trunk)
18:47
Further clarifications of the change log for 3.42.0. (check-in: 9a10f6034e user: drh tags: trunk)
17:45
Additional clarification to the JSON5 enhancement documentation. (check-in: 6908866970 user: drh tags: trunk)
17:29
Mention the new omit-unused-subquery-columns optimization in the change log. (check-in: 4865999966 user: drh tags: trunk)
2023-05-05
20:23
Update the 3.42.0 change log to observe that the maximum JSON recursion depth has been reduced to 1000. (check-in: af7c12a5a0 user: drh tags: trunk)
15:49
Reduce the JSON maximum nesting depth to 1000. (check-in: 9a65bdf937 user: drh tags: trunk)
2023-05-04
20:20
Add documentation about the subsecond modifier to date/time functions in anticipation of merging that enhancement to trunk. (check-in: 16861f41cb user: drh tags: trunk)
17:35
Add the enhanced comma-option to the change log for 3.42.0. (check-in: 0109e019c4 user: drh tags: trunk)
2023-05-03
18:38
Minor enhancements to the JSON documentation. (check-in: 9fe07cb0bd user: drh tags: trunk)
2023-05-02
17:03
Add sqlite3_sleep() change to the change log. Fix typo in JSON docs. (check-in: e6a4cea8fe user: drh tags: trunk)
2023-05-01
23:11
Describe CLI --utf8 option in CLI doc page. (check-in: 5f7354370f user: larrybr tags: trunk)
22:47
In 3.42 changes, describe CLI --utf8 option accurately. (check-in: dc615631a6 user: larrybr tags: trunk)
21:49
Minor improvements to generate_series() vtab descriptions. (check-in: fbb30c2f25 user: larrybr tags: trunk)
18:27
More documentation tweaks in preparation for the 3.42.0. (check-in: 844b3af7fe user: drh tags: trunk)
17:59
Mention the session changes in the change log. (check-in: efa12463e2 user: drh tags: trunk)
17:02
Documentation of the JSON5 enhancement. (check-in: f77ffdbd60 user: drh tags: trunk)
15:58
Tweaks to the new change log. (check-in: 6cffa7f94f user: drh tags: trunk)
15:23
Initial attempt to add a change log for version 3.42.0 (check-in: 16a9216a09 user: drh tags: trunk)
2023-04-29
00:28
Cure a grammo in flextypegood noted in forum, plus a few more. (check-in: b487338450 user: larrybr tags: trunk)
2023-04-28
22:12
Revise generate_series() extension description to better reflect its behavior with negative step arguments (conforming to like-named PostgreSQL function.) (Closed-Leaf check-in: ab33979fd6 user: larrybr tags: generate_series)
2023-04-22
19:56
Document new CLI option, --unsafe-testing. (check-in: 5b301306f3 user: larrybr tags: trunk)
17:39
Clarify CLI response to .open with no db name. (check-in: c1f67a550d user: larrybr tags: trunk)
2023-04-19
10:53
Update fts5.in so that the trigram tokenizer is no longer described as "experimental". (check-in: 747cdcee0f user: dan tags: trunk)
01:14
Fix typo in "testing" noted in forum post a5dbe3a2bf. (check-in: 9437bdba44 user: larrybr tags: trunk)
2023-04-16
12:53
Fix typo in Quirks noted in forum post 6567786475. (check-in: c69640a74c user: larrybr tags: trunk)
2023-04-15
17:48
Add documentation for the 'secure-delete' option to fts5.in. (check-in: 5ceb265f3a user: dan tags: trunk)
15:42
Add documentation for 'secure-delete' to fts5.html. (Closed-Leaf check-in: 887ff60b31 user: dan tags: fts5-secure-delete)
2023-04-06
20:35
Add FAQ relating to puzzlements aided by DB auto-creation. (check-in: 58e66a9c19 user: larrybr tags: trunk)
2023-04-04
23:20
Express that last JSON fact absent perplexing repetition. (check-in: 92d830ab0e user: larrybr tags: trunk)
23:16
Mention absence of special treatment for Unicode escape sequences in JSON functions. (check-in: a572bb5a9f user: larrybr tags: trunk)
2023-03-31
19:57
Get interdependent pages/.in files to be separately processable (for make faster.) (Leaf check-in: 7d59751a5e user: larrybr tags: inout-of-tree)
2023-03-30
18:34
Say how unixepoch() deals with fractional seconds on input. (check-in: 30020367e9 user: larrybr tags: trunk)
2023-03-25
03:02
Clarify TCL eval subcommand option (non)plurality. (check-in: e34618cd04 user: larrybr tags: trunk)
2023-03-22
16:56
Document the new effect of the zero-padding option on floating point conversions of infinity and NaN. (check-in: 2325489f23 user: drh tags: trunk)
16:32
Update the documentation on the double-quoted string literal misfeature to mention that it is disabled by default beginning with version 3.41.0. (check-in: b11a9fe8cd user: drh tags: trunk)
15:10
Fix typos in the change log for 3.41.2 (check-in: b4cdb23bd8 user: drh tags: trunk)
12:00
Version 3.41.2 (check-in: 3ab894cf74 user: drh tags: trunk, release, version-3.41.2)
2023-03-20
10:33
Fix a mistake in the CAST documentation Forum post 52f446c028. (check-in: 0ad734f7eb user: drh tags: trunk)
2023-03-17
22:28
Clarify the argument needed for VACUUM INTO [filename]. (check-in: 36d7287b27 user: larrybr tags: trunk)
2023-03-14
14:31
Minor typo fix reported in forum post 13d539fe49 and clean up nearby EOL whitespace. (check-in: 5cce9b4a8a user: stephan tags: trunk)
2023-03-12
14:42
Remove mention of the obsolete SQLITE_ENABLE_JSON1 from the amalgamation build instructions. Remove nearby EOL whitespace. (check-in: 077be9663c user: stephan tags: trunk)
2023-03-10
12:19
Version 3.41.1 (check-in: 719bc8f8db user: drh tags: trunk, version-3.41.1)
11:42
Proposed changes for version 3.41.1. (check-in: bbe6fb07d9 user: drh tags: trunk)
2023-03-06
12:28
Address feedback from [forum:a228b4522b|forum post a228b4522b] and remove references to HAVE_USLEEP, per /chat. (check-in: b3f48779ee user: stephan tags: trunk)
2023-03-03
01:19
Complete (nearly) transition to explicit doc build output DEST dir. (check-in: c464faf208 user: larrybr tags: inout-of-tree)
2023-03-01
16:27
Fix the makefile so that it works again for out-of-tree builds. (check-in: 328608ba45 user: drh tags: trunk)
14:07
Fix typos in fts5.in. (check-in: 1d3b0b821c user: dan tags: trunk)
2023-02-28
11:22
Update recovery.html to mention that -DSQLITE_ENABLE_DBPAGE_VTAB is required. (check-in: 42c1edc161 user: dan tags: trunk)
2023-02-27
15:51
Revise build so that in-tree and out-of-tree make targets yield the same results, including side-effects. (check-in: e8d7950cd5 user: larrybr tags: trunk)
03:04
Make spell target work out-of-tree too. (Closed-Leaf check-in: 6bc167df1c user: larrybr tags: inout_of_tree)
02:07
Sync w/trunk (better spelling) (check-in: 75de411cc9 user: larrybr tags: inout_of_tree)
00:41
Spelling and spell-check improvements. (linecount /= 56) (check-in: 2f4ea6952b user: larrybr tags: trunk)
2023-02-24
16:53
Spelling fix for How to Compile (from forum) (check-in: 173dac530a user: larrybr tags: inout_of_tree)
16:52
Spelling fix for How to Compile (from forum) (check-in: 156e745d63 user: larrybr tags: trunk)
16:14
For evidence build, fail more gracefully for bad make arguments. (check-in: 69abfac43c user: larrybr tags: inout_of_tree)
15:49
Fix remaining relative filename stragglers. Zap adunit.txt injection. (check-in: d331039243 user: larrybr tags: inout_of_tree)
13:11
Fix a few relative filename stragglers. (check-in: 2d22dc4b94 user: larrybr tags: inout_of_tree)
03:00
WIP: Make doc builds work in-tree and out-of-tree. (check-in: 89771190f9 user: larrybr tags: inout_of_tree)
2023-02-23
15:37
Fix a grammo in DQS description. (check-in: 084d0b5c7b user: larrybr tags: trunk)
2023-02-22
21:47
Alleviate a distracting awkwardness in explication. (check-in: 4e18c20631 user: larrybr tags: trunk)
21:17
Get toc.db to tag along with full doc/*.html build. (check-in: be8b4e3939 user: larrybr tags: trunk)
2023-02-21
18:14
Version 3.41.0 (check-in: 6261fc49cc user: drh tags: trunk, release, version-3.41.0)
13:24
Update the speed-and-size spreadsheet. (check-in: eadd0bc3b2 user: drh tags: trunk)
12:52
Updates to the change log. (check-in: 538b6cb442 user: drh tags: trunk)
2023-02-20
00:00
Merge branch-3.40 changes into trunk. (check-in: 691c346bb0 user: drh tags: trunk)
2023-02-19
23:57
Updates to the text describing when RTree and Geopoly are available in amalgamation builds. (Leaf check-in: 58bfae254b user: drh tags: branch-3.40)
2023-02-17
15:36
Mention the CLI's new base64() and base85() SQL functions. (check-in: 768fdc131d user: larrybr tags: trunk)
13:24
Additional information about "struct iovec", as suggested by SQLite forum post 0bf2455d62a98da6. (check-in: bf6c5890c7 user: drh tags: trunk)
2023-02-16
21:36
Add a note to the secure_delete documentation to point out that forensic traces might be left behind in shadow tables of FTS3 and FTS5. (check-in: fc347f72ff user: drh tags: trunk)
21:08
Merge the latest version-3.40 updates into trunk. (check-in: 9ba00b285b user: drh tags: trunk)
21:06
Fix typo on the flextypegood.html page. (check-in: e562135c76 user: drh tags: branch-3.40)
18:10
Minor typo fix to flextypegood.in reported in the forum. (check-in: 647ebe8f73 user: stephan tags: trunk)
2023-02-15
20:50
Minor json_quote() typo fix reported in the forum. (check-in: 7962d5cbe2 user: stephan tags: trunk)
2023-02-14
21:05
Fix a typo in the new RETURNING documentation. (check-in: ccd08fd65d user: drh tags: trunk)
21:01
Add a clarification to the RETURNING documentation in response to forum post 935a08cbdc. (check-in: 2816414c3f user: drh tags: trunk)
00:22
Document the behavior change associated with excess parentheses around a subquery on the RHS of an IN operator. (check-in: e377133228 user: drh tags: trunk)
2023-02-11
21:06
Add mention of the "releasetest" and "devtest" makefile targets to the change log. (check-in: e7b6d071db user: drh tags: trunk)
20:57
Updates to the change log. Minor tweaks to other docs to which the change log refers. (check-in: e75646d8c9 user: drh tags: trunk)
2023-02-08
20:33
Back out the documentation changes associated with the 'txn' enhancement to the date/time functions, as that enhancement has been backed out of the core. (check-in: 97a9fca664 user: drh tags: trunk)
17:25
Update the change log and news in preparation for pencils-down on 3.41.0. (check-in: 77a236dd14 user: drh tags: trunk)
17:13
For matrix target, tell make of its full-build dependency. (check-in: 110b886945 user: larrybr tags: trunk)
12:39
Update documentation of date/time functions to talk about the new 'txn' format. (check-in: bddfe9ebb1 user: drh tags: trunk)
12:38
Prevent division-by-zero errors in the matrix computation. The matrix is currently broken, but at least now it builds. (check-in: 484bfc747f user: drh tags: trunk)
2023-01-31
06:09
Correct a trailing comma in a CREATE TABLE demonstration, reported in [forum:3d4940f6d549da66|forum post 3d4940f6d549da66]. (check-in: 87eafc5662 user: stephan tags: trunk)
2023-01-27
14:08
New items added to the change log. Carray documentation updated. (check-in: d98546fd71 user: drh tags: trunk)
13:42
Add documentation for the sqlite3_vtab_in_first() enhancement and the new unhex() SQL function. (check-in: 4c51970d12 user: drh tags: trunk)
02:15
Correct generate_series() mistakes noted in [forum:forumpost/c2101840f1|forum post c2101840f1]. (check-in: 96a13a1c67 user: larrybr tags: trunk)
2023-01-25
11:14
Correct typos noted in Forum post f381c42ab1. (check-in: 8e3ddbd5b8 user: drh tags: branch-3.40)
11:13
Change labels on the download page to say "SHA3-256" instead of just SHA3. (check-in: 54db71c83a user: drh tags: branch-3.40)
10:47
Correct typos noted in Forum post f381c42ab1. (check-in: 5702963af2 user: larrybr tags: trunk)
2023-01-21
23:07
Typo fixes in JSON documentation. (check-in: 7f680aab5f user: drh tags: trunk)
14:42
Fix subject-verb agreement in one sentence in the JSON documentation. (check-in: 82435642b2 user: drh tags: trunk)
2023-01-17
23:02
Parenthetically mention toleration of conflict resolution clause and absent effect in table CHECK constraints. (check-in: f846012243 user: larrybr tags: trunk)
2023-01-16
20:16
For object doc pages, show more clearly that the page is not a whole interface description. (check-in: 029730d32b user: larrybr tags: trunk)
2023-01-12
11:08
Describe sqlar_compress(X) more accurately. (check-in: 83fd668e46 user: larrybr tags: trunk)
2023-01-11
12:30
Fix typo in the windowfunctions.in document. (check-in: 8c7e9b6d4f user: drh tags: trunk)
2023-01-10
16:55
Fix typo on the quirks page. (check-in: 1e1a81e650 user: drh tags: trunk)
15:33
New quirk: SQLite destinguishes between integer and text literals. Forum post 887eeeeec5fc7185. (check-in: 86aa8a3e42 user: drh tags: trunk)
14:04
Note that errors produced by window function xFinal() calls made from within sqlite3_reset() or finalize() are ignored. (check-in: e164967b15 user: dan tags: trunk)
2023-01-09
18:50
Reflect clarified CLI help for .quit (check-in: 438918d8cb user: larrybr tags: trunk)
2023-01-07
01:13
Clarify what table types can be tracked with session extension. (check-in: 6d69233043 user: larrybr tags: trunk)
2023-01-06
11:00
Document Tcl interface preupdate subcommand. This also clears the last of the missing page fragment hyperlink targets. (So "make linkcheck" reports all internal links good.) (check-in: 70de644daf user: larrybr tags: trunk)
02:35
Say "SHA3-256" on hashes so nobody has to count hex digits. (check-in: 742c6eb7d1 user: larrybr tags: trunk)
00:45
Clear most missing page fragment link issues, and add tally of those to linkcheck make target. Defer Tcl interface doc improvement for separate check-in, so it now shows missing page fragments. (check-in: 6ea20767ad user: larrybr tags: trunk)
2023-01-04
16:25
Add the PRAGMA integrity_check enhancement to the change log. (check-in: a21b004e53 user: drh tags: trunk)
16:23
Merge the latest branch-3.40 changes into trunk. (check-in: 2d2e584cf1 user: drh tags: trunk)
16:18
The PRAGMA table-valued function feature is no longer experiemental. It is a long-established and stable feature that we depend upon. Update the docs to say as much. Cherry-picked onto the 3.40 branch by request of forum post a86299ccc3. (check-in: bfb7a9010a user: drh tags: branch-3.40)
16:14
Update the Expensify logo on the homepage to the latest version of their official logo. (check-in: 1b31b16a2d user: drh tags: branch-3.40)
2023-01-02
14:22
Add hyperlink checking tools. Fix broken links it found. Add CHECKOUT_ONLY make option to do doc builds using only version-controlled sources. Fix obscure bug in HTML parser. Collect relevant changes from branch-3.40 . (check-in: 7d17890956 user: larrybr tags: trunk)
13:47
Cherry-pick branch-3.40 changes (and fix internal links therein.) (Leaf check-in: 139fb64868 user: larrybr tags: docgen_tweaks)
13:05
Fix last of broken external hyperlinks and make Amazon ones amenable to the Amazon anti-scraping defense for URI checking. (check-in: bc15b4f45d user: larrybr tags: docgen_tweaks)
12:13
Mention the CVE-2022-38627 bug in Linear eMerge E3 - that it is not a bug in SQLite. (check-in: 36ae56152f user: drh tags: branch-3.40)
2023-01-01
13:39
Cure last of pagelink broken links. Cause linkcheck target to report internal broken hyperlinks. Fix a defensive measure that was unneeded. (check-in: 0fde681026 user: larrybr tags: docgen_tweaks)
05:04
Repair or zap a few more broken external links, and make pagelink collector stop making one. (check-in: 92c5d2b96a user: larrybr tags: docgen_tweaks)
02:41
Fix several broken links, tag a few as "Obsolete URL", and make urlcheck do a GET if server dislikes HEAD requests. (check-in: d18aaf5bcc user: larrybr tags: docgen_tweaks)
2022-12-31
21:51
Add hyperlink checking tools, and repair a number of their finds. (More such to come.) (check-in: ee9b2ca94a user: larrybr tags: docgen_tweaks)
12:59
Add a reference to CVE-2022-38627, and in particular point out that this is not a bug in SQLite but rather an ordinary application bug. But put the change on a branch for now in as much as the CVE has not yet been published. (Leaf check-in: 3c86a0cf4e user: drh tags: cve-2022-38627)
2022-12-30
08:43
Repair sign flub in last checkin. (check-in: dfc107ba6e user: larrybr tags: trunk)
08:37
Repair missed typo in last checkin. (check-in: 5d1866d343 user: larrybr tags: trunk)
08:32
Reduce needless file writes and improve repeatability of generated docs. (check-in: b6040cfca7 user: larrybr tags: trunk)
2022-12-28
14:56
Version 3.40.1 added. (check-in: f5e5c2522a user: larrybr tags: trunk)
14:21
Fix the chronology for the 3.40.1 release. (check-in: b802cae15f user: drh tags: branch-3.40)
14:07
Version 3.40.1 (check-in: 34b764b935 user: drh tags: branch-3.40, version-3.40.1)
2022-12-27
17:04
Typo fixes (check-in: 3c8001c550 user: drh tags: branch-3.40)
16:51
First attempt at a change log for version 3.40.1. (check-in: 0a336afd3f user: drh tags: branch-3.40)
2022-12-25
13:08
The PRAGMA table-valued function feature is no longer experiemental. It is a long-established and stable feature that we depend upon. Update the docs to say as much. (check-in: 2a5f5900ae user: drh tags: trunk)
2022-12-24
03:30
Fix broken link in changes page. (check-in: c368021c60 user: larrybr tags: trunk)
02:36
Fix a debugging aid nit in check-in just done. (check-in: 91f34d1674 user: larrybr tags: trunk)
02:22
Doc nits cleaned: some broken obscure links, slight misstatements, and coding standard deviations where files touched for other reasons. (check-in: 2b34c1ca6e user: larrybr tags: trunk)
2022-12-23
22:19
Revise regen_version_list.tcl to handle pending versions (with xxx* as hashes.) (check-in: ef82964086 user: larrybr tags: trunk)
17:03
Update the SQLITE_ENABLE_STMT_SCANSTATUS documentation to mention the new sqlite3_stmt_scanstatus_v2() interface. (check-in: 06cdb4d26b user: drh tags: trunk)
16:57
Fix the hyperlink for the timeline on the snapshot tarball in the download page. (check-in: e457beb94c user: drh tags: branch-3.40)
16:35
Fix a minor bug in the chronology page generator. (check-in: 27453d32ef user: drh tags: trunk)
16:33
Add a preliminary change log entry for version 3.41.0. Update the chronology.html page so that it is able to show a pending release. (check-in: 71f3af2b59 user: drh tags: trunk)
15:32
Move the generated database files from the source directory to the build directory, in order to support separate compilation. (check-in: d028313581 user: drh tags: trunk)
05:53
Minor improvements and nit removal for the docs build. (check-in: 1e14ef5d18 user: larrybr tags: docgen_tweaks)
2022-12-22
16:25
Repair broken fossil invocation for "last modified ..." footers, and final docgen code polish. (check-in: 38c3987fad user: larrybr tags: trunk)
09:11
Final polishing of code changes associated with incremental docs build. (Ready to be relearned years later!) Fix "last modified on ... footer", broken sometime this fall. (Closed-Leaf check-in: fc97ab336e user: larrybr tags: docgen_speedup)
2022-12-21
04:58
Detect and fail incremental doc build for broken links where an uptodate source links to a gone-missing tag definition in an outdated source. Also cleanup a few minor deviations from project coding standard and move a few Tcl functions to the sources that use them (because that makes incremental builds work simply.) (check-in: 9366017013 user: larrybr tags: trunk)
04:41
Sync w/trunk and move some Tcl procs to where they are used to make build more incremental-friendly. (check-in: a7b22a1fb3 user: larrybr tags: docgen_speedup)
2022-12-20
22:37
For incremental doc builds, detect and report broken links where an uptodate source links to a (vanished) tag definition in an outdated source. Also cleanup a few minor deviations from project coding standard. (check-in: f41bf5214d user: larrybr tags: docgen_speedup)
2022-12-18
03:44
Correct overly restrictive language on row value usage in expressions doc, as noted in forum post 37b7b3ffe5. (check-in: db474f5440 user: larrybr tags: trunk)
2022-12-16
18:12
Add CVE-2022-46908 to the cves.html page. (check-in: 89ebe2f98c user: drh tags: branch-3.40)
18:11
Show non-obvious syntax for "function" subcommand in Tcl interface. (check-in: 05b92b3a1f user: drh tags: branch-3.40)
18:11
That whentouse.html update should have gone onto the current website, not the previous 3.39 release. Silly error on my part. Merging it in now. (check-in: b3753a6c22 user: drh tags: branch-3.40)
18:10
verison/version typo fix reported in [forum:f031a21c33]. (check-in: 0ee60d8811 user: drh tags: branch-3.40)
17:48
Doc build speed and convenience improvements. Run bare "make" for details. (check-in: 4a0d21d374 user: larrybr tags: trunk)
16:09
Add make target, "versions", to update the release versions info list (if applicable.) (check-in: 6c7dececc0 user: larrybr tags: docgen_speedup)
07:01
During .in to .html transformation, generate HTML object ids in a way that makes them repeatable for a given input regardless of what other inputs are transformed. (check-in: 85d41d0759 user: larrybr tags: docgen_speedup)
02:29
Incremental build compendium docs made to match full build. Code commented to better reflect function and cleaned up. Utility added for hashing output files and comparing to prior build. Diagnostic aids internally documented. Routine console output prettified. The toc.db output seems to be right, but this needs more testing for incremental build. Otherwise, the incremental build is yielding the same doc/* content as full builds. (check-in: 88746bb189 user: larrybr tags: docgen_speedup)
2022-12-14
16:29
Add CVE-2022-46908 to the cves.html page. (check-in: ed8b29927c user: drh tags: trunk)
16:19
Show non-obvious syntax for "function" subcommand in Tcl interface. (check-in: d3e3cc3bfa user: larrybr tags: trunk)
16:05
That whentouse.html update should have gone onto the current website, not the previous 3.39 release. Silly error on my part. Merging it in now. (check-in: af9dbc5e48 user: drh tags: trunk)
16:04
Add a link from the "whentouse.html" page to the HN discussion from yesterday about using SQLite for websites. (Leaf check-in: 5ee6756831 user: drh tags: branch-3.39)
11:53
verison/version typo fix reported in [forum:f031a21c33]. (check-in: afd799ca78 user: stephan tags: trunk)
2022-12-13
04:30
Improve diagnostic aids for doc build. Separate some code from *.in data for simpler version history, and eliminate manual editing for that. Centralize link gathering logic. Add fibbing feature to ease testing incremental build correctness. Make doc_vardump.txt useful from tclsh. (check-in: 5070206cc3 user: larrybr tags: docgen_speedup)
2022-12-11
03:50
Incremental build output made to md5-match full build output, including cross-ref mondo-pages. Optional reporting, and tidier default reporting. Probably suitable for builds pushed to website. (check-in: 50fea4d911 user: larrybr tags: docgen_speedup)
2022-12-10
04:02
Some code and comment cleanup, and better protection of full build from incremental build side-effects. Ready for regular doc maintenance, provided full build used for publication. (check-in: ad4140d782 user: larrybr tags: docgen_speedup)
2022-12-09
23:36
Incremental doc gen is basically working. Needs stress and corner-case testing and some code cleanup. (check-in: 705abdfe28 user: larrybr tags: docgen_speedup)
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". (check-in: 40122d32eb user: larrybr tags: docgen_speedup)
21:19
Fix formatting and other errors in profile.in. (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. (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: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)
2021-03-02
01:56
Get docsapp to work (again), faster, with some --help output. More cleanup degrees. (check-in: 9b916b865b user: larrybr tags: build_de-nit)