Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
182 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:
| |
| 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) | |
| 02:56 | Minor tweaks to the compound-select-stmt diagram. (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) | |
|
2014-01-17
| ||
| 23:50 | Update the syntax bubble diagrams to show that the WITH clause is allowed. (check-in: 3f48c6857f user: drh tags: trunk) | |
|
2013-11-08
| ||
| 20:06 | First attempt at documenting WITHOUT ROWID. (check-in: 3819df0c0d user: drh tags: trunk) | |
|
2013-08-02
| ||
| 18:27 | Enable partial indices. (check-in: f990657458 user: drh tags: trunk) | |
|
2013-08-01
| ||
| 18:23 | Update syntax diagrams (on Mac OS 10.6.8 using Tk 8.5.7) for partial indices. (check-in: 6f7d9ba15e user: drh tags: partial-indices) | |
|
2012-01-28
| ||
| 19:42 | Update the syntax diagram for CREATE VIRTUAL TABLE to show the optional IF NOT EXISTS clause. (check-in: d170aa6e3f user: drh tags: trunk) | |
| 15:23 | Update the INSERT statement syntax diagram to show the support for multiple rows in the VALUES clause of an INSERT. (check-in: 55bd8303d7 user: drh tags: trunk) | |
|
2011-11-11
| ||
| 13:37 | Rerender all bubble-diagram gifs using xvnc on "elly". The choice of X-server makes a huge difference in the final output, unfortunately. (check-in: d8b1c2a562 user: drh tags: trunk) | |
| 13:24 | Update the bubble diagram for select-core so that GROUP BY does not allow ASC or DESC keywords. This brings the documentation into compliance with the implementation. (check-in: 40ef9e8de8 user: drh tags: trunk) | |
|
2011-04-05
| ||
| 14:31 | Updates to the ANALYZE and FTS4 documentation to describe the latest changes. Updates to the changes.html file as we move closer to the 3.7.6 release. Added amalgamation32k to the download.html page. (check-in: 4fb953fec0 user: drh tags: trunk) | |
|
2011-02-04
| ||
| 00:52 | Update the ATTACH documentation to allow an expression as the filename parameter. Core ticket http://www.sqlite.org/src/info/9013e13dba. (check-in: be0c879c12 user: drh tags: trunk) | |
|
2010-10-14
| ||
| 17:27 | Fix the join-op syntax diagram so that it allows LEFT JOIN in addition to LEFT OUTER JOIN. (check-in: 1a0decefd2 user: drh tags: trunk) | |
|
2010-09-30
| ||
| 16:31 | Add missing image: numeric-literal.gif. (check-in: d1c65c4e95 user: drh tags: trunk) | |
| 16:15 | Added a syntax diagram for numeric literals, especially floating point literals. (check-in: 598ff451ef user: drh tags: trunk) | |
|
2010-09-24
| ||
| 19:00 | Update the REINDEX syntax diagram to allow for no arguments. (check-in: f55ccb05aa user: drh tags: trunk) | |
|
2010-09-18
| ||
| 15:03 | Remove the tags from a couple of untestable statements in lang_select.html. (check-in: 0df9f2d381 user: dan tags: trunk) | |
|
2010-09-17
| ||
| 19:52 | Update the syntax diagram GIF files. (check-in: 2adf0c0cca user: drh tags: trunk) | |
| 17:08 | Modify syntax diagrams to show that LIMIT and OFFSET clauses are now expressions, not constant integers. And to make it clear that "OUTER" and "NATURAL OUTER" joins are not supported. (check-in: 5db62da333 user: dan tags: trunk) | |
|
2010-03-25
| ||
| 21:32 | Corrected typo. (check-in: da61246532 user: shaneh tags: trunk) | |
| 21:31 | Updates to text based bubble diagrams to fix minor issues and add linking. (check-in: 56374346ea user: shaneh tags: trunk) | |
| 21:30 | Added psuedo-BNF generator for syntax diagrams. (check-in: 678b7b774c user: shaneh tags: trunk) | |
|
2010-03-24
| ||
| 04:03 | Updates to text bubble generator for Chrome. (check-in: 1477f7f3f4 user: shaneh tags: trunk) | |
| 03:48 | Output of bubble-generator-text.tcl (check-in: cc2f7e8bc8 user: shaneh tags: trunk) | |
| 03:44 | More updates to text bubble-generator. (check-in: 3d6edd87ad user: shaneh tags: trunk) | |
| 03:36 | Minor updates to text based syntax generator to support IE8. Unfortunately, IE8 doesn't support radius styles on tables. (check-in: 4f317a713b user: shaneh tags: trunk) | |
|
2010-03-23
| ||
| 21:39 | Attempt to provide a renderer for the bubble syntax that produces all text output for users not wanting the graphical version. (check-in: b1e7df7e11 user: shaneh tags: trunk) | |
|
2009-10-14
| ||
| 02:43 | Documentation updates prior to the release of version 3.6.19. (check-in: 9598affd43 user: drh tags: trunk) | |
|
2009-09-21
| ||
| 14:26 | Correct the syntax of foreign key constraints. (check-in: 029b30de8c user: drh tags: trunk) | |
|
2009-06-07
| ||
| 00:01 | Add a rough draft of the document describing how to use fossil to maintain a private branch of SQLite. (check-in: ce4ee2b8d3 user: drh tags: trunk) | |
|
2009-05-10
| ||
| 15:57 | Fix a bug in the foreign-key-clause syntax diagram: the ON DELETE clause and its friends are all optional. (check-in: 3562d60bc7 user: drh tags: trunk) | |
|
2009-02-16
| ||
| 16:16 | Additional clarifications to the syntax diagrams. (check-in: 1495fead09 user: drh tags: trunk) | |
|
2009-02-14
| ||
| 19:00 | Tweaks to the syntax diagrams to make them more readable. (check-in: b28d410e7d user: drh tags: trunk) | |
|
2009-02-13
| ||
| 22:41 | Improvements to the join-op syntax diagram. Do not show the RIGHT and FULL outer join options, since SQLite does not do them (yet). (check-in: 122764735d user: drh tags: trunk) | |
| 15:09 | Corrections to the bubble diagram for ANALYZE. (check-in: f12500891b user: drh tags: trunk) | |
|
2009-02-05
| ||
| 02:33 | Enhancements to the SQL language documentation. (check-in: c8dc1e13d7 user: drh tags: trunk) | |
|
2009-01-02
| ||
| 17:36 | Updating documentation for version 3.6.8. (check-in: 0a327982e8 user: drh tags: trunk) | |
|
2008-12-03
| ||
| 14:52 | Change the syntax diagrams to require a GROUP BY prior to a HAVING clause. CVSTrac ticket #3516. (check-in: 77ea14504b user: drh tags: trunk) | |
|
2008-10-29
| ||
| 02:15 | Round the corners on a few items in the syntax diagrams that should be tokens but are shown as non-terminals. (check-in: 4a762d807c user: drh tags: trunk) | |
| 02:09 | In the syntax diagrams, give all tokens rounded corners and all non-terminals square corners. (check-in: 27a206292e user: drh tags: trunk) | |
| 01:31 | Fix problems with the syntax diagrams. Added the new sql-stmt-list syntax diagram. (check-in: 0fa64d8eb0 user: drh tags: trunk) | |
|
2008-10-25
| ||
| 11:54 | Rerender the new create-trigger-stmt bubble diagram on elly. (check-in: d282e1000b user: drh tags: trunk) | |
|
2008-10-21
| ||
| 05:20 | Update 'create trigger' syntax diagram for ticket #3451. (check-in: e07481de97 user: dan tags: trunk) | |
|
2008-10-09
| ||
| 15:47 | Fix the syntax diagram for PRAGMA. Other documentation updates. (check-in: 262c3af24e user: drh tags: trunk) | |
|
2008-10-07
| ||
| 20:01 | Update language documentation to contain information about INDEXED BY and the LIMIT clause on UPDATE and DELETE. Updated information on the SQLITE_MAX_FUNCTION_ARG compile-time option. (check-in: e61538e201 user: drh tags: trunk) | |
|
2008-10-03
| ||
| 02:18 | Updates to the language documentation. Added syntax diagrams for comments and for SQL statements. (check-in: d16fcfeef7 user: drh tags: trunk) | |
| 00:56 | Add the syntaxdiagrams.html page to the documentation. Updates to the language documentation pages to talk about the LIMIT and ORDER BY clauses on DELETE and UPDATE. (check-in: 289df32643 user: drh tags: trunk) | |
|
2008-10-02
| ||
| 18:04 | Replace BNF with bubble diagrams in the language definition pages. Still a lot of text to update. (check-in: c1cdac9b55 user: drh tags: trunk) | |
| 15:45 | Additional refinements to the bubble diagram generator. Initial check-in of the generated GIF file. We puts the GIFs in the respository because they can only be generated on Linux. (check-in: 65f1d8f6e6 user: drh tags: trunk) | |
| 03:02 | Formatting tweaks on the syntax button diagrams. (check-in: 28e884fd46 user: drh tags: trunk) | |
| 00:27 | Add the generator for the "all.html" output file to the bubble syntax diagram generating script. (check-in: efd44c7e72 user: drh tags: trunk) | |
| 00:17 | More work on the bubble diagrams. (check-in: 3310f8689a user: drh tags: trunk) | |
|
2008-10-01
| ||
| 21:28 | Continuing work on the bubble syntax diagram generator. (check-in: 4b56572316 user: drh tags: trunk) | |
| 19:48 | Continuing work on the syntax bubble diagrams. (check-in: f73a84dfb0 user: drh tags: trunk) | |
| 17:25 | Continuing work on the bubble syntax diagrams. (check-in: 2bb38606e0 user: drh tags: trunk) | |
|
2008-09-29
| ||
| 20:57 | Continuing work on the syntax bubble-diagram generator. (check-in: effc38b25c user: drh tags: trunk) | |
| 20:21 | Continuing work on the syntax bubble-diagram generator. (check-in: 461cf70bbf user: drh tags: trunk) | |
| 17:12 | Add a prototype to a syntax bubble diagram generator script. (check-in: 5f5eb0d82d user: drh tags: trunk) | |
|
2007-11-12
| ||
| 15:32 | Complete reorganization of the documentation sources. (check-in: 275febef8f user: drh tags: trunk) | |