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

21–30 of 76 posts

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

#22

Post by smusamashah »

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/

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

#26

Post by bob1029 »

Tooling is a big reason I would reach for SQL Server over alternatives in many scenarios. Combining SSMS with 1-2 RedGate utilities and an Excel license is essentially the one ring of database management.

When you have a complex data model and need to constantly engage the business regarding it, having an easy way to transform, compare and visualize representations of the schema can mean the difference between ~3 clicks and a multi-day journey into the rabbit hole of shiny technology.

I would still reach for SQLite in any scenario where I am embedding the DB in software that I am distributing. But, if I need to stand up a database that multiple systems and users are all going to talk to, I am always going to advocate for spending a little bit of money.

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

#27

Post by PhilippGille »

blitztime wrote: post #17
solids wrote: post #15

Mermaid is also great https://docs.mermaidchart.com/blog/posts/7-er-diagram-exampl...

I found out about mermaid recently and have been using it to make diagrams. How do you use it for data modeling though?

Did you follow the link that the parent poster posted? It's exactly about how to do data modeling with Mermaid.

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

#28

Post by Ygg2 »

blitztime wrote: post #17
solids wrote: post #15

Mermaid is also great https://docs.mermaidchart.com/blog/posts/7-er-diagram-exampl...

I found out about mermaid recently and have been using it to make diagrams. How do you use it for data modeling though?

What do you mean by data modelling? Which UML part? You start the diagram with a `erDiagram`

    ---
    title: Order example
    ---
    erDiagram
        CUSTOMER ||--o{ ORDER : places

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

#29

Post by KronisLV »

This might be silly, but having tools like that built into MySQL Workbench, alongside both forward and backward engineering (get SQL from model and apply it, or get a model from an existing DB) is one of the reasons why I very much enjoyed working with it: https://dev.mysql.com/doc/workbench/en/wb-eer-diagrams-secti... (I might otherwise often prefer PostgreSQL, especially due to the procedural language and transactional DDL), also works fine with MariaDB for the most part

In most projects I've seen people just do some generic models (not even proper ED diagrams) and write some SQL migrations to be applied with something like dbmate or Flyway and call it a day, though working on DB schemas feels like one of the areas where model driven development actually makes a lot of sense and feels natural, if the tooling is there! Otherwise you end up with the actual schema and the models you make diverging slightly over time, either due to people forgetting to add stuff, or you yourself missing something. That's also why I enjoy the likes of DbVisualizer for getting a nice overview about what's actually in the schema: https://www.dbvis.com/

Post reply on HN