Documentation Source Text

Timeline
Login

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

97 check-ins using file misc/speed-size-graph.ods version fe46bb372d

2024-05-03
13:42
Merge fixes from branch-3.45. (Leaf check-in: 4e25d45c61 user: drh tags: trunk)
13:40
Merge the whybytecode.html document from trunk. (Leaf check-in: a05afdfc7e user: drh tags: branch-3.45)
2024-05-02
15:36
Remove duplicate and add missing version in the chronology. (check-in: fb255cbab7 user: drh tags: branch-3.45)
2024-04-30
18:42
Typo fixes in whybytecode.in (check-in: a782f794d2 user: drh tags: trunk)
11:52
Typo fixes. (check-in: f5b9f3aa3f user: drh tags: trunk)
07:42
Typo fix for the typo fix reported in HN :/. (check-in: a3181d323e user: stephan tags: trunk)
07:40
Typo reported in HackerNews. (check-in: 349a8a3604 user: stephan tags: trunk)
2024-04-29
20:04
More tweaks to the Why SQLite Uses Bytecode document. (check-in: 1cef10271b user: drh tags: trunk)
17:33
First attempt at a document explaining the advantages of using a bytecode representation for prepare statement versus a tree-of-objects representation. (check-in: cb56cf7dc4 user: drh tags: trunk)
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. (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. (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)