kdb+

What kdb+ is

kdb+ is a time-series database and analytics engine built around the q vector language, designed to capture and analyze real-time and historical data. KX says it handles real-time ingestion and analysis in memory with sub-millisecond performance for time-critical workloads. Its storage design separates the newest in-memory data in an RDB, recent disk data in an IDB, and long-term columnar archives in an HDB. Query options include q and q-SQL; listed language support also includes Python, Java, C#, C++, Rust, and R. Ingestion methods include tickerplants, feed handlers, batch mode, TCP/IP, Apache Kafka, and several programming languages. KX describes uses in trading, fraud detection, and IoT monitoring, serving Capital Markets, Defense, and High-Tech Manufacturing. Deployment options include Linux, macOS, Windows, APIs, and self-hosted use; KX documentation also covers AWS, Google Cloud Platform, and Microsoft Azure. SSL/TLS connections can be configured using OpenSSL certificates and keys. A free personal edition is limited to non-commercial local use on two computers, with up to 24 cores each, and requires always-on internet. Commercial use requires a KX license agreement and valid license key; pricing is on request.

Who it suits

kdb+ suits organizations working with time-series data in areas such as trading, fraud detection, or IoT monitoring. Its free personal edition is limited to non-commercial local use, while commercial users need a license agreement and key.

Limits

The free On Demand Personal Edition is non-commercial, limited to two computers and 24 cores per computer, local only, and requires an always-on internet connection. It cannot run in the cloud. Commercial use requires a license agreement and valid license key file.

Getting started

1. Visit the kdb+ product website.
2. Choose the On Demand Personal Edition for non-commercial use, or contact KX sales about commercial licensing.
3. For personal use, set up a local environment on no more than two computers, each with up to 24 cores.
4. Keep an always-on internet connection for the personal edition.
5. Select an available platform or deployment approach, including self-hosted or a documented cloud deployment.

Verdict

kdb+ combines time-series storage, analytics, and multiple ingestion paths for real-time and historical data. The free personal edition has strict use and connectivity limits; commercial use requires a license.