Documentation Source Text

Timeline
Login

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

50 most recent check-ins

2020-11-25
18:23
Remove obsolete GIF syntax diagram processing logic (Leaf check-in: 77e66d0f02 user: drh tags: trunk)
13:10
Clarify the differences between xFindFunction and xBestIndex with regard to handling the argument swapping behavior of LIKE, GLOB, REGEXP, and MATCH. See forum post 9440862379. (check-in: 2d468b65df user: drh tags: trunk)
2020-11-24
23:40
Fix typos. (check-in: 89ad8f9c2c user: drh tags: trunk)
2020-11-23
14:55
Allow substring() as an alias for substr(). (check-in: 33b7cf7178 user: drh tags: trunk)
2020-11-19
16:35
Fix some errors in the window functions documentation. (check-in: 29a58418bc user: dan tags: trunk)
2020-11-18
14:36
Fix a hyperlink in the carray documentation. (check-in: 46262280d2 user: drh tags: trunk)
2020-11-17
15:09
Add documentation for the single-argument variant of carray. Fix a broken hyperlink in rescode.in. (check-in: 8ac0887660 user: drh tags: trunk)
2020-11-16
12:03
Merge changes from the 3.33 branch. (check-in: 8bdbb88c52 user: drh tags: trunk)
2020-11-15
13:16
In althttpd.c, fix a potential NULL ptr dereference following a CGI that returns an empty string. (check-in: c1e08a3709 user: drh tags: trunk)
2020-11-09
13:42
Update the rescode.html document with recently added result codes. (check-in: c57bdcc203 user: drh tags: trunk)
2020-11-02
14:01
Clarify wording of recursive CTE documentation. (check-in: 6dc65b8b9b user: drh tags: trunk)
2020-10-31
19:26
Add the addition of --tabs to the change log. (check-in: 56c9757fd3 user: drh tags: trunk)
14:46
Put a public domain notice on the althttpd.c file. (check-in: 46a8eeecdf user: drh tags: trunk)
2020-10-23
16:07
Add semrushbot to the list of disallowed user agents in althttpd.c. (check-in: 6da69d0669 user: drh tags: trunk)
2020-10-21
04:40
Fix typos in lang_with.html (check-in: 1e7aae0b46 user: drh tags: trunk)
2020-10-20
19:05
Enhance the "timeline" link on the prerelease snapshot to use the p= and bt= query parameters in order to see all branches that have contributed to the build product. (Leaf check-in: 6346afca54 user: drh tags: branch-3.33)
18:58
Fix typos and improve wording in release notes. (check-in: 470ac01c42 user: drh tags: trunk)
2020-10-19
13:20
Document the ability to use a compound SELECT for the recursive portion of a recursive CTE. (check-in: 92cd57163d user: drh tags: trunk)
2020-10-14
19:14
Update the change log for 3.34.0 (check-in: ecc48e8715 user: drh tags: trunk)
2020-10-13
15:50
Minor tweaks to the whynotgit document. (check-in: d9a09974a2 user: drh tags: trunk)
2020-10-11
01:24
Remove a test file accidentally committed. (check-in: 8ded4bd270 user: drh tags: trunk)
2020-10-09
15:05
Merge changes from the 3.33 branch. (check-in: 57b76a1da9 user: drh tags: trunk)
15:02
Update the purchase options to the new purchase scripts. (check-in: 5ca88ff9db user: drh tags: branch-3.33)
2020-10-05
17:03
When building the full-text index, ignore <svg> blocks. (check-in: dd8aef912e user: dan tags: trunk)
16:42
Add documentation for the new experimental fts5 tokenizer "trigram". (check-in: a1963591a6 user: dan tags: trunk)
2020-10-04
00:24
Clarifications on the behavior of the NUMERIC affinity and on the affinity of result columns in compound SELECT statements. (check-in: b19a0e3fa8 user: drh tags: trunk)
2020-10-02
15:55
Merge 3.33 documentation fixes into trunk. (check-in: 04cbabd493 user: drh tags: trunk)
15:51
Fix typos in the floatingpoint.html document. (check-in: 103f72eade user: drh tags: branch-3.33)
15:47
Fix typos in the floatingpoint.html document. (check-in: 1d1c9d7ad7 user: drh tags: trunk)
2020-10-01
20:13
Enhance the renderer so that any Pikchr source text with <pikchr>...</pikchr> is automatically converted into SVG. (check-in: 15b15f7ace user: drh tags: trunk)
19:39
Add the ability to translate Pikchr text to the TCL interpreter used to build the website. Omit all of the *.svg files from the check-in because they are now generated at compile-time directly from the *.pikchr files. All SVG is inline instead of being in separately loaded files. (check-in: 64e6c50273 user: drh tags: trunk)
18:23
Put all of the syntax diagrams in-line rather than loading them as separate files. (check-in: 285efd6656 user: drh tags: trunk)
2020-09-30
12:16
Fix typos in the arch.html document. (check-in: b6873d1f98 user: drh tags: branch-3.33)
2020-09-27
11:54
Fix typo in famous.html (check-in: 9013ecdf63 user: drh tags: branch-3.33)
2020-09-26
22:45
Update the FAQ to describe the new syntax diagram technology. (check-in: 2966044012 user: drh tags: trunk)
22:31
Generate syntax diagrams using Pikchr (check-in: 9f5383c824 user: drh tags: trunk)
22:29
Create a TCL script that converts all *.pikchr files into *.svg files and constructs syntax_linkage and syntax_order. Clean up legacy. (Closed-Leaf check-in: c877e0ff4a user: drh tags: svg-syntax)
2020-09-25
17:27
Fix syntax diagram linkage so that it always goes to SVGs, never to GIFs. (check-in: 2280617160 user: drh tags: svg-syntax)
16:45
Remove the old Tk script for generating syntax diagrams. Patch up the Makefile. Still to do:
  1. Automate generation of the syntax_linkage.tcl file
  2. Include pikchr source code in the source tree
  3. README.md file explaining how to implement the syntax diagram pikchr scripts and how to build the SVG files
  4. Improve some of the existing diagrams
(check-in: ec5c7e80fa user: drh tags: svg-syntax)
16:39
Last three GIFs converted. (check-in: 05c85f544f user: drh tags: svg-syntax)
16:17
upsert-clause, vacuum-stmt, and window-definition (check-in: c864439cba user: drh tags: svg-syntax)
15:23
type-name, update-stmt, and update-stmt-limited (check-in: 9d6aaa6c11 user: drh tags: svg-syntax)
13:03
table-or-subquery (check-in: 1776394058 user: drh tags: svg-syntax)
2020-09-24
20:53
table-constraint (check-in: 34d929e01e user: drh tags: svg-syntax)
14:37
sql-stmt-list (check-in: 8f63a61ff7 user: drh tags: svg-syntax)
14:24
sql-stmt (check-in: 7ea65ac585 user: drh tags: svg-syntax)
13:46
simple-function-invocation and simple-select-stmt. (check-in: 305dc14430 user: drh tags: svg-syntax)
13:11
signed-number (check-in: 65b46ed928 user: drh tags: svg-syntax)
12:39
Minor tweaks to select-stmt. (check-in: 73084eb917 user: drh tags: svg-syntax)
11:53
No background color at all on the select-core subset of select-stmt - just a gray border. (check-in: aa884bd27e user: drh tags: svg-syntax)