QuestDB

QuestDB

QuestDB is a relational database management system that is designed for speed and performance. To establish a connection with QuestDB, you must first ensure that the server you are connecting from has the appropriate network access to reach the QuestDB database. This may require configuring your firewall or network settings, depending on your specific setup. 

Once you have verified that the necessary access has been granted, you can proceed with providing the relevant information to establish the QuestDB connection. This will typically include details such as the database name, host address, and port number. If the table you wish to use is not yet created, or you need to make changes such as adding columns, you may need to select the appropriate option to create or modify a table. 

By completing this process accurately and comprehensively, you can establish a successful connection with QuestDB and begin working with your data. 

 

The table below provides an explanation and type of parameters that must be filled by the user to establish a connection with QuestDB. It outlines the specific parameters required and their corresponding data types, which must be correctly entered to successfully establish a connection with QuestDB. 

Quest DB 

Host 

Server Host 

String 

Port  

Server Port 

Int 

DatabaseName 

Name of database 

String 

Schema 

Schema name 

String 

UserName (Optional) 

Username to connect to server 

String 

Password (Optional) 

Password to connect to server 

String 

JDBCConnectionString (Optional) 

A connection string to connect to server 

String 

Inputs 

Connection Inputs 

List 

Outputs 

Connection Outputs 

List 

 

Once the connection with the QuestDB source has been established successfully, the "input" page is utilized to define the data or dataset. This step involves specifying the necessary details related to the data or dataset, such as its location, type, and structure. Ensuring that all the relevant information is accurately entered on the "input" page to properly define the data or dataset is crucial for the successful transfer of data to a QuestDB table. 

A detailed explanation of the Query Editor feature can be found in section 2.1 of this user manual. This feature enables tables and columns within your database to be easily navigated and selected, and then used in your SQL queries by typing the query in the editor section. 

To view the results of the written query, refer to section 2.2, which covers the 'Execute Query' feature. This feature allows the user to execute the query and view the output in the result window, as described in the previous section. By combining the Query Editor feature with the ability to execute SQL queries, users can easily navigate their databases and select tables and columns to be used in their queries. 

 

Input 

Query 

Query to run 

String 

 

To transfer the data package created by the user to a QuestDB table, it is necessary to define an output. If the table is not already present in the database or the user wishes to make modifications like adding columns to it, then they must choose the "Create Table" option. This allows the user to create a new table, by specifying the required details such as the table name, data type and size of the columns, and any constraints on the table. It is important to ensure that all the required information is accurately entered when creating a table in QuestDB. Once the table is created, the user can then use SQL queries to transfer data to the table or modify it as required. 

 

Output 

TableName 

Name of the table 

String 

CreateTable 

Whether to create a new table if it does not exist 

Bool 

    • Related Articles

    • Time Series Databases

      Introduction to Time Series Databases Time series databases are specialized databases designed to handle large amounts of time-stamped data, making them ideal for applications that require high-speed data ingestion, complex querying, and efficient ...