QuestDB

QuestDB is an open-source time-series database for high throughput ingestion and fast SQL queries with operational simplicity.

QuestDB is well-suited for financial market data, IoT sensor data and real-time dashboards. It shines for datasets with high cardinality and is a drop-in replacement for InfluxDB via support for the InfluxDB Line Protocol.

QuestDB implements ANSI SQL with native time-series SQL extensions. These SQL extensions make it simple to filter and downsample data, or correlate data from multiple sources using relational and time-series joins.

We achieve high performance by adopting a column-oriented storage model, parallelized vector execution, SIMD instructions, and low-latency techniques. The entire codebase is built from the ground up in Java, C++ and Rust with no dependencies and zero garbage collection.

QuestDB supports schema-agnostic streaming ingestion using the InfluxDB line protocol and a REST API for bulk imports and exports. The QuestDB SQL Web Console is an interactive SQL editor facilitating CSV import. Finally, QuestDB also includes the Postgres Wire Protocol for programmatic queries.

Popular tools that integrate with QuestDB include Apache Kafka, Grafana, Superset, Telegraf and Apache Flink.

Try QuestDB

Our live demo is provisioned with the latest QuestDB release and sample datasets:

Trips: 10 years of NYC taxi trips with 1.6 billion rows
Trades: live crypto market data with 30M+ rows per month
Pos: geolocations of 250k unique ships over time

Query	Execution time
`SELECT sum(double) FROM trips`	0.15 secs
`SELECT sum(double), avg(double) FROM trips`	0.5 secs
`SELECT avg(double) FROM trips WHERE time in '2019'`	0.02 secs
`SELECT time, avg(double) FROM trips WHERE time in '2019-01-01' SAMPLE BY 1h`	0.01 secs
`SELECT * FROM trades LATEST ON timestamp PARTITION BY symbol`	0.00025 secs

Our demo is running on c5.metal instance and using 24 cores out of 96.

Get started

Install QuestDB

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

questdb start // To start questdb
questdb stop  // To stop questdb

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

QuestDB Enterprise

QuestDB Enterprise (self-hosted or BYOC) allows your organization to run the database at scale, securely. Additional features include multi-primary ingestion, read replica(s), cold storage integration, Role-based access control, monitoring, TLS, and more.

Connect to QuestDB

You can interact with QuestDB using the following interfaces:

Web Console for an interactive SQL editor and CSV import on port 9000
InfluxDB line protocol for streaming ingestion on port 9000
PostgreSQL wire protocol for programmatic queries and transactional inserts on port 8812
REST API for CSV import and cURL on port 9000

Insert data

Below are the official QuestDB clients for ingesting data via the InfluxDB Line Protocol:

Configure QuestDB for production workloads

Find our capacity planning to fine-tune QuestDB for production workloads.

End-to-end quickstart

Want to walk through everything, from streaming ingestion to visualization with Grafana? Check out our multi-path quickstart repository.

How QuestDB compares to other open-source TSDBs

Checkout our benchmark blog post which compares QuestDB and InfluxDB across functionality, maturity and performance.

Resources

📚 Read the docs

QuestDB documentation: understand how to run and configure QuestDB.
Tutorials: learn what's possible with QuestDB step by step.
Product roadmap: check out our plan for upcoming releases.

📈 Demo dashboards

Live demo: explore a live instance of QuestDB with preloaded datasets.
Real-time crypto dashboard: Monitor executed trades on Coinbase from more than 20 assets in real time.
NYC taxi: A real-time replay of 146,393,317 taxi rides, carrying 238,016,495 passengers across New York City in 2016.

❓ Get support

Community Forum: join technical discussions, ask questions, and meet other users!
GitHub issues: report bugs or issues with QuestDB.
Stack Overflow: look for common troubleshooting solutions.

🚢 Deploy QuestDB

Contribute

We welcome contributions to the project, whether source code, documentation, bug reports, feature requests or feedback. To get started with contributing:

Have a look through GitHub issues labelled "Good first issue".
For Hacktoberfest, see the relevant labelled issues
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 also send QuestDB swag to our contributors. Claim your swag.

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

<table> <tbody> <tr> <td align="center" valign="top" width="14.28%"><a href="https://github.com/clickingbuttons"><img src="https://avatars1.githubusercontent.com/u/43246297?v=4" width="100px;" alt=""/> clickingbuttons</a> <a href="https://github.com/questdb/questdb/commits?author=clickingbuttons" title="Code">💻</a> <a href="#ideas-clickingbuttons" title="Ideas, Planning, & Feedback">🤔</a> <a href="#userTesting-clickingbuttons" title="User Testing">📓</a></td> <td align="center" valign="top" width="14.28%"><a href="https://github.com/ideoma"><img src="https://avatars0.githubusercontent.com/u/2159629?v=4" width="100px;" alt=""/> ideoma</a> <a href="https://github.com/questdb/questdb/commits?author=ideoma" title="Code">💻</a> <a href="#userTesting-ideoma" title="User Testing">📓</a> <a href="https://github.com/questdb/questdb/commits?author=ideoma" title="Tests">⚠️</a></td> <td align="center" valign="top" width="14.28%"><a href="https://github.com/tonytamwk"><img src="https://avatars2.githubusercontent.com/u/20872271?v=4" width="100px;" alt=""/> tonytamwk</a> <a href="https://github.com/questdb/questdb/commits?author=tonytamwk" title="Code">💻</a> <a href="#userTesting-tonytamwk" title="User Testing">📓</a></td> <td align="center" valign="top" width="14.28%"><a href="http://sirinath.com/"><img src="https://avatars2.githubusercontent.com/u/637415?v=4" width="100px;" alt=""/> sirinath</a> <a href="#ideas-sirinath" title="Ideas, Planning, & Feedback">🤔</a></td> <td align="center" valign="top" width="14.28%"><a href="https://www.linkedin.com/in/suhorukov"><img src="https://avatars1.githubusercontent.com/u/10332206?v=4" width="100px;" alt=""/> igor-suhorukov</a> <a href="https://github.com/questdb/questdb/commits?author=igor-suhorukov" title="Code">💻</a> <a href="#ideas-igor-suhorukov" title="Ideas, Planning, & Feedback">🤔</a></td> <td align="center" valign="top" width="14.28%"><a href="https://github.com/mick2004"><img src="https://avatars1.githubusercontent.com/u/2042132?v=4" width="100px;" alt=""/> mick2004</a> <a href="https://github.com/questdb/questdb/commits?author=mick2004" title="Code">💻</a> <a href="#platform-mick2004" title="Packaging/porting to new platform">📦</a></td> <td align="center" valign="top" width="14.28%"><a href="https://rawkode.com"><img src="https://avatars3.githubusercontent.com/u/145816?v=4" width="100px;" alt=""/> rawkode</a> <a href="https://github.com/questdb/questdb/commits?author=rawkode" title="Code">💻</a> <a href="#infra-rawkode" title="Infrastructure (Hosting, Build-Tools, etc)">🚇</a></td> </tr> <tr> <td align="center" valign="top" width="14.28%"><a href="https://solidnerd.dev"><img src="https://avatars0.githubusercontent.com/u/886383?v=4" width="100px;" alt=""/> solidnerd</a> <a href="https://github.com/questdb/questdb/commits?author=solidnerd" title="Code">💻</a> <a href="#infra-solidnerd" title="Infrastructure (Hosting, Build-Tools, etc)">🚇</a></td> <td align="center" valign="top" width="14.28%"><a href="http://solanav.github.io"><img src="https://avatars1.githubusercontent.com/u/32469597?v=4" width="100px;" alt=""/> solanav</a> <a href="https://github.com/questdb/questdb/commits?author=solanav" title="Code">💻</a> <a href="https://github.com/questdb/questdb/commits?author=solanav" title="Documentation">📖</a></td> <td align="center" valign="top" width="14.28%"><a href="https://shantanoo-desai.github.io"><img src="https://avatars1.githubusercontent.com/u/12070966?v=4" width="100px;" alt=""/> shantanoo-desai</a> <a href="#blog-shantanoo-desai"