开源软件名称：

开源软件地址：

开源软件介绍：

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

QuestDB

QuestDB is a high-performance, open-source SQL database for applications infinancial services, IoT, machine learning, DevOps and observability. It includesendpoints for PostgreSQL wire protocol, high-throughput schema-agnosticingestion using InfluxDB Line Protocol, and a REST API for queries, bulkimports, and exports.

QuestDB implements ANSI SQL with native extensions for time-oriented languagefeatures. These extensions make it simple to correlate data from multiplesources using relational and time series joins. QuestDB achieves highperformance from a column-oriented storage model, massively-parallelized vectorexecution, SIMD instructions, and various low-latency techniques. The entirecodebase was built from the ground up in Java and C++, with no dependencies, andis 100% free from garbage collection.

Try QuestDB

We provide a live demo provisioned with the latestQuestDB release and a 1.6 billion row dataset with 10 years of NYC taxi trips toquery.

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 questdbbrew services start questdb

The QuestDB downloads page provides directdownloads for binaries and has details for other installation and deploymentmethods.

Connect to QuestDB

You can interact with QuestDB using the following interfaces:

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

How QuestDB compares to other open source TSDBs

Here are high-cardinalityTime Series Benchmark Suiteresults 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 ac5.metal instance using 16 of the 96 threads available:

Resources