What is your go-to diagrams software to draw diagrams such as Entity Relationship ones?

It is really nice that one can create also non elixir topic here, so I’m taking the opportunity. ^^

I’m looking for a free diagrams software that is easy to work with on linux.
Though, Entity Relational Diagrams are my main goal. Since I’m working with Ecto I find them very useful.

I’m using currently draw.io offline version for linux but sadly I miss “comments” feature.
Other solutions I tried are mostly limited in free version or no more maintained.

1 Like

Have a look at this thread @Kurisu

Is that the sort of thing you meant? :smiley:

3 Likes

dbdiagram is aweome and completely free

4 Likes

Yes thank you, I will have a look at that topic. ^^

Will definetly try it. Thanks ^^

1 Like

I use MermaidJS all the time. https://mermaidjs.github.io/#/

Can be interactive and styled as needed.

2 Likes
  • GraphViz for simple graphs/trees
  • PlantUML for more complex diagrams

For ERD I have written script that generates GraphViz file with ERD of the given DB.

3 Likes

I’m aware that my option may seem more esoteric than others, but I prefer to make these types of diagrams using TikZ. You can knock out a bunch of text-filled rounded rectangles with connecting arrows in a heartbeat. Obviously the downside is the learning curve, but the upside is the versatility—I create all of my (non-data-plotting) figures and diagrams like this—there’s very little you can’t draw if you’re willing to learn the language.

PDF manual for TikZ

[edit] One additional comment I would make is that diagramming in Latex/Tikz gives you the ability to version control the entire process, trying out various branches of the diagram in a lossless way. I find this invaluable.

2 Likes

I use DBeaver, which is an open source (and cross platform) database exploration tool.

It does more than ERDs but it handles ERDs quite nicely, although it doesn’t support comments. I made a video showing some of its features here: https://nickjanetakis.com/blog/manage-and-create-diagrams-of-your-sql-database-for-free-with-dbeaver

3 Likes