Skip to main content
TrustRadius
QuestDB

QuestDB

Overview

What is QuestDB?

QuestDB is an open source time series database. It implements SQL and exposes a Postgres wire protocol, a REST API, and supports ingestion with InfluxDB line protocol.

Read more

Learn from top reviewers

Fastest open source TSDB on market - serious competitor for kdb+

Rating: 10 out of 10
May 31, 2021
Vetted ReviewVerified User
Ticker plant for market data.
Continue reading
Verified user
Team Lead
QuestDB1 year of experience
Log in with LinkedIn to see content from your network
Return to navigation

Product Demos

Open-Source Spotlight - QuestDB - Javier Ramirez

YouTube

1. #everyonecancontribute cafe: QuestDB

YouTube

Time-series Database for Developers: QuestDB

YouTube

QuestDB

YouTube
Return to navigation

Product Details

What is QuestDB?

QuestDB is an open source time series database. It implements SQL and exposes a Postgres wire protocol, a REST API, and supports ingestion with InfluxDB line protocol.

QuestDB Features

  • Supported: High Performance
  • Supported: SQL
  • Supported: InfluxDB Line Protocol

QuestDB Screenshots

Screenshot of Fast SQL for time seriesScreenshot of Console to query and visualize dataF

QuestDB Integrations

  • Grafana
  • InfluxDB Line Protocol
  • PostgreSQL wire

QuestDB Competitors

QuestDB Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, Mac
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

High Performance: Many users have praised QuestDB's high performance, with some stating that it can ingest large amounts of data and query in sub-100 ms time. Reviewers were stunned by the performance and simplicity of QuestDB, finding it to be a great solution for storing and querying enormous volumes of data very quickly. They appreciated that QuestDB has the ability to handle millions of data points almost instantly, which is not the case with other databases that take more time to handle such volumes of data.

Ease of Use: Several reviewers found QuestDB to be easy to use due to its SQL-like query language. Some appreciated that it supports a lot of Postgres features, eliminating the need to learn a new query language. Others liked how its browser-based UI makes installing and running QuestDB on commodity hardware completely hassle-free. Users also noted that QuestDB's support for InfluxDB Line Protocol makes streaming and batch ingestion of data easy.

Open Source: A number of users appreciate that QuestDB is open source, lightweight but powerful time-series database software. They appreciated incredible modules available with questdb which they could use for their projects.

Lack of Replication: Several users have expressed concerns over the lack of replication feature in QuestDB, with some stating that it limits their options for Kubernetes deployment. While they understand that the feature might be in development, they would like to see more features like replication and running in multiple regions.

SQL Syntax: Some users have pointed out that the SQL syntax is rough around the edges, particularly with functions being case sensitive. Although they acknowledge that QuestDB team is working on improving it, this has caused some inconvenience to users.

Visualization Capability: Although users haven't come across anything they really dislike about QuestDB, a common request has been for improved visualization capability in the browser console. Some users have experienced runaway log files as well.

View all reviews
(1-1 of 1)

Fastest open source TSDB on market - serious competitor for kdb+

Rating: 10 out of 10
May 31, 2021
Verified User
Team Lead in Information Technology
Financial Services Company, 11-50 employees
Vetted Review
Verified User
QuestDB
1 year of experience
Use Cases and Deployment Scope
Ticker plant for market data.
Pros
  • Extreme performance.
  • Super easy to use.
  • Compatibility with Influx line protocol.
  • PostgreSQL compatibility.
  • Out of order timestamps.
  • Support for multiple records with same timestamp.
  • Integration with Grafana.
  • Team responsiveness.
Cons
  • New project so needs a bit polishing.
Likelihood to Recommend
QuestDB is well suited for any use case where you need to store large amount of data and the performance is the key factor - for both reads and writes. So use cases like market data storage in financial industry, any kind of telemetry, etc.
Most Important Features
  • Performance.
  • Ease of use.
  • Out of order timestamps.
  • Support for multiple records with same timestamp.
  • Grafana integration.
  • PostgreSQL API.
Return on Investment
  • Reduced cost.
  • Increased efficiency.
  • Faster time to market.
Alternatives Considered
We were looking for time series database that will be able to handle L2 market data and came across QuestDB. From the beginning we were impressed how well the QuestDB performs and that it actually significantly outperforms all other open source TSDB on market like InfluxDB, ClickHouse, Timescale, etc. Apart from the excellent performance it is also super easy to use and deploy which makes the experience of using the database very pleasant - we were able to be up and running and storing data within few hours. Topic itself is the QuestDB team that is super responsive on their slack channel and always ready to help with any query. They are constantly improving the product and if there is some missing feature that is blocking you from usage they always try the best to implement such feature asap and release a new version - one of the best support I have ever seen so far in open source community.
Return to navigation