drawdb-io / drawdb-io/drawdb

RestFul API support

Open
#703 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
39.5k
Forks
3.2k
Avg merge
10h 46m
Merged PRs (30d)
16

Description

I'd like to use drawdb to visualize the ERD from a Restful API.

Meaning, I would create a backend that exposes the data in the drawdb native Json format. The user clicks on a link, this opens drawdb, imports the json via the provided query string, and does an autolayout.

So I would use drawdb less as an editor and more like a visualization tool.

My database has approx 10'000 tables and showing all of those does not make sense. So I would rather have a directory of 100 star schemas in a html page and the user can select one with a few attributes, e.g.
- get fact table billings
- get fact table billings and all direct relationships to the dimension tables
- get fact table billings and all direct and indirect relationships, e.g. billings is connect to orders via customer dimension table
- get all tables in a schema

From what I understand
1. You cannot pass a json file/rest api via an URL when starting the editor
2. Import Json requires to upload a file - need to point to an URL instead
3. Autolayout is not triggered automatically - might be good to add that as a property to the json file

Thoughts?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.