databasediagram.com

Dev tools

diagramming tool

SHOW HN2023

262points
80comments
#186of 3,109 in 2023
Top 6%of 2023 by points

How HN took it

MixedNo clear lean

8 positive, 13 neutral or asking, 1 mixed, 7 critical, out of 29 comments about the project. Thread score +0.12.

Idea: 4 for, 1 againstExecution: 1 for, 3 againstDesign: 1 for, 1 againstPrivacy: 0 for, 1 againstDocs: 0 for, 1 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Simple, terse text syntax for diagrams

    From 3 comments
    • It does look VERY similar, but I think they tried to make the language a bit more terse. As a said is another comment, I think the slightly additional structure is actually better.
      bdcravens on HN
    • Compare the examples in the post against the official Mermaid examples[0]. The syntax seems much simpler. 0. https://mermaid.js.org/syntax/entityRelationshipDiagram.html
      ASalazarMX on HN
    • This looks fantastic, exactly what I needed last time I worked with DBs and could not find. Hope to be using it soon.
      davidktr on HN
  • Useful for documenting schemas

    From 2 comments
    • Thanks! I was writing a FastAPI/SQLAlchemy+SQLModel/Rocketry app this week and dreaded documenting my model relationships. That said, I see a few SQLAlchemy extensions and…
      hackish on HN
    • I’m a tech writer and love the idea of “drawing” diagram using the markup. Definitively will try to use it by my another docs project. Thank you.
      mattdocumatt on HN

Objections

  • Uploading database schemas to a web app raises privacy concerns

    From 2 comments
    • I like the markup language and the app looks nice but I just can't comfortably dump database schemas into random web apps.
      tempest_ on HN
    • 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.…
      jcoder on HN
  • Error handling and feedback are weak

    From 2 comments
    • 1. Why not just use SQL? 2. You should really work on error handling. I went to /app and tried changing the name of the CustomerID column, and nothing happened. I tried changing…
      Kwpolska on HN
    • I'm using Firefox. On my larger screen, the toast did appear, but it was outside of the scrolled-in view. On my smaller screen, the layout just broke and the toast is not visible.
      Kwpolska on HN
  • Auto-layout is lacking for large schemas

    From 2 comments
    • Thanks! I was writing a FastAPI/SQLAlchemy+SQLModel/Rocketry app this week and dreaded documenting my model relationships. That said, I see a few SQLAlchemy extensions and…
      hackish on HN
    • Ah, that's nice to hear. This is one of my frustrations with Mermaid - trying to work out he magical correct ordering of entities to render something that isn't too chaotic.
      thom on HN

Requests

  • Import from SQL DDL and other database flavors

    From 2 comments
    • did you consider letting the input be just sql ddl rather than yet another layer of ddl?
      allanrbo on HN
    • 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…
      capitanazo77 on HN
  • Export to DDL

    From 2 comments
    • I love tools like this (text to diagram) and tend to use mermaid for most things. I also really like draw.io which includes a gui and has integration with GitHub to save diagrams…
      digitalsanctum on HN
    • > Generate DDL directly generate SQL statements to create your database tables. Looks like it's capable of turning a diagram to SQL too? That's neat! For those that are…
      shinkim0914 on HN
  • Dark mode

    From 1 comment

Questions

  • Why not just use SQL as input?

    From 2 comments
    • 1. Why not just use SQL? 2. You should really work on error handling. I went to /app and tried changing the name of the CustomerID column, and nothing happened. I tried changing…
      Kwpolska on HN
    • did you consider letting the input be just sql ddl rather than yet another layer of ddl?
      allanrbo on HN
  • How does it compare to dbdiagram.io and DBML?

    From 2 comments
    • We've been using https://dbdiagram.io/, which also has an open-source markup language: https://github.com/holistics/dbml
      shizcakes on HN
    • Every engineer I know have been using DBML for a while. Did they fail their market research ? Edit: Damn, it really look like they were copying dbdiagram.io, down to the FK…
      Fiahil on HN

Alternatives named

  • dbdiagram.io and DBML

    From 1 comment
    • We've been using https://dbdiagram.io/, which also has an open-source markup language: https://github.com/holistics/dbml
      shizcakes on HN
  • Mermaid

    From 2 comments
    • I'm not too familiar with ER-diagrams -- how does this compare to Mermaid? https://mermaid.js.org/syntax/entityRelationshipDiagram.html
      vegarab on HN
    • 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…
      thom on HN
  • Quick Database Diagrams

    From 1 comment
    • Cool tool. My favorite tool for text to model / model to SQL is: https://app.quickdatabasediagrams.com/
      otto_ortega on HN
  • ERDLab

    From 1 comment
    • I use ERDLab Check it out at https://app.erdlab.io/designer/new Has a lot more cool features for better visual representation like color tagging and search. I also like the…
      sexydev on HN
  • SchemaSpy

    From 1 comment
    • From what I can tell, a lot of these tools seem OK for capturing relatively simple database designs, but at least "look" fairly inadequate for more robust needs. This makes sense…
      sbuttgereit on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/36243926)