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

2020-09-22
02:56
Minor tweaks to the compound-select-stmt diagram. (Leaf check-in: abec402383 user: drh tags: svg-syntax)
02:50
Add the Pikchr version of compound-select-stmt (check-in: 44f0ca00e5 user: drh tags: svg-syntax)
00:40
Add syntax diagrams through compound-operator (check-in: aa50764739 user: drh tags: svg-syntax)
2020-09-21
22:56
Add the column-def and column-name-list diagrams in SVG (check-in: 18d0a89fc6 user: drh tags: svg-syntax)
20:53
Add the column-constraint diagram. 151 lines of Pikchr. (check-in: fe260f0054 user: drh tags: svg-syntax)
19:49
Add pikchr scripts for attach-stmt and begin-stmt. (check-in: 7b336eb761 user: drh tags: svg-syntax)
19:20
Add analyze-stmt.pikchr (check-in: 95d38371c5 user: drh tags: svg-syntax)
17:49
Add Pikchr for aggregate-function-invocation. Realize now that I need to work on replicating the syntax_linkage.tcl data. (check-in: e25d0c295b user: drh tags: svg-syntax)
14:56
Extract the width of each SVG and add a max-width to the <img> (check-in: c82a99b440 user: drh tags: svg-syntax)
14:23
Add infrastructure for porting syntax diagrams to SVG. (check-in: 277011128a user: drh tags: svg-syntax)
2020-07-18
16:35
Documentation for UPDATE FROM. (check-in: ba3810c515 user: drh tags: trunk)
2020-07-17
17:35
Revise syntax diagrams to include the FROM clause on UPDATE statements. (Closed-Leaf check-in: bd9cdee968 user: drh tags: update-from)
2020-05-20
01:27
Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause. (check-in: 8b88f8f240 user: drh tags: branch-3.31)
01:24
Fix the INSERT syntax diagram so that it is not possible to go from DEFAULT VALUES to the upsert-clause. (check-in: e42edf1dd3 user: drh tags: trunk)
2019-10-29
01:24
Begin adding documentation for generated columns. (check-in: a558a79107 user: drh tags: trunk)
2019-08-29
17:19
Add a description of NULLS FIRST and NULLS LAST. Add a note about the addition of sqlite3_drop_modules(). (check-in: a7856e4125 user: drh tags: trunk)
2019-07-15
19:25
Update syntax diagrams to show the FILTER clause on aggregate functions. Start a change log for version 3.30.0. (check-in: ba9800704d user: drh tags: trunk)
2019-07-13
16:24
Remove obsolete and unsupported BNF and TEXT representations of the grammar. (check-in: b02f76d76f user: drh tags: trunk)
2019-03-28
20:22
Remove the "expr FOLLOWING" case from frame-specs that only describe the starting boundary. (check-in: 5eff6feebc user: drh tags: trunk)
15:23
In the window-defn bubble diagram, change "existing-window-name" to "base-window-name" and make it an indentifier instead of a non-terminal. (check-in: 67d1075ce3 user: drh tags: trunk)
15:15
Improved railroad diagram for frame-spec. (check-in: 6598d28114 user: drh tags: trunk)
2019-03-26
13:11
Update window functions documentation. (check-in: bdc2a67078 user: dan tags: trunk)
2019-03-25
20:49
Update documentation to match the proposed window function changes. (Closed-Leaf check-in: 783032878d user: dan tags: window-functions)
2019-01-09
19:56
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. (check-in: fd152b335d user: drh tags: branch-3.26)
19:54
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. (check-in: 83da33aabc user: drh tags: trunk)
2018-12-09
22:23
Preliminary documentation for VACUUM INTO (check-in: 130193a5b9 user: drh tags: trunk)
2018-09-06
21:37
Improvements to the RENAME COLUMN syntax diagram. (check-in: c951c8c482 user: drh tags: trunk)
20:05
Update the ALTER TABLE bubble diagram to show the RENAME COLUMN syntax. (check-in: f995368f57 user: drh tags: trunk)
2018-07-06
18:30
Update the syntax diagrams to include the new window function syntax. (check-in: f7a6a2f7c2 user: drh tags: trunk)
2018-06-04
19:41
Add the upsert-clause.gif image. (check-in: 7d927bcea1 user: drh tags: trunk)
2018-04-19
13:28
Preliminary documentation for upsert. (check-in: 74564b6da7 user: drh tags: trunk)
2018-03-23
14:30
Add TRUE and FALSE to the syntax diagrams as new literal values. (check-in: 1d1c0fc6ec user: drh tags: trunk)
2016-09-17
17:53
Update the update-stmt-limited syntax diagram and the text of the UPDATE documentation for the addition of row values. (check-in: ea28d5d596 user: drh tags: trunk)
17:10
Update the syntax diagram for UPDATE to show the ability to use row values. (check-in: 7f09c9eed4 user: drh tags: trunk)
2016-09-14
17:28
Update syntax diagrams for expr and vacuum. (check-in: 3f00f6192a user: drh tags: trunk)
2016-08-30
16:37
Draft chagnes to the VACUUM documentation to describe the ability to VACUUM attached databases. (Leaf check-in: 08b1963db5 user: drh tags: vacuum-enhancement)
2016-07-12
20:54
Updates to reflect changes in 3.14.0. The "expr" syntax diagram is changed to show the ability to put table-valued functions on the RHS of an IN operator. Related text changes. Update the change log. (check-in: 24cd5438cc user: drh tags: trunk)
2015-12-22
16:03
Modify the bubble-diagram generator script to use the TkPath extension. (check-in: 08bf2dfe78 user: chw tags: bubble-generator-tkpath)
2015-09-08
15:16
Update the syntax diagrams for new syntax: (1) table-valued functions (2) column names on CREATE VIEW statements (3) Indexes on expressions (check-in: 866fda3b5a user: drh tags: trunk)
2014-07-24
14:27
Add documentation on the hexadecimal integer notation. (check-in: 4656303de6 user: drh tags: trunk)
2014-02-21
13:21
Update the all-bnf.html file. (check-in: 424fd15707 user: drh tags: trunk)
2014-02-02
22:43
Enhancements to the bubble diagram generator. (Leaf check-in: 4dc85d1094 user: drh tags: bubble-diagrams)
2014-01-30
20:55
Fix an error in the table-or-subquery syntax diagram. (check-in: a467d7a4b8 user: drh tags: trunk)
20:51
Add the "factored-select-stmt" syntax diagram. Improve the way diagrams are hidden and shown. (check-in: fac98d12ae user: drh tags: trunk)
19:39
Make the "select-stmt" syntax diagram a closer fit to reality. (check-in: 0c43e7efb4 user: drh tags: trunk)
17:41
Fix FROM clause in the SELECT syntax diagrams. Also fix typos in the text. (check-in: a115a033da user: drh tags: trunk)
14:11
Add the extended-simple-select-stmt syntax diagram. Update the documentation on SELECT statements to better explain limitations on the use of ORDER BY and LIMIT in compound SELECTs. (check-in: c14dc7c23b user: drh tags: trunk)
2014-01-23
18:37
Refactoring many of the bubble syntax diagrams, especially related to SELECT. Attempting to make the bubble diagrams easier to follow. (check-in: 9aa1b8df9b user: drh tags: trunk)
15:29
Fix a link in the with-clause syntax diagram. (check-in: 3598251c1c user: drh tags: trunk)
15:25
Recursive syntax diagram display. (check-in: 87e7eb3d0d user: drh tags: trunk)