English | 简体中文 | العربية

QuestDB

QuestDB is a high-performance, open-source SQL database for applications in
financial services, IoT, machine learning, DevOps and observability. It includes
endpoints for PostgreSQL wire protocol, high-throughput schema-agnostic
ingestion using InfluxDB Line Protocol, and a REST API for queries, bulk
imports, and exports.

QuestDB implements ANSI SQL with native extensions for time-oriented language
features. These extensions make it simple to correlate data from multiple
sources using relational and time series joins. QuestDB achieves high
performance from a column-oriented storage model, massively-parallelized vector
execution, SIMD instructions, and various low-latency techniques. The entire
codebase was built from the ground up in Java and C++, with no dependencies, and
is 100% free from garbage collection.

Try QuestDB

We provide a live demo provisioned with the latest
QuestDB release and a 1.6 billion row dataset with 10 years of NYC taxi trips to
query.

To run QuestDB, Docker can be used to get started quickly:

docker run -p 9000:9000 -p 9009:9009 -p 8812:8812 questdb/questdb

macOS users can use Homebrew:

brew install questdb
brew services start questdb

The QuestDB downloads page provides direct
downloads for binaries and has details for other installation and deployment
methods.

Connecting to QuestDB

You can interact with QuestDB using the following interfaces:

• Web Console listening on
  port 9000
• REST API on port 9000
• PostgreSQL wire protocol on
  port 8812
• InfluxDB line protocol for
  high-throughput ingestion on port 9009

How QuestDB compares to other open source TSDBs

Here are high-cardinality
Time Series Benchmark Suite
results using the cpu-only use case with 6 workers on an AMD Ryzen 3970X:

The following table shows query execution time of a billion rows run on a
c5.metal instance using 16 of the 96 threads available:

Documentation & resources

• The QuestDB documentation describes
  how to run and configure QuestDB with technical references.
• Our Slack workspace is a great place for technical
  discussions and to meet other users. :wave:
• GitHub discussions is where
  our users share ideas for features, ask questions, and show what they've
  built.
• GitHub issues are for bug
  reports.
• Our project roadmap contains
  our backlog and a list of tasks for upcoming releases.
• Tutorials written by our community members
  show what's possible with QuestDB.
• QuestDB on Stack Overflow
  has common troubleshooting solutions.

Deployment

• An AWS AMI is provided via
  the AWS marketplace.
• The Docker deployment guide
  shows how to start using the official Docker image.
• DigitalOcean droplets can be
  launched as 1-Click applications on the DigitalOcean marketplace.
• Basic Kubernetes documentation
  describes how to get started using the official Helm chart.

Contribute

We are always happy to have contributions to the project whether it is source
code, documentation, bug reports, feature requests or feedback. To get started
with contributing:

• Have a look through GitHub issues labeled
  "Good first issue".
• Read the
  contribution guide.
• For details on building QuestDB, see the
  build instructions.
• Create a fork
  of QuestDB and submit a pull request with your proposed changes.

As a sign of our gratitude, we'll send contributors some of our QuestDB swag
such as stickers and t-shirts! :star2:

A big thanks goes to the following wonderful people who have contributed to
QuestDB: (emoji key):

This project follows the
all-contributors
specification. Contributions of any kind welcome!