Documentation Source Text

Timeline
Login

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

100 most recent check-ins

2024-05-11
12:18
Improvements to the documentation on SELECT. Leaf check-in: 6c098a483d user: drh tags: trunk
2024-05-10
14:30
Fix a hyperlink broken by the previous merge. Leaf check-in: 780800b996 user: drh tags: branch-3.45
14:25
Merge recent query planner documentation enhancements into branch-3.45. check-in: 4f5b524372 user: drh tags: branch-3.45
14:15
A few more tweaks to query planner documentation. check-in: 9316ff2178 user: drh tags: trunk
13:53
Further improvements to the optimizer documentation. check-in: 11a5959318 user: drh tags: trunk
11:16
Updates to the query planner documents. This is but one small change in what will probably end up being a long series of improvements. check-in: a422b5fc9e user: drh tags: trunk
2024-05-09
21:15
Updates to my bio. check-in: f1f24a1ccd user: mistachkin tags: trunk
17:38
Fix typo in whybytecode.in check-in: 2437e6ca83 user: drh tags: trunk
17:36
Add "query-time index" as an alternative to "automatic index". check-in: 13bb2276fe user: drh tags: trunk
08:10
Typo fix and minor touchups in the SQLITE_API_ARMOR docs. check-in: b80a033d21 user: stephan tags: trunk
2024-05-08
20:36
Add a new subsection heading for the new text about processing order in RETURNING. check-in: 1b6cbdcf7b user: drh tags: trunk
20:29
Yet another typo fix in RETURNING. check-in: e61a00322e user: drh tags: trunk
20:22
Typo fix in the previous. check-in: 3db153b673 user: drh tags: trunk
20:19
Clarification to processing order guarantees in RETURNING. check-in: 2d9c974b24 user: drh tags: trunk
15:03
Correct the rowids of the structure and averages records in fts5.in. check-in: 0252f3c8d0 user: dan tags: trunk
11:54
Merge typo fixes from branch-3.45. check-in: 74dccaaa81 user: drh tags: trunk
11:51
Move the projected release date for 3.46.0 to 2024-05-28. check-in: 63c02f76eb user: drh tags: trunk
2024-05-07
11:26
Omit a reference to 300MiB in the same document fixed by the previous check-in. check-in: 8caa8047af user: drh tags: branch-3.45
11:21
Document that the trigram index cannot be used to optimize LIKE expressions if there is an ESCAPE clause. check-in: 8361d1fd9f user: dan tags: trunk
11:18
Remove documentation for abandoned fts5-tokenize-blob feature. check-in: 57fc36aec7 user: dan tags: trunk
11:17
Fix the library size boast on the "different.html" page. check-in: 029d9bbfcb user: drh tags: branch-3.45
2024-05-06
16:22
pages/compile.in: clarify that _HAVE_SQLITE_CONFIG_H is only intended for platform-level configuration and add a description of SQLITE_CUSTOM_INCLUDE. check-in: 210ea1a5d2 user: stephan tags: trunk
2024-05-05
15:23
Cherry pick multiple typo fixes and clarifications from trunk. check-in: f693014132 user: drh tags: branch-3.45
12:57
Typo fix reported in the forum. check-in: fa34ee74c9 user: stephan tags: trunk
2024-05-04
21:13
Typo fix reported in the forum. check-in: 4d4a2abffe user: stephan tags: trunk
20:54
Typo fix reported in the forum. check-in: 2a2b9b5820 user: stephan tags: trunk
19:31
Minor clarification in lang_analyze.in suggested in forum post 52de622df1. check-in: ac0eec29fc user: stephan tags: trunk
16:12
Update _HAVE_SQLITE_CONFIG_H docs to refer to sqlite_cfg.h instead of config.h. check-in: bae8bc0810 user: stephan tags: trunk
2024-05-03
13:42
Merge fixes from branch-3.45. check-in: 4e25d45c61 user: drh tags: trunk
13:40
Merge the whybytecode.html document from trunk. 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