News for hackers. Stuff that matters.
Re:ChartDB – Free and open source, database design editor by mvdwoord on Wednesday August 28, 2024 @08:58AM (#41378964)
many such offerings around, it seems. What I am looking for however, is a tool which I can use / script against. My use case is to produce (relatively straightforward) db diagrams from some model descriptions I have (part of another process). I have table names, column names, and relationships in a memory structure, and want to draw an ER like diagram. Currently looking at producing this wit plantuml, generating the puml file form my data, then running plantuml to generate the png / svg.

Looking around i find most tools in this corner are either full fledged DB design tools with their own editor, but no API. The others like this and things like dbdiagram.io usually are focused online only, which is not an option for me.

Any suggestions greatly appreciated...

Re:ChartDB – Free and open source, database design editor by 4ndrewl on Wednesday August 28, 2024 @09:33AM (#41379335)
Have you tried schemaspy?
Re:ChartDB – Free and open source, database design editor by mvdwoord on Wednesday August 28, 2024 @11:04AM (#41380336)
looking at it, it seems to be geared towards connecting to a database. My needs are to generate a DB like schema image from a custom in memory represntation of tables, columns and relations. Thanks for the tip though, it does seem like a useful tool, akin to plantuml in that it functions somewhat as a graphviz preprocessor iiuc.