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/*'

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)
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)
11:25
Lighter background color for "select-core" within "select-stmt" (check-in: e8177053e8 user: drh tags: svg-syntax)
05:31
select-stmt, with a tinted background for the select-core. (check-in: 296f548eeb user: drh tags: svg-syntax)
04:22
select-core (check-in: 405151ac80 user: drh tags: svg-syntax)
01:14
savepoint-stmt (check-in: 8698f49d49 user: drh tags: svg-syntax)
01:11
release-stmt, result-column, and rollback-stmt (check-in: 0fa36afc9b user: drh tags: svg-syntax)
00:45
raise-function, recursive-cte, and reindex-stmt (check-in: 25e8db2da4 user: drh tags: svg-syntax)
00:14
pragma-stmt, pragma-value, and qualified-table-name (check-in: 197fb70d06 user: drh tags: svg-syntax)
2020-09-23
21:26
over-clause (check-in: 03e44f6545 user: drh tags: svg-syntax)
20:00
Unmanage a couple of unused and obsolete syntax GIFs (check-in: ec5f4852e3 user: drh tags: svg-syntax)
19:51
numeric-literal and ordering-term (check-in: e5ef88d2b2 user: drh tags: svg-syntax)
18:44
Four new smaller diagrams. (check-in: 81e15dd8f8 user: drh tags: svg-syntax)
15:16
insert-stmt (check-in: b2c60f5d3a user: drh tags: svg-syntax)
12:59
indexed-column (check-in: 9437f9afd4 user: drh tags: svg-syntax)
12:39
frame-spec (check-in: 5c4e4507e5 user: drh tags: svg-syntax)
01:02
factored-select-stmt, filter-clause, and foreign-key-clause (check-in: 2ffb8b43ab user: drh tags: svg-syntax)
2020-09-22
23:11
Add the expr diagram. (check-in: 8b533b0b3d user: drh tags: svg-syntax)
18:34
Add the various DROP statements (check-in: fc300ff912 user: drh tags: svg-syntax)
17:56
Add cte-table-name, delete-stmt, and delete-stmt-limited. (check-in: 2b6dd6d053 user: drh tags: svg-syntax)
16:52
Add the create-view-stmt and create-virtual-table-stmt diagrams. (check-in: 107702e238 user: drh tags: svg-syntax)
15:44
Add the create-trigger-stmt. The arrows on FOR EACH ROW and WHEN expr seem a little confused. We might want to revisit the design later. (check-in: 91293e0c33 user: drh tags: svg-syntax)
14:39
Minor tweaks to create-table-stmt (check-in: 73f92ad202 user: drh tags: svg-syntax)
13:49
Adding conflict-clause, create-index-stmt, and create-table-stmt (check-in: 7c5c929fe7 user: drh tags: svg-syntax)