Introduction

QuestDB is a relational column-oriented database designed for time series and event data. It uses SQL with extensions for time series to assist with real-time analytics. These pages cover core concepts of QuestDB, including setup steps, usage guides, and reference documentation for syntax, APIs and configuration.

Get Started

This section explains how to install and run QuestDB using one of the following methods:

• Docker for repeatable, portable and scalable installations
• Binaries for direct downloads to run on Linux, macOS or Windows
• Homebrew for running QuestDB on macOS
• Create your first database provides a guide once QuestDB is running
• Learn more is a selection of useful concepts and guides for new QuestDB users

Develop

This section describes how to connect to QuestDB using a variety of tools and programming languages through our various network endpoints.

• Connect to the database through our various endpoints. Learn which protocol is best for different use cases

• Insert data using the InfluxDB Line Protocol, PostgreSQL wire protocol or our HTTP REST API

• Query data with SQL queries via the PostgreSQL Wire Protocol or exported to JSON or CSV via our HTTP REST API

• Web Console for quick SQL queries, charting and CSV upload/export functionality

Guides

• Migrating from InfluxDB
• Large CSV import (COPY SQL)
• Small CSV import (REST API)
• Modifying Data
• Timestamps and time zones

Deployment

• Capacity planning for configuring server settings and system resources
• AWS Marketplace AMI
• Kubernetes
• Google Cloud Platform
• DigitalOcean Droplet

Operations

This section contains resources for managing QuestDB instances and has dedicated pages for the following topics:

• Design for performance for configuring table settings to improve performance
• Data retention strategy to delete old data and save disk space
• Health monitoring endpoint for determining the status of the instance
• Backup and restore using filesystem and point-in-time backup functionality. Notes for cloud providers.

Third-party tools

This section describes how to integrate QuestDB with third-party tools and utilities for collecting metrics and visualizing data:

• Flink guide for ingesting data from Flink into QuestDB
• Grafana instructions for connecting QuestDB as a datasource for building visualizations and dashboards
• MindsDB tutorial for connecting QuestDB to MindsDB for running models with Machine Learning capabilities.
• Kafka guide for ingesting data from Kafka topics into QuestDB
• Pandas for ingesting Pandas dataframes via ILP
• Prometheus monitoring and alerting
• Redpanda instructions for a Kafka compatible data streaming tool
• Spark for large-scale data engineering
• Superset instructions for using Apache Superset data visualization
• Telegraf guide for collecting system metrics, specifying QuestDB as an output and visualizing the results

Concepts

This section describes the architecture of QuestDB, how it stores and queries data, and introduces features and capabilities unique to the system.

• Storage model describes how QuestDB stores records and partitions within tables
• Designated timestamp is a core feature that enables time-oriented language capabilities and partitioning
• SQL extensions allow performant time series analysis with a concise syntax
• JIT compiler to speed up WHERE clauses
• Partitions can be used to perform time-based queries more efficiently
• Symbol type makes storing and retrieving repetitive strings efficient
• Indexes can be used for faster read access on specific columns
• Geospatial data with geohashes
• Root directory describes the directory contents of QuestDB for storage and configuration

Reference

This section contains the reference documentation for the following categories:

APIs

• REST
• Postgres
• InfluxDB
• Java (embedded)

Command-line options

The following resource provides info on options that may be passed to QuestDB when starting services:

• Command-line options for starting and running QuestDB from an executable

Configuration

The configuration page shows all the properties that can be used to customize QuestDB.

ILP Client Libraries

• Client Libraries overview
• Java ILP client

Data Types

The data types page lists the datatypes that can be used in QuestDB.

Functions

• Aggregate
• Analytic
• Binary
• Boolean
• Conditional
• Date and time
• Meta
• Numeric
• Random value generator
• Row generator
• Spatial
• Text
• Timestamp generator
• Timestamp
• Trigonometric

Operators

• Bitwise
• Pattern matching
• Spatial

SQL

• SQL Execution order
• Data types
• ALTER TABLE ADD COLUMN
• ALTER TABLE RENAME COLUMN
• ALTER TABLE DROP COLUMN
• ALTER TABLE ATTACH PARTITION
• ALTER TABLE DETACH PARTITION
• ALTER TABLE DROP PARTITION
• ALTER TABLE SET PARAM
• ALTER TABLE ALTER COLUMN ADD INDEX
• ALTER TABLE ALTER COLUMN DROP INDEX
• ALTER TABLE ALTER COLUMN CACHE | NOCACHE
• ALTER TABLE SET TYPE
• ALTER TABLE RESUME WAL
• BACKUP
• CASE
• CAST
• COPY
• CREATE TABLE
• DISTINCT
• EXPLAIN
• FILL
• DROP TABLE
• GROUP BY
• INSERT
• JOIN
• LATEST ON
• LIMIT
• ORDER BY
• REINDEX
• RENAME TABLE
• SAMPLE BY
• SELECT
• SHOW
• SNAPSHOT
• TRUNCATE TABLE
• UNION EXCEPT INTERSECT
• VACUUM TABLE
• WHERE
• WITH

Support

For hints on diagnosing common configuration issues, see the following resources:

• Troubleshooting FAQ guide with solutions for various HW & SW configuration issues
• Log guide for log location and details
• List of OS error codes page with the list of Operating System error codes

We are happy to help with any question you may have, particularly to help you optimize the performance of your application. Feel free to reach out using the following channels:

• Raise an issue on GitHub
• Join the Community Slack
• QuestDB on Stack Overflow
• or email us at hello@questdb.io