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

Free SQL→ER diagram tool, runs in the browser, nothing uploaded

sqltoerdiagram.com

Post reply on HN
Print view View original

61–70 of 81 posts

Re: Free SQL→ER diagram tool, runs in the browser, nothing uploaded

#61

Post by systems »

michaelmior wrote: post #30

The tool looks very cool! But IMO you can't get an ER diagram from SQL since entities are fundamentally different from tables. They are certainly very similar, but SQL alone doesn't give you enough information to create an ER diagram. That's not to say that the tool is useless or that diagrams of this sort are unhelpful. I'll admit I'm being pedantic and others will probably disagree.

the use case for sql to er, is to study a database new to you

so the db already exist, but they have no er, and maybe even little docs

so it act more like an exploratory tool, ideally, it should allow you to create views and add notes, so you dont have to look at the full er at once, especially if the number of table is huge, and if many of those tables are missing foreign keys

Re: Free SQL→ER diagram tool, runs in the browser, nothing uploaded

#62

Post by [deleted] »

michaelmior wrote: post #30

The tool looks very cool! But IMO you can't get an ER diagram from SQL since entities are fundamentally different from tables. They are certainly very similar, but SQL alone doesn't give you enough information to create an ER diagram. That's not to say that the tool is useless or that diagrams of this sort are unhelpful. I'll admit I'm being pedantic and others will probably disagree.

[deleted]

Re: Free SQL→ER diagram tool, runs in the browser, nothing uploaded

#63

Post by frollogaston »

ezst wrote: post #32
michaelmior wrote: post #30

The tool looks very cool! But IMO you can't get an ER diagram from SQL since entities are fundamentally different from tables. They are certainly very similar, but SQL alone doesn't give you enough information to create an ER diagram. That's not to say that the tool is useless or that diagrams of this sort are unhelpful. I'll admit I'm being pedantic and others will probably disagree.

> entities are fundamentally different from tables Isn't the fact that they are _mostly_ interchangeable the foundational principle of hundreds of ORMs? Of course the DDL doesn't say much about the entity's lifecycle, but if the bar is set at representing its relationships, fields and cardinality as a graph, it seems sufficient?

ORMs are on a poor foundation. But I don't see the problem with this tool, it's just showing the tables.

Re: Free SQL→ER diagram tool, runs in the browser, nothing uploaded

#64

Post by thunderbong »

michaelmior wrote: post #30

The tool looks very cool! But IMO you can't get an ER diagram from SQL since entities are fundamentally different from tables. They are certainly very similar, but SQL alone doesn't give you enough information to create an ER diagram. That's not to say that the tool is useless or that diagrams of this sort are unhelpful. I'll admit I'm being pedantic and others will probably disagree.

Can you please elaborate? My understanding was that entities always have a 1:1 relationship with tables.

An example would be really helpful.

Re: Free SQL→ER diagram tool, runs in the browser, nothing uploaded

#65

Post by marcosdumay »

manoDev wrote: post #59
michaelmior wrote: post #30

The tool looks very cool! But IMO you can't get an ER diagram from SQL since entities are fundamentally different from tables. They are certainly very similar, but SQL alone doesn't give you enough information to create an ER diagram. That's not to say that the tool is useless or that diagrams of this sort are unhelpful. I'll admit I'm being pedantic and others will probably disagree.

To make parent’s point more exact: from Chen’s definition, these ER diagrams derived from SQL are the “physical” (most low-level) diagrams, you cannot recreate the “logic” or “conceptual” diagrams from it. I guess nowadays few people care about this difference.

Few people ever cared about the difference.

Re: Free SQL→ER diagram tool, runs in the browser, nothing uploaded

#66

Post by vatsachak »

robhati wrote: post #8

It's a small too nothing great I just figured others might find it useful too. I kept finding myself needing to visualize database schemas, but most tools had the same problems: paywalls, mandatory signups, or sending your SQL to someone else's server. No backend, no accounts, no data leaving your machine. A few implementation details that were fun: * Built on instead of DOM/SVG. Tables are rasterized into cached bit…

Beautiful software. Thanks!

Re: Free SQL→ER diagram tool, runs in the browser, nothing uploaded

#67

Post by throwaway7783 »

michaelmior wrote: post #30

The tool looks very cool! But IMO you can't get an ER diagram from SQL since entities are fundamentally different from tables. They are certainly very similar, but SQL alone doesn't give you enough information to create an ER diagram. That's not to say that the tool is useless or that diagrams of this sort are unhelpful. I'll admit I'm being pedantic and others will probably disagree.

Can you please elaborate on the differences? They are practically interchangeable, but conceptually there might be another layer on top of entities and relationships for somewhat richer semantics (like describing a relation, or additional annotations on the entity)

Re: Free SQL→ER diagram tool, runs in the browser, nothing uploaded

#68

Post by Footprint0521 »

At some point I should post it, I got deepseek to fully reverse engineer the d2 tala engine binary (the sota for diagrams to code with ER ones), and I’m pretty close to an open source looking Go build with 1:1 parity

Once that’s done I guess I can just clean room design it to wasm and post it on npm lol

Goals for someday

Post reply on HN