SchemaCrawler
sqlite-schema-diagram
| SchemaCrawler | sqlite-schema-diagram | |
|---|---|---|
| 8 | 1 | |
| 1,553 | 18 | |
| - | - | |
| 9.7 | 5.4 | |
| 4 days ago | about 1 month ago | |
| Java | Makefile | |
| GNU General Public License v3.0 or later | GNU Affero General Public License v3.0 |
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.
SchemaCrawler
- SQLite Schema Diagram Generator
- [Look for advice ]for choice of tools/diagram for mapping database
-
Automatically Document Your Database in Markdown
Grab the Python script of "markdown.py" from SchemaCrawler's GitHub repository, and save it in your local directory.
-
Create Nice-looking Schema Diagrams in PlantUML
Take a look at SchemaCrawler, which extends functionality by connecting to your database server and generating a PlantUML schema diagram from it using this technique.
-
How to Document Your Cassandra Database with One Command (and Nothing to Install)
You can save the output with an additional --output-file /share/schema.txt argument, and the file will be created in your local directory. schemacrawler help will give you more information, as well as the SchemaCrawler website. Now you are ready to connect to your own database. If you need help on how to construct the connection URL, take a look at ing-bank/cassandra-jdbc-wrapper.
-
Generate (Good Looking) PlantUML Diagrams for Your Database
Try it out. Make sure that you have Docker installed on your system, or download SchemaCrawler. Download a sample SQLite database called "chinook-database-2.0.1.sqlite" into your current directory.
-
Use schemacrawler to generate Mermaid diagram
schemacrawler website
sqlite-schema-diagram
-
SQLite Schema Diagram Generator
This is very cool. Reminds me of my days 13 years ago using dot to draw complex planaarized graph diagrams before switching to physics / springs models, graph embeddings, and other cool things.
Nice to see a really good use for dot.
I created a fork on GitHub as a fork there'll be easier for me to come back to, find, organize and use (and may be for others too): https://github.com/o0101/sqlite-schema-diagram
I hope you don't mind? If you don't want ur code there let me know and I'll sadly but obediently take it down and just link to it from someplace on there I can readily find. :)
What are some alternatives?
Mermaid - Edit, preview and share mermaid charts/diagrams. New implementation of the live editor.
datahub - The Metadata Platform for your Data Stack
Hibernate - Hibernate's core Object/Relational Mapping functionality
marquez - Collect, aggregate, and visualize a data ecosystem's metadata
plantuml - Generate diagrams from textual description
H2 - H2 is an embeddable RDBMS written in Java.
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
requery - requery - modern SQL based query & persistence for Java / Kotlin / Android
cassandra-jdbc-wrapper - A JDBC wrapper of Java Driver for Apache Cassandra®, which offers a simple JDBC compliant API to work with CQL3.
CommitCombo - 깃허브 커밋 기록을 아름답게 꾸미는 프로젝트 ⭐
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
chinook-database - Chinook database packaged as a jar, for use in Java and with Testcontainers [Moved to: https://github.com/sualeh/chinook-database]