---
id: "questdb"
type: "component"
kind: "timeseries-database"
provider: "default"
category: "data"
docs: "https://questdb.com/docs/concepts/ttl/"
url: "https://localhost:3000/catalogue/components/questdb"
---

# QuestDB

SQL time-series database with a WAL write path and columnar reads.

| | |
|---|---|
| Provider | [default](https://localhost:3000/catalogue?provider=default) |
| Kind | [Time-series database](https://localhost:3000/catalogue/kinds/timeseries-database) |
| Category | Data |
| Official docs | [https://questdb.com/docs/concepts/ttl/](https://questdb.com/docs/concepts/ttl/) |

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `compression` | enum | `none`, `gorilla`, `other` | no | "other" | **"none"** |
| `downsampling` | boolean | — | no | false | **false** |
| `labelIndex` | boolean | — | no | true | **false** |
| `managed` | boolean | — | no | false | **false** |
| `partitionBy` | enum | `none`, `hour`, `day`, `week`, `month`, `year` | no | "day" | inherited |
| `partitionFormat` | enum | `native`, `parquet` | no | "native" | inherited |
| `retentionRawDays` | integer | — | no | — | inherited |
| `tiers` | enum | `single`, `hot-cold`, `hot-warm-cold` | no | "single" | **"single"** |
| `walEnabled` | boolean | — | no | true | inherited |

Bold values are the ones this component pins.

## Rules that apply · 0

No rule selects this kind or its category.

## Other products of the same kind · 23

- [Time Series Database](https://localhost:3000/catalogue/components/alibaba-tsdb.md) `alibaba-tsdb` — alibabacloud
- [Amazon FinSpace](https://localhost:3000/catalogue/components/aws-finspace.md) `aws-finspace` — aws
- [Amazon Timestream for InfluxDB](https://localhost:3000/catalogue/components/aws-timestream-influxdb.md) `aws-timestream-influxdb` — aws
- [Amazon Timestream for LiveAnalytics](https://localhost:3000/catalogue/components/aws-timestream-liveanalytics.md) `aws-timestream-liveanalytics` — aws
- [Azure Data Explorer](https://localhost:3000/catalogue/components/azure-data-explorer.md) `azure-data-explorer` — azure
- [Azure Monitor workspace](https://localhost:3000/catalogue/components/azure-monitor-workspace.md) `azure-monitor-workspace` — azure
- [Workers Analytics Engine](https://localhost:3000/catalogue/components/cloudflare-analytics-engine.md) `cloudflare-analytics-engine` — cloudflare
- [Cortex](https://localhost:3000/catalogue/components/cortex.md) `cortex` — default
- [DolphinDB](https://localhost:3000/catalogue/components/dolphindb.md) `dolphindb` — default
- [Graphite](https://localhost:3000/catalogue/components/graphite.md) `graphite` — default
- [InfluxDB](https://localhost:3000/catalogue/components/influxdb.md) `influxdb` — default
- [Apache IoTDB](https://localhost:3000/catalogue/components/iotdb.md) `iotdb` — default
- [kdb+](https://localhost:3000/catalogue/components/kdb.md) `kdb` — default
- [M3DB](https://localhost:3000/catalogue/components/m3db.md) `m3db` — default
- [Grafana Mimir](https://localhost:3000/catalogue/components/mimir.md) `mimir` — default
- [openGemini](https://localhost:3000/catalogue/components/opengemini.md) `opengemini` — default
- [Prometheus TSDB](https://localhost:3000/catalogue/components/prometheus-tsdb.md) `prometheus-tsdb` — default
- [TDengine](https://localhost:3000/catalogue/components/tdengine.md) `tdengine` — default
- [Thanos](https://localhost:3000/catalogue/components/thanos.md) `thanos` — default
- [TimescaleDB](https://localhost:3000/catalogue/components/timescaledb.md) `timescaledb` — default
- [Generic time-series database](https://localhost:3000/catalogue/components/timeseries-database.md) `timeseries-database` — default
- [VictoriaMetrics](https://localhost:3000/catalogue/components/victoriametrics.md) `victoriametrics` — default
- [Google Cloud Managed Service for Prometheus](https://localhost:3000/catalogue/components/google-managed-prometheus.md) `google-managed-prometheus` — gcp

## Use it in a design

```yaml
nodes:
  - { id: "questdb", component: "questdb" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# QuestDB: SQL time-series database with a WAL write path and columnar reads. Per "QuestDB
# Storage Engine" data is stored uncompressed in native column files, and per "Time To Live
# (TTL)" a table has no TTL by default, so rows are kept indefinitely.
schemaVersion: "1"
type: "component"
id: "questdb"
kind: "timeseries-database"
provider: "default"
docs: "https://questdb.com/docs/concepts/ttl/"
defaults:
  downsampling: false
  tiers: "single"
  labelIndex: false
  compression: "none"
  managed: false
properties:
  partitionBy:
    type: "enum"
    values: ["none", "hour", "day", "week", "month", "year"]
    default: "day"
  walEnabled:
    type: "boolean"
    default: true
  partitionFormat:
    type: "enum"
    values: ["native", "parquet"]
    default: "native"
```

Human page: https://localhost:3000/catalogue/components/questdb