Live data from Hacker News

Show HN: Private, text to entity-relationship diagram tool

databasediagram.com

61–70 of 87 posts

Re: Show HN: Private, text to entity-relationship diagram tool

#61

We've been using https://dbdiagram.io/ , which also has an open-source markup language: https://github.com/holistics/dbml

I like the markup language and the app looks nice but I just can't comfortably dump database schemas into random web apps.

I see the other comment is marked dead now, but seriously why? I'm having a hard time imagining how a schema is viewed as actual intellectual property or a security risk.

Re: Show HN: Private, text to entity-relationship diagram tool

#62
post #51

did you consider letting the input be just sql ddl rather than yet another layer of ddl?

Every database has its own flavor of SQL syntax for DDLs. So, we settled on a minimal common syntax. We will have "import" functionality available soon. You should be able to convert database specific DDLs into diagram language.

Suggest checking out the sqlparse library for a way to do the different flavours without needing to address each case directly: https://github.com/andialbrecht/sqlparse

Re: Show HN: Private, text to entity-relationship diagram tool

#63
post #56

I love that this is trending on HN. LLMs be damned. We still have lots of “simple” problems to be solved, like how to effectively write and share an ERD.

A LLM would probably make this better. Instead of asking the user to learn a DSL why not just translate SQL to whatever structure the render functions uses?

Re: Show HN: Private, text to entity-relationship diagram tool

#65
post #16

Earlier quoted context omitted.

ive been a keeping a list of other diagramming tools too https://github.com/swyxio/spark-joy/blob/master/README.md#di...

Dude you have all the lists.

you wont believe #7!

on a more serious note, everyone should have a little utility belt of lists, hand curated and intimately known. they are an extension of me at this point.

Re: Show HN: Private, text to entity-relationship diagram tool

#66
post #16

Earlier quoted context omitted.

ive been a keeping a list of other diagramming tools too https://github.com/swyxio/spark-joy/blob/master/README.md#di...

would you mind checking https://chatuml.com out to see if it fits your list?

sure! surprised i havent come across jt before. PR welcome

Re: Show HN: Private, text to entity-relationship diagram tool

#67

Created this python script to export mysql to this format. Used chatgpt so expect weird code. it works! but dies a little with many tables :-) code: https://paste.rs/1ZHp7.py3 screenshot: https://i.imgur.com/4D2hEWc.png

Definitely impressive on what you put together in a short time.

Long term, we would want to build robust "Import" wizard for every dbms

Re: Show HN: Private, text to entity-relationship diagram tool

#69
I am using ChatGPT to generate PlantUML Entity Diagrams. I have a separate chat just for this purpose. It can generate the PlantUML and Spring JPA Java code for all my entities. If I need a change , I ask it to update the model and generate updated diagram and code. It also generate Liquibase xml changeset. Moreover, it can also generate my GraphQL schema .. and update it when I change the data model.

This is the friggin' holy grail of all diagramming and modeling tools. And it is available and working now. Everything else is just too primitive !

Re: Show HN: Private, text to entity-relationship diagram tool

#70
post #56

I love that this is trending on HN. LLMs be damned. We still have lots of “simple” problems to be solved, like how to effectively write and share an ERD.

A LLM would probably make this better. Instead of asking the user to learn a DSL why not just translate SQL to whatever structure the render functions uses?

You don’t need an LLM for that. Also, SQL doesn’t capture all the information you might want in an ER diagram.
Post reply on HN