# KDB-X DB Service Release Notes _This page documents the version history of the KDB-X [DB Service](../introduction.md), 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](../introduction.md#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)](../manage-tables-clustered.md): in a clustered deployment, tables are defined in the assembly YAML rather than through the table management API. Only [list](../manage-tables.md#list) and [describe](../manage-tables.md#describe) are available; create, drop, and the `createTable` import flag do not work. - [Query routing](../query.md#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](../storage-tiers.md), [initial import](../import-initial.md) for migrating an existing kdb+ HDB, [backup and restore](../backup-restore.md), and [troubleshooting](../troubleshooting.md). - Data deletion - [Delete rows](../delete-data.md) (beta): `POST /api/v0/deletes` submits a batch delete job for a table, matching an optional time range and [filter](../query.md#filtering). 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}`](../delete-data.md#check-delete-status), and a completed delete can be skipped on replay during a [restore](../delete-data.md#rollback). - Multi-assembly deployments - [Assembly selection](../configuration.md#assembly-selection): the `assembly` query parameter targets a specific assembly on a deployment configured with more than one. It applies to the [table management](../manage-tables.md#assembly-selection), [import](../import.md#assembly-selection), and [assembly export](../configuration.md#export-assembly) APIs, and is required when more than one assembly is configured. - Reference data and joins - [Reference data](../reference-data.md): 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](../manage-tables.md#drop) while another table references it with a foreign key. - [Reference columns](../query.md#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](../query.md#structured-query) `agg`, `groupBy`, and `filter`, and in [q query](../query.md#q-query) through [`.kxi.selectTable`](../query.md#kxiselecttable). - Custom code - [Custom code and UDFs](../custom-code.md): 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//`, with parameters as a JSON object in the request body. - Configuration APIs - [Export assembly](../configuration.md#export-assembly): returns an assembly configuration as a YAML document. - Query APIs - [Preview query](../query.md#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](../query.md#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`](../query.md#kxiselecttable). - [Streaming ingest](../import.md#example-data-feed): added guidance on running the sample data feed and verifying that data is being published. - [Keyed tables](../manage-tables.md#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) > **Note — 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](https://developer.kx.com/products/kdb-x/install). > **Release date:** 2026-04-28 This is the first public preview release of the single node KDB-X DB Service. ### New features - Data import APIs - [File import](../import.md#file-import): batch ingestion from delimited text (CSV), Parquet, or q binary. - [kdb database import](../import.md#kdb-database-import): ingests an existing kdb HDB. - [API data import](../import.md#api-data-import): inserts rows directly via API request. - Query APIs - [Structured query](../query.md#structured-query): parameterized API for querying timeseries. - [q query](../query.md#q-query): free-form q/qSQL, which can include an optional free-form aggregation function. - [SQL query](../query.md#sql-query): `SELECT`-only SQL interface. - Table management APIs - [List](../manage-tables.md#list): returns a simple list of table names in the database. - [Describe](../manage-tables.md#describe): returns schema and metadata. - [Create](../manage-tables.md#create): defines a table with a specified schema and settings. - [Drop](../manage-tables.md#drop): deletes a table and all associated data. ### Artifacts #### Database images | **Service** | **Downloads Portal location** | |---------------------------|---------------------------------------------| | Storage Manager | portal.dl.kx.com/kxi-sm-single:0.1.0-beta.1 | | Data Access Process (DAP) | portal.dl.kx.com/kxi-da-single:0.1.0-beta.1 | | Gateway | portal.dl.kx.com/kxi-sg-gw:0.1.0-beta.1 | | Resource Coordinator | portal.dl.kx.com/kxi-sg-rc:0.1.0-beta.1 | | Aggregator | portal.dl.kx.com/kxi-sg-agg:0.1.0-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 |