apache / kyuubi

Apache Kyuubi is a distributed and multi-tenant gateway to provide serverless SQL on data warehouses and lakehouses.
https://kyuubi.apache.org/
Apache License 2.0
2.11k stars 916 forks source link

[Improvement] Improve the display of sql editor and query result #6660

Closed wangzhigang1999 closed 2 months ago

wangzhigang1999 commented 2 months ago

Code of Conduct

Search before asking

What would you like to be improved?

image The image shows a SQL Editor that has only a few lines of code displayed, despite having ample space available. This underutilization of screen real estate can lead to inefficiencies in workflow, as users might find themselves scrolling or switching between multiple screens to manage their SQL queries effectively.

Additionally, the limited display area might make it challenging for users to work on more complex SQL statements or compare multiple lines of code at once. This could negatively impact productivity and make the overall experience less intuitive and user-friendly.

How should we improve?

image

My solution consists of two key changes: first, I recommend expanding the SQL Editor to take up the entire screen, which will give users more room to write and edit their code without constantly needing to scroll or switch between screens. This modification will result in a cleaner and less cluttered environment for SQL coding.

Secondly, I propose incorporating a drawer feature to display query results. In this context, the drawer will reveal the outcomes of executed SQL queries, enabling users to review their results without losing sight of their code or leaving the SQL Editor.

I've implemented a simple version, and the effect is shown in the image above. If possible, I would be happy to submit a PR. Additionally, if the community has other better solutions, I would be open to considering those as well.

Are you willing to submit PR?

github-actions[bot] commented 2 months ago

Hello @wangzhigang1999, Thanks for finding the time to report the issue! We really appreciate the community's efforts to improve Apache Kyuubi.

wangzhigang1999 commented 2 months ago

add new example image

pan3793 commented 2 months ago

Thanks for your idea, how about?

---------------------------------------
|                                     |
|                                     |
|              SQL Editor             |
|                                     |
|                                     |
--------------------------------------- Draggable Border
|                                  v ^| Also buttons to allow minimize/maximize the Result/Log pannel
|              Result/Log             |
|                                     |
---------------------------------------
wangzhigang1999 commented 2 months ago

Thanks for your idea, how about?

---------------------------------------
|                                     |
|                                     |
|              SQL Editor             |
|                                     |
|                                     |
--------------------------------------- Draggable Border
|                                  v ^| Also buttons to allow minimize/maximize the Result/Log pannel
|              Result/Log             |
|                                     |
---------------------------------------

Good idea! šŸ«”