Free QuestDB SQL IDE

QuestDB is an open source time-series database. The database is column-oriented and optimized for high-speed ingest and blazingly fast SQL analytics. qStudio is a free SQL IDE, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including QuestDB.

Setting up a QuestDB connection in qStudio

Start QuestDB
Connecting to QuestDB
Querying QuestDB

Start QuestDB

Download QuestDB from the official website.
Start questdb.exe

Connecting to a Server

QuestDB provides a number of APIs, REST / ILP - InfluxDB Line Protocol and PostgreSQL wire protocol.
For querying we are going to connect to the PostgreSQL on port 8812

When you first open qStudio it will look like the image below.
Click on the menu options Server->Add Server or on the add server button on the toolbar.

Server Type: Postgres
Host:localhost
Port: 8812
Database: qdb
Username: admin
Password: quest
Click Add

Sending Queries

Copy paste the below code into the SQL editor. Then highlight the commands you want to run and press Ctrl + e to run that code. See Keyboard Shortcuts.

Command	Shortcut
Run highlighted text	Ctrl + e
Run Line	Ctrl + Enter

CREATE TABLE readings
AS(
    SELECT
        x ID,
        timestamp_sequence(to_timestamp('2019-10-17T00:00:00', 'yyyy-MM-ddTHH:mm:ss'), rnd_long(1,10,0) * 100000L) ts,
        rnd_double(0)*8 + 15 temp,
        rnd_long(0, 10, 0) sensorId
    FROM long_sequence(10000000) x)
TIMESTAMP(ts)
PARTITION BY MONTH;

SELECT ts,avg(temp) FROM readings WHERE sensorId=3 AND 
        ts IN '2019-10-21;1d' -- this is an interval between 2019/10/21 and the next day
        SAMPLE BY 1h -- aggregation by hourly time buckets
        LIMIT 11010;

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

The Server Tree

The server tree populates, you can click on tables within the tree to see their data.

Well Done! You have now got qStudio querying your database successfully.

We want to make qStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.