News for hackers. Stuff that matters.

A comment on Show HN: Online database diagram editor.

Re:Show HN: Online database diagram editor by ttfkam on Saturday April 06, 2024 @06:42PM (#39956329)
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.

[ Parent | on HN ]
Re:Show HN: Online database diagram editor by phaza on Saturday April 06, 2024 @07:30PM (#39956654)
Maybe you can use schemaspy? https://schemaspy.org/
[ Parent | on HN ]
Re:Show HN: Online database diagram editor by ttfkam on Saturday April 06, 2024 @08:02PM (#39956846)
It'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.
[ Parent | on HN ]
Re:Show HN: Online database diagram editor by zihotki on Saturday April 06, 2024 @07:23PM (#39956603)
Then 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/...

[ Parent | on HN ]
Re:Show HN: Online database diagram editor by ttfkam on Saturday April 06, 2024 @08:00PM (#39956832)
Javadoc is for Java code. I want something that generates documentation for relational databases, not Java. Hence: Javadoc for relational databases.
[ Parent | on HN ]
Re:Show HN: Online database diagram editor by breadwinner on Saturday April 06, 2024 @09:11PM (#39957247)
As 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/ It shows tables and relationships graphically, and you can click on a table to see its columns and data types.
[ Parent | on HN ]