Documentation Source Text

Timeline
Login

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

200 most recent check-ins using file pages/privatebranch.in version 57c44d97aa

2021-04-05
22:58
Insert a rebuttal of the grossly exaggerated impact of CVE 2021-20227. check-in: db3d49b2a7 user: drh tags: branch-3.35
2021-04-02
16:19
Mention piped source option for .import command. check-in: 3a66d34730 user: larrybr tags: branch-3.35
15:31
Enhancement to the RETURNING documentation. check-in: 9f935a41c1 user: drh tags: branch-3.35
15:30
Version 3.35.4 check-in: 6f6f2ff5ee user: drh tags: branch-3.35
2021-04-01
18:24
Mention piped source option for .import command. check-in: 7652db76ff user: larrybr 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-26
18:29
Merge the documentation updates on the 3.35 branch into trunk. check-in: da382790f1 user: drh tags: trunk
18:25
Clarification of the harm statement of CVE-2021-20227. check-in: 178512ed42 user: drh tags: branch-3.35
12:19
Version 3.35.3 check-in: 62dcfe1803 user: drh tags: release, branch-3.35, version-3.35.3
2021-03-23
20:19
Revise the EXPLAIN QUERY PLAN documentation to conform to the new output format. check-in: e2da609e66 user: drh tags: trunk
20:08
Add an entry for CVE 2021-20227 to the vulnerabilities page. check-in: 2706ba81b8 user: drh tags: branch-3.35
20:02
Begin recording changes for the 3.36 development cycle. check-in: 39e6c41006 user: drh tags: trunk
19:57
Changes associated with 3.35 patches. check-in: 0e56b31f8c user: drh tags: branch-3.35
2021-03-22
14:12
Proposed changes for the 3.35.3 patch release. check-in: a1325c8133 user: drh tags: trunk
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-03-17
21:11
Discussion of the bug fix to non-deterministic date/time functions. check-in: e315d802ed user: drh tags: trunk
20:00
Record the check-in and date for 3.35.2 in chronology.in. check-in: d8f7573d12 user: drh tags: trunk
19:08
Version 3.35.2 check-in: d935787014 user: drh tags: trunk, release, version-3.35.2
2021-03-15
17:13
Update the SQLITE_SOURCE_ID value in the changelog for version 3.35.1. check-in: f030340c31 user: dan tags: trunk, release, version-3.35.1
17:04
Version 3.35.1 check-in: ce12450bbd user: drh tags: trunk
12:20
Fix the keyword list to include MATERIALIZED and RETURNING. check-in: 83dcb37d7f user: drh tags: trunk
2021-03-12
23:40
Adjust the omitted.html page to indicate that DROP COLUMN is now supported. check-in: 6400fd54e4 user: drh tags: trunk
15:17
Version 3.35.0. check-in: 8cce67de75 user: drh tags: trunk, release, version-3.35.0
2021-03-11
21:42
Update the speed-size spreadsheet. check-in: bcb11bed7e user: drh tags: trunk
2021-03-09
22:03
Clarify the operation of the trunc() function. check-in: fc350731cd user: drh tags: trunk
2021-03-05
18:34
Update the change log to mention that SQLITE_DBCONFIG_ENABLE_VIEW now allows TEMP views, by analogy to the SQLITE_DBCONFIG_ENABLE_TRIGGER change. check-in: de7d1ae0cd user: drh tags: trunk
14:54
Minor documentation updates. check-in: 32a238d5ca user: drh tags: trunk
2021-03-04
18:48
Fixes to docapp. Improvements to the makefile. check-in: 07cd8ab1c0 user: drh tags: trunk
18:43
Minor comment fix in testing.in. check-in: d74da90907 user: drh tags: trunk
18:38
Temporary work-around for sqlite3 shell bug. (.ar -c with sqlite3 -append fails.) Closed-Leaf check-in: 9fb7386101 user: larrybr tags: build_de-nit
00:53
For pragma encoding doc, indicate how the default encoding is determined. check-in: ee3112fbee user: larrybr tags: trunk
2021-03-03
14:21
Cure contradiction regarding table content alteration. check-in: e59b0c2241 user: larrybr tags: trunk
13:53
Clarify check constraint interaction with column drop. check-in: 61dec51655 user: larrybr tags: trunk
2021-03-02
16:57
Mention atanh(), too. check-in: a7b0387a7d user: larrybr tags: trunk
16:27
Fix some grammar, improve clarity, correct mathematical nits. check-in: 4ee13c6f67 user: larrybr tags: trunk
01:56
Get docsapp to work (again), faster, with some --help output. More cleanup degrees. check-in: 9b916b865b user: larrybr tags: build_de-nit
2021-03-01
18:08
In how-to-compile, add -lm to gcc builds (because math functions are in by default.) check-in: a70b2f3fc2 user: larrybr tags: trunk
16:42
Formatting detail on the change log. check-in: bb8f139f8e user: drh tags: trunk
15:44
Improvements to the change log. check-in: a587c167b5 user: drh tags: trunk
14:24
Enhancements to the testing.html document. check-in: c39ee51720 user: drh tags: trunk
12:57
Merge AS MATERIALIZED documentation enhancements. check-in: 87a0f4972f user: drh tags: trunk
12:55
Fix broken link to the mailing list. Replace it with a link to the forum. check-in: 2974911cfa user: drh tags: trunk
12:52
Clear up docapp dir/app collision, speed caret removal and make it portable. check-in: 64789d0218 user: larrybr tags: build_de-nit
12:43
Create new branch named "build_de-nit" check-in: 43b2a0c1fc user: larrybr tags: build_de-nit
2021-02-28
18:41
Typo fix, plural to possessive. check-in: d9df475a24 user: larrybr tags: trunk
2021-02-26
21:00
Provide a "Search" feature on the "docs.html" page. This is the same as the search feature from the Search menu item, but is in the user's face rather than requiring the user to find the "Search" button. check-in: 7f769c42ba user: drh tags: trunk
2021-02-25
14:48
Clarify: [NOT] MATERIALIZE is a hint, not a dictate. Closed-Leaf check-in: a0fb8ec14b user: larrybr tags: as-materialized-redux
05:41
Fixed min/max scalar/aggregate confusion reported at https://sqlite.org/forum/forumpost/7b60ca0b85 . This was an obvious error with knarly causation and a somewhat less knarly solution. check-in: dd7fe37832 user: larrybr tags: trunk
2021-02-24
12:48
Update obsolete hash type for sqlite_source_id() function. (Flagged by Mr. Beal.) check-in: 94c9aa9fe9 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-21
12:53
Fix typos and missing items in the change log for 3.35.0 check-in: e029a818bd user: drh tags: trunk
2021-02-19
14:47
Merge typo fixes from the 3.34 branch. check-in: 23825af9b8 user: drh tags: trunk
14:28
Clarification of the DROP COLUMN restrictions. check-in: e79dca4a51 user: drh tags: trunk
14:17
Add documentation for ALTER TABLE DROP COLUMN. check-in: 9682d5370f user: drh tags: trunk
2021-02-17
13:13
Typo fix and clarification on the description of the ".width" argument in the CLI. Leaf check-in: fdb416d609 user: drh tags: branch-3.34
2021-02-12
20:43
Merge updates to "SQLite Over a Network" doc and related tweaks. check-in: e721bf01af user: larrybr tags: trunk
19:05
Mention NFS fsync() issues in How To Corrupt ... section. Closed-Leaf check-in: 518e2ac357 user: larrybr tags: use_over_network
02:17
Spell checker should have been run. 3 mispellings fixed. check-in: 17cdffda9b user: larrybr tags: use_over_network
00:39
Prolixity reduction, 10.0% by word count. "ACID" is now in indices. check-in: 7b6ddd6c57 user: larrybr tags: use_over_network
2021-02-11
18:21
New target, doc/<whatever>.html , for speedy, single docpage development. (Leaves red links now.) Leaf check-in: 45149b39ce user: larrybr tags: faster_make
18:12
Create new branch named "build_streamline" Leaf check-in: 8438309f9a user: larrybr tags: build_streamline
2021-02-10
11:43
Create new branch named "faster_make" check-in: aa700e13d1 user: larrybr tags: faster_make
11:24
Merge typo fix from the 3.34 branch. check-in: a85f388e6c user: drh tags: trunk
11:12
Merge the new "useovernet.in" document and enhancements to "sqldiff" documentation. check-in: 8cc6798f37 user: drh tags: trunk
04:38
Add a page on issues associated with DB access over a network filesystem. check-in: c9703f6dd4 user: larrybr tags: use_over_network
2021-02-09
15:31
Create new branch named "use_over_network" check-in: fc8de90ffc user: larrybr tags: use_over_network
00:10
Modify sqldiff docs to mention empty --changeset output for certain rowid-hidden and PK-less tables. Closed-Leaf check-in: 1b2ddbe529 user: larrybr tags: sqldiff_changeset
2021-02-08
23:37
Create new branch named "sqldiff_changeset" check-in: 25a3db0d3c user: larrybr tags: sqldiff_changeset
13:46
Relax the subquery naming restriction on RETURNING clauses, due to enhancements added to the core code. check-in: 9b1da78091 user: drh tags: trunk
2021-02-06
15:33
Fix typo: "INDEX BY" should be "INDEXED BY" check-in: 2aa06b0fc1 user: drh tags: branch-3.34
2021-02-05
18:06
Update the RETURNING documentation to define the processing order. check-in: 1d12f68d85 user: drh tags: trunk
2021-02-04
23:29
Update the Forwards Compatability warning on RETURNING to reflect the change of implementation. check-in: dab7baa72a user: drh tags: trunk
2021-02-03
16:09
Merge fixes from the 3.34 branch. check-in: 0bb116294e user: drh tags: trunk
16:07
Merge the RETURNING changes. check-in: bcc98c0be1 user: drh tags: trunk
01:12
Add the SQLITE_DBCONFIG_ENABLE_TRIGGER change to the change log. Updates to the RETURNING documentation. Closed-Leaf check-in: e95fde2606 user: drh tags: returning
2021-02-02
21:04
Update docs to indicate that SQLite does detect and error-out of aggregates in a RETURNING clause. Also fix a typo. check-in: 939b7340fb user: drh tags: returning
18:33
Forwards compatibility statement on RETURNING. check-in: 6b4d4d38c1 user: drh tags: returning
15:06
More refinement of RETURNING documentation. Trying to make it more precise and cover all possible angles. check-in: a77c85bf1c user: drh tags: returning
14:20
More detail in the RETURNING documentation. check-in: da6e56a86c user: drh tags: returning
12:11
Preliminary documentation for RETURNING. check-in: faa8501a4a user: drh tags: returning
2021-02-01
21:53
Add the RETURNING clause to the UPDATE/DELETE statements with LIMIT. check-in: d3182cdbb6 user: drh tags: returning
19:25
Typo fix and clarification to PRAGMA analysis_limit. check-in: f8e651e0eb user: drh tags: branch-3.34
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
13:25
Merge changes from the 3.34 branch. check-in: 4b3068b294 user: drh tags: trunk
2021-01-28
19:22
Fix typo in the CREATE TABLE documentation. check-in: 193ce12863 user: drh tags: branch-3.34
14:42
Update links to show all changes since the last *major* release. check-in: e17f14a170 user: drh tags: branch-3.34
14:38
Tighten up the language and simplify the why-not-git document. check-in: cc3966e34b user: drh tags: branch-3.34
2021-01-27
19:46
Merge changes from the 3.34 branch. Add mentions to two significant bug fixes in the change log. check-in: d0fe9d2144 user: drh tags: trunk
19:36
Rig the description of the "Prerelease Snapshot" to show a timeline back to the last release that ends with ".0". check-in: dcfd7f1ba5 user: drh tags: branch-3.34
2021-01-20
14:14
Version 3.34.1 check-in: 792e30d4b7 user: drh tags: branch-3.34
2021-01-18
13:20
Update the change log to show the latest enhancements. check-in: e242010054 user: drh tags: trunk
2021-01-16
12:18
The links to the forum on the support page changed to go directly to the list of recent threads. check-in: fffcdce8f1 user: drh tags: branch-3.34
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-31
18:16
Better hyperlink on whynotgit.html - makes use of the new df= query parameter on the Fossil /timeline. check-in: a300cc936e user: drh tags: branch-3.34
2020-12-30
14:24
Merge 3.34 documentation improvements to trunk. check-in: db10f6fcd3 user: drh tags: trunk
14:10
Minor improvements to the why-not-git page. check-in: dfa59a0c91 user: drh tags: branch-3.34
2020-12-24
12:30
Update the upper size limit of an SQLite database in the When To Use document. check-in: c19bcbed55 user: drh tags: branch-3.34
2020-12-21
13:18
Clarification of the conflict resolution on a DO UPDATE clause. check-in: 3f5013ed32 user: drh tags: branch-3.34
2020-12-18
13:14
Fix typo in optoverview.html check-in: a10f56ec91 user: drh tags: branch-3.34
2020-12-17
23:48
Fix typos in SQL in the optoverview.html. check-in: daa9d19197 user: drh tags: branch-3.34
2020-12-16
23:14
Merge 3.34 enhancements into trunk. check-in: 49bd6aaecf user: drh tags: trunk
23:13
Editorial changes to the optoverview.html document. check-in: 0b0f215c92 user: drh tags: branch-3.34
2020-12-14
15:44
Merge date/time function clarifications from branch-3.34. check-in: f80d76cbb1 user: drh tags: trunk
15:02
Merge the UPSERT enhancements. Update the change log. check-in: 9d0d26d35f user: drh tags: trunk
2020-12-13
19:57
Update the date/time function documentation to avoid the use of the term "time string", which is confusing to some readers. check-in: 733790e205 user: drh tags: branch-3.34
2020-12-10
10:53
Fix a typo in cksumvfs documentation. check-in: 25de4c7f3d user: dan 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-12-07
23:55
Start the change log for the next release. Add documentation for the math functions. check-in: 6654cf2187 user: drh tags: trunk
21:29
Create new branch named "branch-3.34" check-in: c3fb1b50b1 user: drh tags: branch-3.34
14:28
Two years post-controvery, the code of conduct and code of ethics documents are updated to provide a more accurate history of the provenance. check-in: 59de622500 user: drh tags: trunk
2020-12-03
15:34
Add text to clarify the behavior of hex() when given a numeric argument. check-in: 2fe27dbb3a user: drh tags: trunk
2020-12-02
18:42
Fix typos in the sqlar.html document. check-in: ed88ac665a user: drh tags: trunk
17:35
Fix typo in the 3.34.0 change log. check-in: dec6418c71 user: drh tags: trunk
2020-12-01
19:58
Added emphasis on the fact that SQLite database files are stable across platforms, architectures, and SQLite releases. check-in: 6f789b6989 user: drh tags: trunk
16:18
Version 3.34.0 check-in: 7543902bc1 user: drh tags: trunk, release, version-3.34.0
14:20
Move the althttpd webserver source code into its own source repository. check-in: 3f4ac9a6bf user: drh tags: trunk
2020-11-30
18:55
Initial News post for version 3.34.0 check-in: db957ad9f6 user: drh tags: trunk
18:21
Update the speed-and-size spreadsheet. check-in: 80c49a4955 user: drh tags: trunk
2020-11-26
21:15
Fix a typo in the cli.html document. check-in: 40ae2b975d user: drh tags: trunk
2020-11-25
18:23
Remove obsolete GIF syntax diagram processing logic 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
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