Documentation Source Text

Timeline
Login

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

50 most recent check-ins that include changes to files matching 'art/*'

2024-02-27
20:15
Document the added support for readablility underscores in numeric literals. (check-in: c92361d424 user: drh tags: trunk)
2023-12-05
14:43
Merge the latest trunk changes into the jsonb branch. Update with the latest documentation about JSONB. (check-in: 3b673fad86 user: drh tags: jsonb)
2023-10-24
19:12
Add the new "function-arguments" non-terminal to the bubble diagrams. (check-in: 4cf6e8d252 user: drh tags: trunk)
17:23
Update syntax_linkage.tcl so that the new ordering-term non-terminal is linked from aggregate-function-invocation. (check-in: e028522ec2 user: drh tags: trunk)
17:10
Get ORDER BY into aggregate function invoke diagram. (check-in: 1391a28657 user: larrybr tags: trunk)
2023-10-17
22:48
In UPDATE with limit syntax diagram, get returning-clause independent of WHERE. See forum post d8f57775be. (check-in: 855a4e88ef user: drh tags: branch-3.43)
22:10
In UPDATE with limit syntax diagram, get returning-clause independent of WHERE. See forum post d8f57775be. (check-in: 2aab6634b5 user: larrybr tags: trunk)
2022-06-21
14:41
Update syntax diagrams to show that you can have a HAVING clause without a GROUP BY. (check-in: 4195254582 user: drh tags: trunk)
2022-05-12
15:23
Documentation for IS DISTINCT FROM and IS NOT DISTINCT FROM. (check-in: ee6304ed53 user: drh tags: trunk)
2022-04-18
02:55
sync w/trunk in preparation for extensible shell doc update and creation (check-in: 6614946a15 user: larrybr tags: cli_extension)
2022-04-13
13:11
Update the change log, syntax diagrams, and SELECT documentation to describe RIGHT and FULL JOIN. More work to be done on this. (check-in: 7dc766ebe1 user: drh tags: trunk)
2021-09-24
00:28
Correct over-lenient delete ... order by limit syntax diagram. (Per https://sqlite.org/forum/forumpost/35b89409e5 ) (check-in: 0ab7d5fa06 user: larrybr tags: trunk)
2021-08-20
15:48
Initial documentation for STRICT tables. (check-in: a62eba124d user: drh tags: trunk)
00:18
Document new STRICT table option (check-in: e668c1ce28 user: larrybr tags: strict-tables)
2021-07-18
17:27
In big expr railroad chart, make only LIKE get an ESCAPE clause. (check-in: 6fa8195610 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-10
00:24
Merge in fixes from branch-3.35. (check-in: a91ad6f8ef 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-23
13:15
Merge in the latest branch-3.35 changes. (check-in: 1545c4fd49 user: drh 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-22
01:28
Clarity tweaks to FROM clause diagrams. (check-in: 53e9fbe353 user: larrybr tags: trunk)
00:46
Add join-clause into empty FROM clause list path of SELECT syntax diagrams. (check-in: 53a0a96734 user: larrybr tags: trunk)
2021-02-22
15:59
Merge the materialization hint documentation to trunk. (check-in: 9fc8e65396 user: drh tags: trunk)
15:27
Documentation on the materialization hints. (check-in: 01faf091f4 user: drh tags: as-materialized-redux)
2021-02-19
14:17
Add documentation for ALTER TABLE DROP COLUMN. (check-in: 9682d5370f user: drh tags: trunk)
2021-02-03
16:07
Merge the RETURNING changes. (check-in: bcc98c0be1 user: drh tags: trunk)
2021-02-01
21:53
Add the RETURNING clause to the UPDATE/DELETE statements with LIMIT. (check-in: d3182cdbb6 user: drh tags: returning)
19:20
Update the DELETE, INSERT, and UPDATE syntax diagrams to show the RETURNING clause. Still need to do delete-stmt-limited and update-stmt-limited. (check-in: fc9711b569 user: drh tags: returning)
13:50
Add a syntax diagram for the RETURNING clause. (check-in: afce2544ec user: drh tags: returning)
2021-01-04
00:51
Merge enhancements from the 3.34 branch. (check-in: 75f07e5d08 user: drh tags: trunk)
00:49
If a missing "expr" box on the unary-operator branch of the expr syntax diagram. SQLite forum post 866a754699 (check-in: 8164556750 user: drh tags: branch-3.34)
2020-12-14
15:02
Merge the UPSERT enhancements. Update the change log. (check-in: 9d0d26d35f user: drh tags: trunk)
2020-12-08
15:30
Documentation for the proposed generalizations to UPSERT. (Closed-Leaf check-in: d7320caafa user: drh tags: generalized-upsert)
2020-10-11
01:24
Remove a test file accidentally committed. (check-in: 8ded4bd270 user: drh tags: trunk)
2020-10-01
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-26
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
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)