EVA-DB UI: Display Query Results in the UI

[kslohith]

Search before asking

• [X] I have searched the EvaDB issues and found no similar feature requests.

Description

This starts the development lifecycle of the UI for EVA-DB, This particular Issue is for displaying the results of the eva-db query in the ui in a form of a table.

Use case

Users wanting to try out eva-db and not having enough experience with python will use this feature directly from the browser to run their eva-db queries and see the results on the browser itself.

Are you willing to submit a PR?

• [X] Yes I'd like to help by submitting a PR!

[xzdandy]

Hi @kslohith, thanks for looking for UI! Feel free to share your plans and ideas in the issue, so we can provide feedbacks.

[kslohith]

Hi @xzdandy , I have the first prototype ready, attaching the screenshots below,

This is the initial screen which the user will see. The drawer has options of home, playground and create udf.

Here the user has executed a query for eva-db and the response is being shown in the form of a table. The table is intelligent/dynamic in nature it will adopt to the number of columns which are being returned.

Here we can expand the drawer to see the options available to the user.

Please provide suggestions and ways to improve the UI. Tasks Remaining before first Milestone:

1. Option to display Query Plan along with Query Results. Planning to add tabs in the Query Response component.
2. The code Editor will be having autocomplete and other ide features soon.
3. Add Data Source page will be implemented where we can configure which database we want to connect to( mysql, postgres etc)

[xzdandy]

Hi @kslohith, it looks great. I think we can merge the current prototype version and start host it. We can work on the remaining tasks you mentioned incrementally.

Do you have a plan to support unstructured data like images?

Hi @gaurav274 @jarulraj @jiashenC, please provide feedback.