SQLite Query Language: upsert

Re:SQLite Query Language: upsert by Normal_gaussian on Thursday May 10, 2018 @04:16PM (#17042568)

The diagram used on this page [0], and the ones on the JSON site [1] are pretty awesome diagrams. What are they called? Is there a good programmatic tool to generate them?

[0] - https://www.sqlite.org/draft/images/syntax/upsert-clause.gif

[1] - https://www.json.org/

[ Parent | on HN ]

Re:SQLite Query Language: upsert by cpburns2009 on Thursday May 10, 2018 @04:18PM (#17042578)

From the FAQ [1],

> (25) How are the syntax diagrams (a.k.a. "railroad" diagrams) for SQLite generated?

> The process is explained at http://wiki.tcl-lang.org/21708.

I looks like a TCL script is used [2].

[1]: https://www.sqlite.org/faq.html#q25

[2]: https://www.sqlite.org/docsrc/doc/tip/art/syntax/bubble-gene...

[ Parent | on HN ]

Re:SQLite Query Language: upsert by wyldfire on Thursday May 10, 2018 @04:18PM (#17042577)

Often called "railroad diagram" [1] [2]

[1] https://en.wikipedia.org/wiki/Syntax_diagram

[2] https://stackoverflow.com/a/7143467/489590

[ Parent | on HN ]

Re:SQLite Query Language: upsert by easytiger on Thursday May 10, 2018 @05:26PM (#17043106)

I thought these are simple EBNF diagrams. As taught in British schools to 16 year olds

[ Parent | on HN ]

Re:SQLite Query Language: upsert by politips on Thursday May 10, 2018 @04:22PM (#17042619)

I don't know if they used it but mermaid is pretty great:

https://mermaidjs.github.io/

[ Parent | on HN ]