Documentation Source Text

Timeline
Login

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

50 most recent check-ins

2021-06-18
13:44
Merge the wapp.tcl fix. (Leaf 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)