Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
1–10 of 13 posts
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#2Neat! Thank you.
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#3Good schema design tools are the missing piece for making PostgreSQL the complete package.
Ideally there'd be an officially supported tool that allowed you to define your relationships at a high level and it would create a well normalised and indexed schema for you automatically.
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#4The diagrams in that way are problematic. When you model them as digraphs and use this layout and order them from too to bottom you get all the tables at the top that represent n:m relationships and at the bottom (at different levels) your main/independent entities.
At least bottom to top would pack the independent ones to the top and those that represent many-to-many relationships at the bottom.
From my work with Oracle Datamodeler know that even at a dozen tables manual layout beats an algorithm any time. And the oracle algithms are more sophisticated/less general than dot.
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#5Good schema design tools are the missing piece for making PostgreSQL the complete package. Ideally there'd be an officially supported tool that allowed you to define your relationships at a high level and it would create a well normalised and indexed schema for you automatically.
There's pgmodeler: https://pgmodeler.io/
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#6The diagrams in that way are problematic. When you model them as digraphs and use this layout and order them from too to bottom you get all the tables at the top that represent n:m relationships and at the bottom (at different levels) your main/independent entities. At least bottom to top would pack the independent ones to the top and those that represent many-to-many relationships at the bottom. From my work with Or…
Anyone know of any tools that let you manually layout the elements in a dotfile such as generated by dbdot or similar tools?
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#7For high-level/quick-and-dirty designing I'm a fan of https://dbdiagram.io/
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#8For high-level/quick-and-dirty designing I'm a fan of https://dbdiagram.io/
That's not high level design though. High level would be (for example) in Barker-notation were you have subclasses and n:m relationships are not represented as their own entities.
Only as a next step you translate that to the actual relations.
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#9The diagrams in that way are problematic. When you model them as digraphs and use this layout and order them from too to bottom you get all the tables at the top that represent n:m relationships and at the bottom (at different levels) your main/independent entities. At least bottom to top would pack the independent ones to the top and those that represent many-to-many relationships at the bottom. From my work with Or…
.. not a giant fan of AI but, this sounds like exactly the sort of thing an AI could be taught to do ..
Re: Show HN: Dbdot – Golang tool to help generate Postgres schema diagrams
#10I have had great success with Schema Spy[0]. It documents your database and includes a schema diagram.