3 ms·

I like the SQLite railroad diagrams. They are generated with pikchr[1], "a PIC-like markup language for diagrams in technical documentation". See the syntax dia

I like the SQLite railroad diagrams. They are generated with pikchr[1], "a PIC-like markup language for diagrams in technical documentation". See the syntax diagram under examples. Like many accompanying tools, pikchr comes from the hand of SQLite creater Dr. Richard Hipp (and anyone can guess what that means for the quality of the program). Now pikchr has become my "goto" tool for professional looking diagrams and sketches of all kinds. With its intuitive syntax grammar it is quick to learn - you should give it a try if not yet done! [1] https://pikchr.org/home/doc/trunk/homepage.md https://pikchr.org/home/doc/trunk/homepage.md

toppy 3y ago
SQLite diagrams: https://www.sqlite.org/syntaxdiagrams.html https://www.sqlite.org/syntaxdiagrams.html
- thomasmg 3y ago
  The RR diagrams are images, while the SQLite diagrams are SVG. In my view, SVG is better: it allows copy & paste. SVG would also allow adding links directly in the diagrams, but SQLite doesn't have that (so far). The diagrams for the H2 database [1], and Apache Jackrabbit Oak [2], do have links. (I wrote the generator for those.) [1] https://h2database.com/html/grammar.html https://h2database.com/html/grammar.html [2] https://jackrabbit.apache.org/oak/docs/query/grammar-sql2.html https://jackrabbit.apache.org/oak/docs/query/grammar-sql2.ht...
  - School-Cotton 3y ago
    Not true. RR produces SVGs.
- o11c 3y ago
  One major caveat for the SQLite diagrams in particular - they are written by hand, not from the computer-readable parser description. This means that there are sometimes blatant bugs and ambiguities. Test your AST assumptions against a real SQLite!
deleted 3y ago
[deleted]
alberth 3y ago
Dr. Hipp creates so much great software, and only SQLite gets talked about (Fossil, PtTCL, Lemon are some notable others). Full exhaustive list is below (though it's missing Fossil): https://www.hwaci.com/sw/index.html https://www.hwaci.com/sw/index.html

toppy 3y ago

SQLite diagrams: https://www.sqlite.org/syntaxdiagrams.html https://www.sqlite.org/syntaxdiagrams.html

thomasmg 3y ago
The RR diagrams are images, while the SQLite diagrams are SVG. In my view, SVG is better: it allows copy & paste. SVG would also allow adding links directly in the diagrams, but SQLite doesn't have that (so far). The diagrams for the H2 database [1], and Apache Jackrabbit Oak [2], do have links. (I wrote the generator for those.) [1] https://h2database.com/html/grammar.html https://h2database.com/html/grammar.html [2] https://jackrabbit.apache.org/oak/docs/query/grammar-sql2.html https://jackrabbit.apache.org/oak/docs/query/grammar-sql2.ht...
- School-Cotton 3y ago
  Not true. RR produces SVGs.
o11c 3y ago
One major caveat for the SQLite diagrams in particular - they are written by hand, not from the computer-readable parser description. This means that there are sometimes blatant bugs and ambiguities. Test your AST assumptions against a real SQLite!

deleted 3y ago

[deleted]

alberth 3y ago

Dr. Hipp creates so much great software, and only SQLite gets talked about (Fossil, PtTCL, Lemon are some notable others). Full exhaustive list is below (though it's missing Fossil): https://www.hwaci.com/sw/index.html https://www.hwaci.com/sw/index.html