KDB-X DB Service Release Notes¶

This page documents the version history of the KDB-X DB Service, including released versions, fixes, and improvements.

0.1.1 (Preview 1.1)¶

Release date: 2026-09-04

This release adds clustered deployment, data deletion, support for deployments with more than one assembly, reference data and joins, custom code and user-defined functions (UDFs), configuration export, and a lightweight preview query.

New features¶

Clustered deployment
- The DB Service now supports two deployment options: single-node on Docker Compose, and clustered on Kubernetes with optional data sharding. Both use the same service images and APIs.
- Manage tables (clustered): in a clustered deployment, tables are defined in the assembly YAML rather than through the table management API. Only list and describe are available; create, drop, and the createTable import flag do not work.
- Query routing: the scope parameter targets a single assembly by name, and labels targets every assembly matching the given labels. Both are supported by the structured, q, and preview query APIs; SQL query supports scope only.
- New pages for storage tiers, initial import for migrating an existing kdb+ HDB, backup and restore, and troubleshooting.
Data deletion
- Delete rows (beta): POST /api/v0/deletes submits a batch delete job for a table, matching an optional time range and filter. Deletion covers the RDB, IDB, and HDB, is permanent, and is rejected if the time window overlaps an object storage tier. Job progress is available from GET /api/v0/deletes/{jobId}, and a completed delete can be skipped on replay during a restore.
Multi-assembly deployments
- Assembly selection: the assembly query parameter targets a specific assembly on a deployment configured with more than one. It applies to the table management, import, and assembly export APIs, and is required when more than one assembly is configured.
Reference data and joins
- Reference data: define a keyed reference table, link it to a timeseries table with the foreign column property, and query across the foreign key. A table cannot be dropped while another table references it with a foreign key.
- Reference columns: a query reads columns of a referenced table by naming them in table.column form, and the service resolves the foreign key and joins the reference data. Supported in structured query agg, groupBy, and filter, and in q query through .kxi.selectTable.
Custom code
- Custom code and UDFs: load custom q code into the da and agg processes with the KXI_CUSTOM_FILE environment variable. A registered UDF is served over REST at /api/v0/<namespace>/<name>, with parameters as a JSON object in the request body.
Configuration APIs
- Export assembly: returns an assembly configuration as a YAML document.
Query APIs
- Preview query: retrieves a small sample of table data with minimal time and resource usage, for inspecting data or checking schema compatibility.

Documentation improvements¶

q query: clarified that the gateway runs the query on every DB tier and combines the per-tier results, and expanded the guidance on when and why to use .kxi.selectTable.
Streaming ingest: added guidance on running the sample data feed and verifying that data is being published.
Keyed tables: documented that primaryKeys columns must be listed first in columns, and in the same order, or file imports into the table fail.

Artifacts¶

Database images¶

Service	Downloads Portal location
Storage Manager	portal.dl.kx.com/kxi-sm-single:0.1.1-beta.1
Data Access Process (DAP)	portal.dl.kx.com/kxi-da-single:0.1.1-beta.1
Gateway	portal.dl.kx.com/kxi-sg-gw:0.1.1-beta.1
Resource Coordinator	portal.dl.kx.com/kxi-sg-rc:0.1.1-beta.1
Aggregator	portal.dl.kx.com/kxi-sg-agg:0.1.1-beta.1

Reliable transport¶

Service	Downloads Portal location
Reliable Transport	portal.dl.kx.com/kxi-rt:1.18.0

Bundles & Clients¶

Repo	GitHub Repo Location
DB Service bundle	https://github.com/KxSystems/kdbx-db-service
q client	https://github.com/KxSystems/kdbx-db-service-q-client
Python client	https://github.com/KxSystems/kdbx-db-service-python-client

0.1.0 (Preview 1)¶

New Community Edition license

If you're using a Community Edition license from before May 2026, you'll need to generate a new one to use the DB Service. You can get a new automatically-generated license by visiting the KDB-X Install page.

Release date: 2026-04-28

This is the first public preview release of the single node KDB-X DB Service.