kdb+

What kdb+ is

kdb+ is a time-series database and analytics engine built around the q vector language. It is designed to capture, analyze, and support action on real-time and historical data. KX describes in-memory ingestion and analysis with sub-millisecond performance for time-critical workloads. Its storage design separates 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 programming languages. KX describes uses in trading, fraud detection, and IoT monitoring, and serves Capital Markets, Defense, and High-Tech Manufacturing. Deployments include Linux, macOS, Windows, APIs, and self-hosted environments; KX documentation also covers AWS, Google Cloud Platform, and Microsoft Azure. SSL/TLS connections can use OpenSSL certificates and keys. A free personal edition is limited to non-commercial local use on two computers, with up to 24 cores per computer, and requires an always-on internet connection. Commercial pricing is on request and requires a license agreement and valid key.