QuestDB - Cube Documentation

QuestDB is a high-performance time-series database which helps you overcome ingestion bottlenecks.

The driver for QuestDB is supported by its vendor. Please report any issues to their Slack.

Prerequisites

The hostname for the QuestDB database server
- If QuestDB is not running, checkout the QuestDB quick start
Docker (optional)

Setup

Docker

Create a dockerfile within the project directory:

docker-compose.yml

services:
  cube:
    environment:
      - CUBEJS_DEV_MODE=true
    image: "cubejs/cube:latest"
    ports:
      - "4000:4000"
    volumes:
      - ".:/cube/conf"
  questdb:
    container_name: questdb
    hostname: questdb
    image: "questdb/questdb:latest"
    ports:
      - "9000:9000"
      - "8812:8812"

Within your project directory, create an .env file:

CUBEJS_DB_TYPE=questdb
CUBEJS_DB_HOST=my.questdb.host
CUBEJS_DB_PORT=8812
CUBEJS_DB_NAME=qdb
CUBEJS_DB_USER=admin
CUBEJS_DB_PASS=quest

Finally, bring it all up with Docker:

shell

docker-compose up -d

Access Cube at http://localhost:4000 & QuestDB at http://localhost:9000

Environment Variables

Environment Variable	Description	Possible Values	Required
`CUBEJS_DB_HOST`	The host URL for a database	A valid database host URL	✅
`CUBEJS_DB_PORT`	The port for the database connection	A valid port number	✅
`CUBEJS_DB_NAME`	The name of the database to connect to	A valid database name	✅
`CUBEJS_DB_USER`	The username used to connect to the database	A valid database username	✅
`CUBEJS_DB_PASS`	The password used to connect to the database	A valid database password	✅
`CUBEJS_DB_SSL`	If `true`, enables SSL encryption for database connections from Cube	`true`, `false`	❌
`CUBEJS_DB_MAX_POOL`	The maximum number of concurrent database connections to pool. Default is `8`	A valid number	❌
`CUBEJS_CONCURRENCY`	The number of concurrent queries to the data source	A valid number	❌

Presto RisingWave

⌘I

​Prerequisites

​Setup

​Docker

​Environment Variables

Prerequisites

Setup

Docker

Environment Variables