erd
tbls
Our great sponsors
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.
erd
-
D2 is now open source – a new, modern language that turns text to diagrams
I like it and the comparison site on https://text-to-diagram.com
I just wanted to drop a reference to Burnt Sushi's ERD tool [0]. It only does one diagram type: Entity Relationship Diagram. It's wonderful. Human-first syntax, code comments, and some simple formatting settings like colors and font sizes that help make more complex diagram pleasing and informative.
- What’s everyone’s favourite documentation tools?
-
Recommendations for a CLI-tool to generate DB diagrams?
Only tool I've come across is erd but have not personally used it. We use LucidChart for our ERDs at work. They have an API to export to PNG and to create documents within it. The documentation for the API is dense, but it is something I am hoping to take a hack day or two to try to understand and see if I can automate generating and updating our own ERDs.
tbls
- FLaNK 25 December 2023
- Tools to use to make high level Architecture diagrams
-
Graphviz: Open-source graph visualization software
Autogenerated database documentation is often pretty hit and miss but tbls[1] does a pretty good job in that space. Especially when you comment on your tables, fields, views, functions etc (which is a good habit anyway!) the output is quite useful
-
Lesser Known PostgreSQL Features
In-database comments combined with something like https://github.com/k1LoW/tbls make for very cheap database documentation.
No affiliation with tbls except that I'm a big fan
-
Recommendations for a CLI-tool to generate DB diagrams?
Check out tbls. You can create a ERD in one command
What are some alternatives?
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.
classy-influxdb-simple
HongoDB - A Simple Key Value Store
ksuid - K-Sortable Globally Unique IDs
prisma-client-go - Prisma Client Go is an auto-generated and fully type-safe database client
mywatch
ampersand - Build database applications faster than anyone else, and keep your data pollution free as a bonus.
pg-ulid - ULID Functions for PostgreSQL
yxdb-utils - Utilities for parsing Alteryx Database format
esqueleto - Bare bones, type-safe EDSL for SQL queries on persistent backends.
hocilib - A lightweight Haskell binding to the OCILIB C API
plantuml-syntax - vim syntax file for plantuml