schemaspy
Graphia
schemaspy | Graphia | |
---|---|---|
17 | 8 | |
3,014 | 222 | |
1.5% | 1.4% | |
9.4 | 9.7 | |
4 days ago | about 17 hours ago | |
HTML | C++ | |
GNU Lesser General Public License v3.0 only | GPL3 |
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.
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.
Graphia
-
NetworkX – Network Analysis in Python
Export the graph to GML or to GraphML or to GraphViz DOT or to some other Graph format. BTW I recommend 3D graph visualization over 2D when possible, that is when you're exploring interactively as opposed to printing figures. The Graphia tool is the only FOSS tool for this purpose that I know of:
https://graphia.app
https://github.com/graphia-app/graphia
-
How to create a map showing the relationship between separate data points?
I may be biased. https://graphia.app
-
Graphviz: Open-source graph visualization software
A fast 3D alternative for visualizing large graphs is Graphia: https://github.com/graphia-app/graphia https://graphia.app However, it's currently suffering from the Qt switch from 5 to 6.
Regarding Graphviz itself, I wonder why is there no special layout logic for planar graphs? They can be recognized and embedded on the plane in linear time without intersecting edges, so it would be very nice if some of the Graphviz tools actually did that.
A recent set of minimal graph coloring Graphviz visualizations of mine: https://gitlab.com/nsajko/example_optimally_colored_graphs
- Handbook of Graph Drawing and Visualization
- Rick and Morty’s Thanksploitation Deciduous Decision Tree
What are some alternatives?
plantuml - Generate diagrams from textual description
AlphaPlot - :chart_with_upwards_trend: Application for statistical analysis and data visualization which can generate different types of publication quality 2D and 3D plots with extensive visual customization.
dbml - Database Markup Language (DBML), designed to define and document database structures
matplotplusplus - Matplot++: A C++ Graphics Library for Data Visualization 📊🗾
Postico - Public issue tracking for Postico
Gephi - Gephi - The Open Graph Viz Platform
graphviz
dtale - Visualizer for pandas data structures
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown
sketchviz - A command line clone of https://sketchviz.com/
sketchviz-docker - Graphviz -> Sketchy PNG in one image, for automation
pygraphistry - PyGraphistry is a Python library to quickly load, shape, embed, and explore big graphs with the GPU-accelerated Graphistry visual graph analyzer