Carlos Aguni

Highly motivated self-taught IT analyst. Always learning and ready to explore new skills. An eternal apprentice.


Dataviz UML Database Schema Study

20 Nov 2022 »

Graphvizforce

https://stevebuik.github.io/GraphVizForce/

erd-viewer

https://github.com/cristiscu/erd-viewer

SQL dataviz

https://github.com/rm-hull/sql_graphviz

Generating an attribute schema diagram from data e.g. with graphviz

https://clojureverse.org/t/generating-an-attribute-schema-diagram-from-data-e-g-with-graphviz/5918

Table Relationship Diagrams with Graphviz

https://spin.atomicobject.com/2017/11/15/table-rel-diagrams-graphviz/

digraph {
    graph [pad="0.5", nodesep="0.5", ranksep="2"];
    node [shape=plain]
    rankdir=LR;


Foo [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Input Foo</i></td></tr>
  <tr><td port="1">one</td></tr>
  <tr><td port="2">two</td></tr>
  <tr><td port="3">three</td></tr>
  <tr><td port="4">four</td></tr>
  <tr><td port="5">five</td></tr>
  <tr><td port="6">six</td></tr>
</table>>];


Bar [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Input Bar</i></td></tr>
  <tr><td port="7">seven</td></tr>
  <tr><td port="8">eight</td></tr>
  <tr><td port="9">nine</td></tr>
  <tr><td port="10">ten</td></tr>
</table>>];


Baz [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Output Baz</i></td></tr>
  <tr><td port="a">alpha</td></tr>
  <tr><td port="b">bravo</td></tr>
  <tr><td port="c">charlie</td></tr>
  <tr><td port="d">delta</td></tr>
  <tr><td port="e">echo</td></tr>
  <tr><td port="f">foxtrot</td></tr>
</table>>];

Foo:2 -> Baz:a;
Foo:3 -> Baz:e;
Foo:6 -> Baz:b;
Bar:7 -> Baz:d;
Bar:9 -> Baz:f;
}

Graphql voyager

https://ivangoncharov.github.io/graphql-voyager/