Documentation Source Text

Timeline
Login

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

100 most recent check-ins

2024-04-20
09:25
Remove all stray ^ characters from fileformat2.in, as reported in the forum. Let's defer doing this for the time being. We may start paying attention to the requirements marks again in the future. Closed-Leaf check-in: 4f2e9c3ad9 user: stephan tags: rm-requirements-marks
2024-04-16
17:31
Add documentation for the fts5-tokenize-blob feature. Leaf check-in: c13d10c92b user: dan tags: trunk
17:29
Add documentation for the fts5-tokenize-blob feature. Closed-Leaf check-in: 98b0894622 user: dan tags: fts5-tokenize-blob
17:22
Fix a few misspellings and grammos. Leaf check-in: 0d60a97545 user: drh tags: branch-3.45
16:29
Fix a few misspellings and grammos. check-in: 4159d99277 user: larrybr tags: trunk
16:22
Small typo fix reported in the forum. check-in: 21630b76fa user: stephan tags: trunk
2024-04-15
16:14
Merge version 3.45.3 changes into trunk. check-in: 692e7b884b user: drh tags: trunk
13:38
Fix the chronology hyperlink for 3.43.3. check-in: 2ead592612 user: drh tags: branch-3.45
13:35
Version 3.43.3 check-in: 21fbec6712 user: drh tags: branch-3.45, version-3.43.3
2024-04-14
08:37
Typo corrections pointed out in the forum. check-in: 850ebf3ca3 user: stephan tags: trunk
2024-04-11
23:26
Note that recursive_triggers=ON is required in order for triggers to work on an UPSERT. Incorrect. Closed-Leaf check-in: 2458723900 user: drh tags: mistake
23:25
Note that recursive_triggers=ON is required in order for triggers to work on an UPSERT. Incorrect. Closed-Leaf check-in: 67ebe77731 user: drh tags: mistake
2024-04-10
13:05
Disambiguate the WHERE-clause push-down optimization and the MySQL push-down optimization. check-in: 798b43b807 user: drh tags: trunk
2024-04-08
14:35
Remove from lockingv3.in statements that have not been true since version 3.6.5. check-in: 51cd7696f7 user: drh tags: branch-3.45
14:25
Remove from lockingv3.in statements that have not been true since version 3.6.5. check-in: 165f1390af user: dan tags: trunk
12:00
Mention the WHERE-clause push-down enhancement in the change log. check-in: e3bd48c44b user: drh tags: trunk
2024-04-06
13:49
Typo fix reported in the forum. check-in: 0bd0f5d49f user: stephan tags: trunk
10:42
Fix typo. check-in: 0a1c9b0dc2 user: drh tags: branch-3.45
2024-04-03
17:48
Update the whentouse.in document to use the table-of-contents layout. check-in: b0aa39be7a user: drh tags: trunk
15:38
Tweaks to the change log for 3.46.0. check-in: 9a9404ea20 user: drh tags: trunk
2024-04-01
12:41
Add links to window functions, math functions, and JSON functions to the index on the main SQL syntax page. check-in: ba3f8dcd16 user: drh tags: trunk
2024-03-29
20:57
Fix typo in the pragma optimize documentation. check-in: b7af73016b user: drh tags: trunk
20:49
More tweaks to the date/time function documentation. check-in: 2b52ce704e user: drh tags: trunk
17:56
Improved formatting (less whitespace) in the time-value format table. check-in: b665a4c6ef user: drh tags: trunk
17:49
Attempted improvement to the date/time function documentation. check-in: 5a2217dc58 user: drh tags: trunk
2024-03-28
14:56
Improved wording in the change log for the VALUES-as-coroutine optimization. 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. 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