Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

webui: display databases tab as an ERD #48418

Closed
awoods187 opened this issue May 5, 2020 · 2 comments
Closed

webui: display databases tab as an ERD #48418

awoods187 opened this issue May 5, 2020 · 2 comments
Labels
A-sql-ui Why is my query slow? A-webui-queryperf C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-wishlist A wishlist feature. no-issue-activity X-stale

Comments

@awoods187
Copy link
Contributor

awoods187 commented May 5, 2020

The webui offers an excellent database tab:
image
You can drill down into any individual table to see its schema:
image
Unfortunately, you can't see how the tables relate to each other in one view. Instead, you need to remember the foreign key and other relationships.

It would be a much better experience if you could see an ERD instead:
image

This would allow you to remind yourself of the relationships between the tables before diving into a specific table. It's also a critical step in query performance debugging.

Jira issue: CRDB-4328

@blathers-crl
Copy link

blathers-crl bot commented May 5, 2020

Hi @awoods187, I've guessed the C-ategory of your issue and suitably labeled it. Please re-label if inaccurate.

While you're here, please consider adding an A- label to help keep our repository tidy.

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.

@blathers-crl blathers-crl bot added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label May 5, 2020
@awoods187 awoods187 added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) and removed C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. labels May 5, 2020
@piyush-singh piyush-singh added the C-wishlist A wishlist feature. label May 27, 2020
@awoods187 awoods187 added the A-sql-ui Why is my query slow? label May 27, 2020
@github-actions
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Sep 26, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-sql-ui Why is my query slow? A-webui-queryperf C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-wishlist A wishlist feature. no-issue-activity X-stale
Projects
No open projects
Status: Done
Development

No branches or pull requests

3 participants