QuestDB offers an intuitive Web Console to interact with your data without using the API. It allows you to import data in to the database, run queries on the fly, and export data. Each action will display a timer so you can get a sense of the performance.
After starting QuestDB, you can access the console on http://localhost:9000/index.html
If QuestDB is running on another machine of your network, the web console can be accessed on
he load screen can be accessed by clicking this icon on the left-side navigation menu.
Drag and drop
Simply drag and drop the data file you wish to import in the drag & drop area:
Browse files to import
Click the browse your files button, and select the file you wish to import.
Import from clipboard
You can also
COPY & PASTE from your clipboard into this area. Select the data you would like to import
(from Excel, csv, text etc) and it will import automatically upon pasting into this area.
You can copy data from clipboard from csv, excel and text files.
You can use the
COPY command directly in the web console to import from a file.
COPY tablename FROM file_path.
COPY prices FROM `c:\\user\desktop\prices.csv`;
Customising the upload
After you have loaded data with one of the two methods listed above, you will see it in your console. You can now change the import parameters and import again if you wish. The available option buttons are:
|If selected, data uploaded will be appended to the existing table.|
|If selected, data uploaded will override the existing data.|
|If selected, the first row of your import data will be recognised as headers. If not, header names will be generated automatically (f1, f2, etc.)|
This button will trigger the upload with the parameters selected:
When importing from a file or using copy/paste, QuestDB will automatically detect the type of data in each column. If you click on the file name in the import window, it will open the schema of the file in question. You can see which types have been used.
You can amend Type for any column by selecting the type of your choice in the dropdown menu. You will then need to trigger the import again using the import button.
The web console allows you to run queries on your database directly from the browser. You can access it via this button situated on the left-side menu:
Simply type your query in the editor. Then click
The results will be displayed in the table below the SQL editor.
You will also see metrics such as
execution time and
number of records.
Exporting Query Results
Once you have received results form a query, you can download them in a
.csv file through your browser
by clicking the download button at the top of the console.