dbml
schemaspy
dbml | schemaspy | |
---|---|---|
5 | 17 | |
2,424 | 3,014 | |
2.9% | 1.5% | |
9.6 | 9.4 | |
4 days ago | 5 days ago | |
JavaScript | HTML | |
Apache License 2.0 | GNU Lesser General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
dbml
-
Show HN: Open source database diagram editor
The underlying markup language is, and there's a number of open source renderers
https://github.com/holistics/dbml
- DBML is a simple, readable DSL language designed to define database structures
-
Show HN: Databasediagram.com – Private, Text to Entity-Relationship Diagram Tool
We've been using https://dbdiagram.io/, which also has an open-source markup language: https://github.com/holistics/dbml
-
Github template for Golang services
I have recently adopted the practice of defining my db schemas using dbml and generating the sql code using their CLI tool. Example: This schema
-
DbDiagram – Draw Entity-Relationship Diagrams, Painlessly
It took a lot of clicking, but they have a GitHub org, too: https://github.com/holistics/dbml#readme
schemaspy
- Show HN: Open source database diagram editor
-
SQLite Schema Diagram Generator
You might try https://schemaspy.org/ - it generates a website with ER diagrams that only go one or two relationships out, but they have clickable table names to get to the next diagram
- Document your database simply and easily
-
DE new on the job
I had the same problem when i started my job. I used SchemaSpy to generate an html with all of metadata and ERD diagrams as a reference point. Then i used dbt to connect to the database and used dbt to document the table and column that i have worked on. It takes time to document but it's worth it if you company don't have your database documented yet.
-
Spring, SchemaSpy DB docs, and GitHub Pages
SchemaSpy is a standalone application that connects to the database, scans its tables and schemas, and generated nicely composed HTML documentation. You can check out an example sample by this link but I'm showing you just one screenshot to clarify my point.
-
pgAdmin Generate ERD stuck on load
I like https://schemaspy.org/
- Tips on investigating new databases with minimal documentation?
-
Looking for a database documenting tool to generate docs for analysts
I like the diagrams and reports SchemaSpy generates. If you are using a DBMS that allows setting comments to tables, views, columns (and other objects), those will be included and that makes those reports even more helpful
- What some of your recommended database mappers?
-
Schema to dia/UML/etc/whatever
https://schemaspy.org/ creates nice looking diagrams.
What are some alternatives?
d2 - D2 is a modern diagram scripting language that turns text to diagrams.
plantuml - Generate diagrams from textual description
sqlc - Generate type-safe code from SQL
Postico - Public issue tracking for Postico
dagre - Directed graph layout for JavaScript
graphviz
Task - A task runner / simpler Make alternative written in Go
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown
template-go-service - Golang service template
sketchviz-docker - Graphviz -> Sketchy PNG in one image, for automation
Mermaid - Edit, preview and share mermaid charts/diagrams. New implementation of the live editor.
heroku-postico - Heroku Postgres connection tool for Postico