Show HN: Databasediagram.com – Private, Text to Entity-Relationship Diagram Tool

• dbml

  5 2,417 9.6 JavaScript

  Database Markup Language (DBML), designed to define and document database structures

  

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

• spark-joy

  37 9,204 6.8 JavaScript

  ✨😂 2000+ ways to add design flair, user delight, and whimsy to your product.

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

• SurveyJS

  surveyjs.io sponsored

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

• d2

  92 15,837 9.8 Go

  D2 is a modern diagram scripting language that turns text to diagrams.

  

The issue I have with a lot of these tools is they work fine when depicting relationships between tables in the same schema (talking mainly about PostgreSQL databases), but few support showing relationships between tables across different schemas.

Also, when the number of tables grows large, few have layouts arranged in an optimal way. I use D2 (https://d2lang.com/) to create ERDs. However, of the free layout engines available in D2, Dagre (https://github.com/dagrejs/dagre) and ELK (https://github.com/eclipse/elk) both don't have optimal placement of layouts for a sufficiently complicated database.

• dagre

  8 4,268 8.8 JavaScript

  Directed graph layout for JavaScript

  

The issue I have with a lot of these tools is they work fine when depicting relationships between tables in the same schema (talking mainly about PostgreSQL databases), but few support showing relationships between tables across different schemas.

Also, when the number of tables grows large, few have layouts arranged in an optimal way. I use D2 (https://d2lang.com/) to create ERDs. However, of the free layout engines available in D2, Dagre (https://github.com/dagrejs/dagre) and ELK (https://github.com/eclipse/elk) both don't have optimal placement of layouts for a sufficiently complicated database.

• elk

  3 232 8.0 Java

  Eclipse Layout Kernel - Automatic layout for Java applications. (by eclipse)

  

The issue I have with a lot of these tools is they work fine when depicting relationships between tables in the same schema (talking mainly about PostgreSQL databases), but few support showing relationships between tables across different schemas.

Also, when the number of tables grows large, few have layouts arranged in an optimal way. I use D2 (https://d2lang.com/) to create ERDs. However, of the free layout engines available in D2, Dagre (https://github.com/dagrejs/dagre) and ELK (https://github.com/eclipse/elk) both don't have optimal placement of layouts for a sufficiently complicated database.

• sqlparse

  7 3,581 8.2 Python

  A non-validating SQL parser module for Python

Suggest checking out the sqlparse library for a way to do the different flavours without needing to address each case directly: https://github.com/andialbrecht/sqlparse

• Mermaid

  90 3,562 9.1 TypeScript

  Edit, preview and share mermaid charts/diagrams. New implementation of the live editor.

  

ditto, it's 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 projects I'm working on.

0. https://mermaid.live/

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project