This is awesome! I have been playing around this past week with what I want in a tool to explore a SQLite database (it doesn’t have any foreign keys mapping fields, so I want to determine which fields might be related based on what they contain, particularly UUIDs and keys larger than a certain size) I frequently need to reverse the schema on. I was thinking of building a graph using neo4j or some such, but this seems so much lighter weight and I love the idea of adding almost no dependencies beyond sqlite itself. It is very inspiring, thanks for writing/sharing this!
I’ve been using chatGPT to turn the sql create script for a project into markdown suitable for interpretation into a diagram with mermaid.js… this seems like a less burdensome path and one I can add directly to the documentation generation to the project.
Serious question: what made you decide to use ChatGPT for something that seems perfectly deterministic?
Edit: And for context, my read of your comment is that you’re asking ChatGPT to do it directly, instead of asking it to generate code that would do it consistently the same way, for example.
I’ve been using SchemaSpy to generate these kinds of diagrams. It supports a bunch of different database engines, though it’s nowhere near as lightweight as this tool.
This is awesome! I have been playing around this past week with what I want in a tool to explore a SQLite database (it doesn’t have any foreign keys mapping fields, so I want to determine which fields might be related based on what they contain, particularly UUIDs and keys larger than a certain size) I frequently need to reverse the schema on. I was thinking of building a graph using neo4j or some such, but this seems so much lighter weight and I love the idea of adding almost no dependencies beyond sqlite itself. It is very inspiring, thanks for writing/sharing this!
Cool!
As an aside, it reminds me of a misguided experiment of mine at using Matlab as a Scheme metaprogramming environment, back when I was in college.
Very nice!
I’ve been using chatGPT to turn the sql create script for a project into markdown suitable for interpretation into a diagram with mermaid.js… this seems like a less burdensome path and one I can add directly to the documentation generation to the project.
Serious question: what made you decide to use ChatGPT for something that seems perfectly deterministic?
Edit: And for context, my read of your comment is that you’re asking ChatGPT to do it directly, instead of asking it to generate code that would do it consistently the same way, for example.
I’ve been using SchemaSpy to generate these kinds of diagrams. It supports a bunch of different database engines, though it’s nowhere near as lightweight as this tool.