3 ms·
Honestly, what I'm looking for is a tool that generates the docs and diagrams for a database from the database schema itself and lays it out cleanly. So far I'v
by ttfkam 3y ago
Honestly, what I'm looking for is a tool that generates the docs and diagrams for a database from the database schema itself and lays it out cleanly. So far I've found tools that will try to generate a diagram naively even if there are a hundred tables, and I've found tools that make you recreate your structure twice: once in DDL and the second time in docs/diagramming.
I want Javadoc with scoped diagrams for relational databases.
- zihotki 3y agoThen you should probably push adoption of markdown for javadoc (1). That and mermaid extension should be a good candidate. Or just use javadoc with an additional md plugin. 1 - https://mail.openjdk.org/pipermail/javadoc-dev/2023-January/005563.html https://mail.openjdk.org/pipermail/javadoc-dev/2023-January/...
- ttfkam 3y agoJavadoc is for Java code. I want something that generates documentation for relational databases, not Java. Hence: Javadoc for relational databases.
- phaza 3y agoMaybe you can use schemaspy? https://schemaspy.org/ https://schemaspy.org/
- ttfkam 3y agoIt's been a while since I looked at SchemaSpy. It has improved a lot since I last looked. Thanks for the recommendation! I wish the layout were a little more polished, but the content/functionality is definitely there.
- breadwinner 3y agoAs long as the relationships are also defined in the DDL, the DDL is the only thing that is needed. You can use an automated diagrammer such as the one in https://visualdb.com/ https://visualdb.com/ It shows tables and relationships graphically, and you can click on a table to see its columns and data types.