antoniovizuete / clickhouser Goto Github PK

The app footprint is ~7Mb. BlueprintJS represents the majority of the size.

Add context menu to column headers to be able to copy its name.

If you try to query for a field whose type is Map(K,V) the table renders:

Expected result:
Render as Clickhouse Query does:

I would like to be able to save the connections locally in the browser.

The application could include a button to save a connection (by naming it) and a dropdown where you can load the data of a saved connection.

The connections would be saved in the browser using local storage.

Add timeout error when a query lasts more than a minute

Related to issue #37

Add a button that allows downloading the query result.
The button will be a dropdown that allows selecting the output format which will be JSON, JSONEachRow, CSV, or TSV.

As a user, I want to be able to format the SQL code automatically.

If the query returns only one record then the data should be shown in columnar table instead of tabular table.

If you enter a url with an invalid port in the host, the page goes blank:

examples of invalid urls:

• http://localhossst:1234678/
• http://localhossst:asdfgfh

Add tabs in order to have more than one query at the same time.

Add a bar that shows the query statistics. It must show:

• Elapsed time
• Number of rows
• Quantity of received bytes

Merge download "As CSV" and "As TSV" into one item "As Separated Values".
When it will be clicked must show a popup that asks for the settings of the exportation.
It will be settable:

• Separator character
• Wrapper character

Nice to have:

• Could there be a selector with presets such as CSV, TSV or whatever.

As a user, I need to upload data to the clickhouse server.

• The application must have a button to trigger the action. It must be available on the button bar.
• When the button is clicked, a modal must be shown, asking for the file to load:
  • There will be an area to receive the file by dropping into it.
  • There will be a button to open the native file explorer dialog.
• Once the file has been selected, the modal must ask for the loading settings:
  • There will be an input to enter the table where the date will be loaded.
  • There will be a dropdown to select the actual format of the loaded file (it could be guessed based on the file extension).
  • There will be a button to continue the process ("Upload").
  • There will be a button to dismiss the process ("Cancel").
• Once the "Upload" button has been clicked, the HTTP request for ingesting the data will be launched. The modal will wait for the server's response.

• The modal will be dismissable when on the first two steps
• The modal WON'T be dismissable. when the request has been launched.

The SQL editor should suggest the database objects. Such as:

• Available databases
• Available tables

CD is running on Vercel currently. To be able to deploy the last commit which is created by semantic-release, the CD workflow must be managed on GitHub actions.

Actual behaviour

When a component that has a backdrop is shown the resizing bars still working.
You can reproduce it by clicking on the help button.

Expected behaviour

The dialogs, or the future drawers, have a backdrop which disables the user to interact with the overlayed components.