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

Found a simple tool for database modeling: dbdiagram.io

dbdiagram.io

Post reply on HN
Print view View original

61–70 of 76 posts

Re: Found a simple tool for database modeling: dbdiagram.io

#61

Post by breadwinner »

darth_avocado wrote: post #55
smusamashah wrote: post #22

I maintain an almost exhaustive list of text to diagram tools [1]. dbdiagram.io requires login to export. Other dedicated text to database diagram tools are 1. Database Diagram Tool https://databasediagram.com/app 2. QuickDBD https://app.quickdatabasediagrams.com/#/ 3. ERD Lab https://app.erdlab.io/designer/guest (Requires Login to Export) [1]: https://xosh.org/text-to-diagram/

Is there a tool that can connect to a db and generate its own diagram?

Visual DB can do that: https://visualdb.com/

Re: Found a simple tool for database modeling: dbdiagram.io

#62

Post by ssfak »

darth_avocado wrote: post #55
smusamashah wrote: post #22

I maintain an almost exhaustive list of text to diagram tools [1]. dbdiagram.io requires login to export. Other dedicated text to database diagram tools are 1. Database Diagram Tool https://databasediagram.com/app 2. QuickDBD https://app.quickdatabasediagrams.com/#/ 3. ERD Lab https://app.erdlab.io/designer/guest (Requires Login to Export) [1]: https://xosh.org/text-to-diagram/

Is there a tool that can connect to a db and generate its own diagram?

chartsdb[1][2] can be installed locally (or run through Docker) and import your database schema

[1]: https://chartdb.io/ [2]: https://github.com/chartdb/chartdb

Re: Found a simple tool for database modeling: dbdiagram.io

#64

Post by aslakhellesoy »

I’ve been using Mermerd [1] for years and never looked back. Simple, does one thing well.

It gets even better with elk layout - just prepend this frontmatter snippet to mermerd’s output:

    ---
    config:
      layout: elk
    ---
[1]: https://github.com/KarnerTh/mermerd

Re: Found a simple tool for database modeling: dbdiagram.io

#65

Post by speakspokespok »

darth_avocado wrote: post #55
smusamashah wrote: post #22

I maintain an almost exhaustive list of text to diagram tools [1]. dbdiagram.io requires login to export. Other dedicated text to database diagram tools are 1. Database Diagram Tool https://databasediagram.com/app 2. QuickDBD https://app.quickdatabasediagrams.com/#/ 3. ERD Lab https://app.erdlab.io/designer/guest (Requires Login to Export) [1]: https://xosh.org/text-to-diagram/

Is there a tool that can connect to a db and generate its own diagram?

Your question doesn't include the size or complexity of the database you're trying to visualize. With that preface said, schemaspy has been around for years and years and I've seen it at every tech company I've ever worked at for visualizing their production databases. I think it's free?

https://schemaspy.org/samples/chinook/relationships.html

Re: Found a simple tool for database modeling: dbdiagram.io

#66

Post by dangardan »

hobs wrote: post #32
dangardan wrote: post #6

Earlier quoted context omitted.

I had the opposite problem, was given SQL ddl with near 1000 tables and hundreds of constraints, and had to produce the schema map. Ran the ddl and connected it to yEd, and hey presto, schema map!

The truth is that if you are modeling a relationship set of 1000 tables you probably cant usefully show that to someone - you can produce an image but nobody can likely use it. Instead, consider breaking things down to functional areas and then modeling those - just like how most city thinking is "well get on this main road and then this secondary road will get me to XYZ"

That's a good point, but to extend my situation, it's a client database I've been asked to transform. The map is indeed difficult to grok all in one, but using different views that come out of the box in yEd, along with some basic rules such as "make all nodes with the word 'cust' yellow", it's been surprisingly effective at exploring the schema.

Re: Found a simple tool for database modeling: dbdiagram.io

#68

Post by praetis »

That is a very nice tool! I might use it.

In case it's useful to anyone in here, I wrote a little app at erdraw.com which is specifically designed to be a way to draw a data model in the notation of "Mastering Data Modeling" by Professor John Carlis. It serves somewhat different goals than these other tools. It prioritizes user understandability to be useful in conversations non-engineers. So it excludes technical details like data types and SQL.

https://erdraw.com

Re: Found a simple tool for database modeling: dbdiagram.io

#69

Post by ChromaticPanic »

darth_avocado wrote: post #55
smusamashah wrote: post #22

I maintain an almost exhaustive list of text to diagram tools [1]. dbdiagram.io requires login to export. Other dedicated text to database diagram tools are 1. Database Diagram Tool https://databasediagram.com/app 2. QuickDBD https://app.quickdatabasediagrams.com/#/ 3. ERD Lab https://app.erdlab.io/designer/guest (Requires Login to Export) [1]: https://xosh.org/text-to-diagram/

Is there a tool that can connect to a db and generate its own diagram?

Jet brains DataGrip is great for this. Compared to pgadmin an dbeaver. The DataGrip visualization options are so good that I grabbed a subscription.

Re: Found a simple tool for database modeling: dbdiagram.io

#70

Post by bdangubic »

ChromaticPanic wrote: post #69
darth_avocado wrote: post #55

Earlier quoted context omitted.

Is there a tool that can connect to a db and generate its own diagram?

Jet brains DataGrip is great for this. Compared to pgadmin an dbeaver. The DataGrip visualization options are so good that I grabbed a subscription.

100%… any new project I get involved I use DataGrip to build visualization to quickly get across the data model
Post reply on HN