Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

databasediagram.com

Post reply on HN
Print view View original

71–80 of 87 posts

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

#71

Post by ElFitz »

Oh! I thought this was something about describing a data model in plain text and having an LLM generate the entity-relationship diagram tool.

I’ve done this with GPT4, asking it to output Mermaid relationship diagrams. And it’s usually impressively good (never went beyond ~10 entities). I also had it update and fix the result using natural language feedback.

I sometimes had to touch up a few things "by hand", but I really wouldn’t bother doing it from scratch myself anymore.

Even the failures are interesting, as they often result from an unclear description, or issues in my own understanding of the domain or model.

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

#72

Post by jcoder »

grouseway wrote: post #61
tempest_ wrote: post #53

Earlier quoted context omitted.

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.

Intellectual property: it represents what kinds of data you maintain, their naming, and their relation. That’s valuable on its own and also points to what your software does.

Security: well, see above—knowing what data is stored determines your value as a target.

Now is it the _best_ way to target an adversary? Probably not.

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

#73

Post by sunsetMurk »

ElFitz wrote: post #71

Oh! I thought this was something about describing a data model in plain text and having an LLM generate the entity-relationship diagram tool. I’ve done this with GPT4, asking it to output Mermaid relationship diagrams. And it’s usually impressively good (never went beyond ~10 entities). I also had it update and fix the result using natural language feedback. I sometimes had to touch up a few things "by hand", but I r…

ditto, GPT-4 is very impressive with all types of mermaid [0] diagrams! even helps w/ styling and formatting tweaks. It's helped me so much with better coverage and maintainability on diagrams for software & systems projects.

0. https://mermaid.live/

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

#75

Post by [deleted] »

grouseway wrote: post #61
tempest_ wrote: post #53

Earlier quoted context omitted.

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.

[deleted]

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

#76

Post by breadwinner »

swyx wrote: post #16
shizcakes wrote: post #4

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

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

Add Airforms since it has an automatic database diagram display: https://airforms.com

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

#78

Post by tabulatouch »

flarg wrote: post #48
thom wrote: post #44

Earlier quoted context omitted.

I've used Mermaid, partly because it integrates well in both GitHub and Notion. It's fine, quite featureful really, but the lack of any ability to control layout properly makes complex schemas quite a mess when rendered. Not sure how others of these declarative, text-based engines deal with that.

Use Mermaid in draw.io. It renders Mermaid into native draw.io shapes that you can rearrange.

I've been looking for such a solution but for class diagrams. Auto generating from code and edit them in draw.io. Do you have any suggestion?

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

#80

Post by davgoldin »

text2db wrote: post #79

Something similar made by me (text2db) long time ago, cannot maintained it, but if someone wants to continue, code is available on github https://stackblitz.com/edit/web-platform-hxc9oz?file=index.h... https://www.youtube.com/watch?v=8hYtZ38wuz4

NSFW! Don't open the (expired?) domain.
Post reply on HN