[social]Digging for a good SQL database diagramming app or service where it would map variables to variables (keys to keys) across tables not a general connection. I stumbled onto DBML (database markup language) https://dbml.dbdiagram.io/home/, and a few different online diagramming tools that will take the DBML and turn it into a ERD diagram. DB Diagram is one - https://dbdiagram.io - and it works well. There is also a python package
[social](https://pypi.org/project/pydbml/) that will take the DBML and turn it into solid SQL to create the tables. I’ve tried it and it has worked well, but my son has picked it up and been running with it on his internship.
[social]I hadn’t run across DBML (as a viable option) until a couple weeks ago. I looked at it a couple years ago and the diagramming options weren’t great and the markup to SQL options had some bugs as well. It seems workable for small to mid-sized projects now.
[tantek]this is for folks that want to link to their .md or whatever on GH for their blog posts and clearly express that it's a repo which communicates that it *may* be open to PRs for fixes etc. (no promises, not like rel=edit)
sarna, barnaby, [marksuth] and sp1ff joined the channel