---
id: "kdb"
type: "component"
kind: "timeseries-database"
provider: "default"
category: "data"
docs: "https://code.kx.com/q/"
url: "https://localhost:3000/catalogue/components/kdb"
---

# kdb+

Column-oriented time-series database with the q language, partitioned on disk by date.

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

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `compression` | enum | `none`, `gorilla`, `other` | no | "other" | **"none"** |
| `downsampling` | boolean | — | no | false | **false** |
| `inMemoryTables` | boolean | — | no | true | inherited |
| `labelIndex` | boolean | — | no | true | **false** |
| `managed` | boolean | — | no | false | **false** |
| `partitionField` | enum | `date`, `month`, `year`, `int`, `none` | no | "date" | inherited |
| `retentionRawDays` | integer | — | no | — | inherited |
| `tiers` | enum | `single`, `hot-cold`, `hot-warm-cold` | no | "single" | **"single"** |

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
- [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
- [QuestDB](https://localhost:3000/catalogue/components/questdb.md) `questdb` — 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: "kdb", component: "kdb" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# kdb+ (KX): column-oriented time-series database with the q language. Per "Q for Mortals" and
# the kdb+ database reference, historical data is held in on-disk tables partitioned by date and
# compression is opt-in per column; there is no metrics-style label index.
schemaVersion: "1"
type: "component"
id: "kdb"
kind: "timeseries-database"
provider: "default"
docs: "https://code.kx.com/q/"
defaults:
  managed: false
  downsampling: false
  labelIndex: false
  compression: "none"
  tiers: "single"
properties:
  partitionField:
    type: "enum"
    values: ["date", "month", "year", "int", "none"]
    default: "date"
  inMemoryTables:
    type: "boolean"
    default: true
```

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