This is a wip, it will be a visualization tool for any database when it is done. It will work through the command line and expect you to either ask it for schemas, or a row. With that decision, it will query for the data and all related data, then create an html file that will display that data in a graph format with the relationships highlighted. There will be more features later, but for now, this is what I want for my job, so that's what it is going to be!
The first db will be postgresql, because that is what we currently use at my company. After that, sqllite will be added, then mongodb. Then it will be opened up to the public for any other db that people want to add.
TLDR: ONLY WORKS ON POSTGRES
steps to use:
- clone the repo
- cd into the repo
- type 'go build && go run dbVisualizer.com'
- Select the first option (second will come with future pr's)
- Fill in the following (With your db data -> reminder, only works with postgresql at the moment):
- Wait for the following screen:
- Go to: http://localhost:42069/
- The following screen should be there
- Click on the details to view the data
- Nested details are foreign keys, table data is non-foriegn
- After 2 layers of nesting, on hover of detail, you get a tooltip that is clickable
- Click on the tooltip -> should make that table the new main table
-
There are now breadcrumbs that are clickable
-
To go back to the main view click reset, or the left-most breadcrumb
-
To change tables, enter a new table name in the cli
-
You might need to reload the page at localhost (bug I am working on)
-
If you want to view the current subtree in a graph format, click graph
- On hover of item it will display the node and subnodes
