QuestDB

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

Provider: default
Kind: Time-series database
Category: Data
Official docs: https://questdb.com/docs/concepts/ttl/

Properties · 5 set by this component

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 · component property	enum	none \| hour \| day \| week \| month \| year	no	day	inherited
partitionFormat · component property	enum	native \| parquet	no	native	inherited
retentionRawDays	integer	—	no	—	inherited
tiers	enum	single \| hot-cold \| hot-warm-cold	no	single	▸ single
walEnabled · component property	boolean	—	no	true	inherited

Rules that apply · 0

Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.

No rule reads this kind yet. That is a gap, not a guarantee.

Use it in a design

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

Other Time-series database products · 23

Source

1# yaml-language-server: $schema=../../schema/component.schema.json
2# QuestDB: SQL time-series database with a WAL write path and columnar reads. Per "QuestDB
3# Storage Engine" data is stored uncompressed in native column files, and per "Time To Live
4# (TTL)" a table has no TTL by default, so rows are kept indefinitely.
5schemaVersion: "1"
6type: "component"
7id: "questdb"
8kind: "timeseries-database"
9provider: "default"
10docs: "https://questdb.com/docs/concepts/ttl/"
11defaults:
12  downsampling: false
13  tiers: "single"
14  labelIndex: false
15  compression: "none"
16  managed: false
17properties:
18  partitionBy:
19    type: "enum"
20    values: ["none", "hour", "day", "week", "month", "year"]
21    default: "day"
22  walEnabled:
23    type: "boolean"
24    default: true
25  partitionFormat:
26    type: "enum"
27    values: ["native", "parquet"]
28    default: "native"

The same page as markdown, for an agent: /catalogue/components/questdb.md