Create ERD diagram for CLDF dataset

[xrotwang]

Download

• https://github.com/xerial/sqlite-jdbc/releases/download/3.39.4.1/sqlite-jdbc-3.39.4.1.jar
• https://github.com/schemaspy/schemaspy/releases/download/v6.1.0/schemaspy-6.1.0.jar

Run

cldf createdb ... db.sqlite
java -jar schemaspy-6.1.0.jar -t sqlite-xerial -db db.sqlite -sso -s public -o tmp -dp drivers/ -cat % -vizjs
mv tmp/diagrams/summary/relationships.real.large.svg out.svg
rm -rf tmp

[SimonGreenhill]

Oh -- this will be super useful.

[xrotwang]

$ cldfbench cldfviz.erd https://zenodo.org/record/7322688 wacl.svg --schemaspy-jar ext/schemaspy.jar --sqlite-jar ext/sqlite.jar --format compact.svg

will create

[fmatter]

This is great, thank you!

[SimonGreenhill]

cool! thanks Robert