Do I need a domain name for QuestDB?

Yes. Your servers and devices send their measurements to it and you open its console in the browser: QuestDB must answer over HTTPS on a stable name. No need to buy one: every ServOrbit VPS comes with a free subdomain (questdb.{dns_slug}.servorbit-dns.com) with an HTTPS certificate. You can also use a subdomain of one of your domains.

How do I log in for the first time?

Open https://your-domain and enter the admin user and the password shown in your client area on the "Sign in to QuestDB" screen. The same credentials protect the REST API, ingestion on /write and the PostgreSQL protocol.

How do I delete old data?

QuestDB stores each table in time partitions. Drop the oldest ones in SQL, for example ALTER TABLE capteurs DROP PARTITION WHERE timestamp < dateadd('d', -90, now()), and schedule the command if needed. Size the disk according to the volume you receive each day.

Spin up a data platform quickly.

QuestDB

QuestDB — time series in SQL on your VPS: fast ingestion, web console, REST API and PostgreSQL protocol, protected by a password.

2 GB minimum RAM 1 vCPU Port 8112 In validation

In validation

Automatic installation for this solution is ready and currently going through our tests on a real server. Ordering will open as soon as validation is complete.

Source code

Tech stack

DockerJavaQuestDB

Minimum RAM2 GB minimum

Minimum CPU1 vCPU

Default port8112

Compatible OSChoice of Linux distributions

QuestDB is an open-source time-series database (Apache-2.0 licence). It is built for one job: continuously receiving timestamped measurements — sensors, application metrics, market prices, events — and querying them right away in SQL, without learning a new language.

Its SQL adds time-series operations: `SAMPLE BY` to aggregate by interval, `LATEST ON` for the latest value of each series, `ASOF JOIN` to align two streams in time. Data arrives over the InfluxDB Line Protocol on HTTP (official clients exist for Python, Go, Java, Node.js, Rust, C/C++ and .NET), through CSV import or in SQL. A built-in web console serves as SQL editor, import tool and quick chart, and the PostgreSQL protocol lets you plug in your usual tools and drivers.

Key features

Time-series SQL — SAMPLE BY, LATEST ON and ASOF JOIN on top of standard SQL.

Fast ingestion — InfluxDB Line Protocol over HTTP, with official clients for Python, Go, Java, Node.js, Rust and .NET.

Built-in web console — SQL editor, CSV file import, charts of the results.

REST API — queries, CSV import and export over HTTP, from any language.

PostgreSQL protocol — your usual PostgreSQL drivers and tools, from programs on the VPS.

Protected access — admin user and generated password, required on the HTTP API, ingestion and the PostgreSQL protocol.

When to use this solution?

1

IoT measurements

Your sensors or gateways send their readings over HTTPS; you compute hourly or daily averages in SQL and spot the latest value of each device.

2

Application metrics and events

Record timestamped response times, orders or sign-ups from your code, then analyse them in SQL from the console or the REST API.

3

Market and finance data

Store high-frequency prices or trades and align two streams in time with ASOF JOIN for your analyses.

Deploy QuestDB on your VPS

Guide optimized for ServOrbit Cloud VPS.

01

Create the VPS and choose the address

Order an Ubuntu 24.04 VPS with at least 2 GB of RAM (4 GB if you ingest a lot of data). QuestDB requires a domain: your servers and devices send their measurements to it, so it must answer over HTTPS on a stable name. It opens on a subdomain of one of your domains, or on the VPS's free subdomain (questdb.{dns_slug}.servorbit-dns.com), HTTPS included. No need to buy a domain name.

02

Install QuestDB from the Marketplace

In your client area, select QuestDB, choose the address and click Install. The script deploys the official container, generates the admin user's password, enables authentication on the HTTP API and the PostgreSQL protocol, turns off anonymous telemetry and configures the nginx reverse proxy over HTTPS.

03

Log in for the first time

Open https://your-domain: the console shows "Sign in to QuestDB". Enter the admin user and the password shown in your client area, then run SELECT build(); in the SQL editor to check access.

04

Send your first data

Write a line in InfluxDB Line Protocol format to https://your-domain/write with the same credentials as basic authentication: the table is created on the first write. From your code, use an official QuestDB client with a https::addr=your-domain:443;username=admin;password=…; configuration.

05

Query in SQL

In the console or through the REST API (/exec), aggregate by interval with SAMPLE BY 1h and fetch the latest value of each series with LATEST ON. A program on the VPS can also connect over the PostgreSQL protocol on 127.0.0.1:8812.

Frequently asked questions

ClickHouse is a general-purpose analytical database, designed for large volumes and ad hoc queries on any kind of data. QuestDB focuses on time series: each table has a designated time column, ingestion is continuous, and its SQL adds SAMPLE BY, LATEST ON and ASOF JOIN. For timestamped measurements to receive and query live, QuestDB is the simpler of the two.

Complementary solutions

Databases

QuestDB isn't orderable yet.