[HN Gopher] Planter: Auto-generate Plant UML diagrams from Postg...
       ___________________________________________________________________
        
       Planter: Auto-generate Plant UML diagrams from Postgres tables
        
       Author : from_endor
       Score  : 38 points
       Date   : 2021-04-29 11:41 UTC (11 hours ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | mulmen wrote:
       | Is there some tool to go the other way? I actually design my
       | schemas before creating them. It would be nice to start with a
       | high level ERD in PlantUML, add it to a larger design doc, review
       | with the team and refine and then push a button to get my DDL.
        
       | sbuttgereit wrote:
       | If I'm just doing DB schema documentation, and I don't need to
       | integrate that documentation into broader technical
       | documentation, schemaspy is the tool I reach for.
       | 
       | http://schemaspy.org/
       | 
       | My impression is that the maintainers are Oracle-centric (I don't
       | interact with the project with any regularity, so this could be
       | mistaken), but I use this with PostgreSQL and have been quite
       | pleased.
        
       | keeganj wrote:
       | Will give this a try! With all the UML discussions lately it's
       | made me nostalgic for having an ER diagram of my schema. This
       | even looks simple / dependency free enough to run in a CI tool to
       | keep such a diagram up to date with the codebase.
        
         | from_endor wrote:
         | We use planter in our build process to maintain an up-to-date
         | visualization of the schema. Given that foreign key references
         | are maintained in the schema (using REFERENCES), planter draws
         | all relationships properly.
         | 
         | The Plant UML CLI itself has some limitations if the ER diagram
         | is really large.
        
       | thenaturalist wrote:
       | Similar tool with awesome interface & bridges would be
       | dbdiagram.io [0]. Not affiliated, just a happy user.
       | 
       | Imports from MySQL, PostgreSQL, SQL Server, works with Rails,
       | Django etc.
       | 
       | [0]:https://dbdiagram.io/
        
       ___________________________________________________________________
       (page generated 2021-04-29 23:02 UTC)