BTrDB vs QuestDB
BTrDB
btrdb.readthedocs.io
QuestDB
questdb.comSide by side
| Figure | BTrDB | QuestDB |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | Yes |
| Open source | — | — |
| Web | — | Yes |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 2 |
| Spec score · Time-Series Databases | 8.8 (#3) | 8.1 (#14) |
| Data formats | StreamSets can be filtered and converted to formats including pandas DataFrames and CSV files. | QuestDB supports Parquet storage and PostgreSQL Wire Protocol compatibility with existing tools and drivers. |
| Integrations | The Python documentation includes examples using Dash and Plotly to plot data queried from BTrDB. | QuestDB lists Grafana, Power BI, Apache Kafka, Telegraf, Redpanda, Apache Flink, Pandas, and Apache Spark among its integrations. |
| Product | BTrDB is a time-partitioned, version-annotated clustered time-series database for high-density univariate data. | QuestDB is a time-series database for mission-critical environments where low latency matters. |
| Support | The documentation invites users to submit pull requests or open a GitHub issue for additions or corrections. | Enterprise includes dedicated access to QuestDB engineers and guaranteed response-time SLAs; Open Source has community support. |
Plans
In their own words
BTrDB
BTrDB is a free, MIT-licensed, self-hosted time-series database for dense, high-precision univariate data. It partitions data by time, supports clustered deployments, and records stream changes as new versions that queries can target. Streams have unique UUIDs and can be grouped into collections with tags and annotations. The Python btrdb package supports nanosecond-timestamp queries and insertion through Stream.insert, PyArrow tables, or pandas DataFrames. Statistical queries can return minimum, maximum, mean, count, and standard deviation without reading every underlying point. StreamSets can be filtered and converted to pandas DataFrames or CSV files. Documentation shows Dash and Plotly visualization, Ray-worker serialization, TLS on port 4411, and API-key authentication requiring that TLS port. Arrow-based tabular methods are documented for commercial customers with Arrow-enabled servers. BTrDB reports measured cluster throughput and compression figures, and describes smart-grid aggregation at city or country scale as one target use case.
QuestDB
QuestDB is a time-series database for environments where low latency matters, including mission-critical workloads. It supports standard SQL through a vectorized execution engine, along with time-series extensions such as SAMPLE BY, ASOF, and HORIZON JOIN. QuestDB advertises ingestion speeds of 8M+ rows per second. The Open Source edition is self-managed and available as binaries, containers, or source code; it is single-instance and supports Parquet storage and PostgreSQL Wire Protocol compatibility. Ingestion options include QuestDB Wire Protocol, InfluxDB Line Protocol, REST API, native client libraries, SQL INSERT, Kafka connector, and CSV import. Listed integrations include Grafana, Power BI, Apache Kafka, Telegraf, Redpanda, Apache Flink, Pandas, and Apache Spark. Open Source costs nothing and includes community support. Enterprise adds security controls, replication, automatic failover, object-storage tables, and dedicated support with response-time SLAs.