Developer Tools

PYTHON

Introducing PyKX

The Python interface for KX Products. Currently available for kdb+, Insights, and Dashboards; PyKX enables you to:

Interface with existing kdb+ infrastructure using Python
Build databases and streaming applications
Query your data in Python, SQL and kdb+
Utilize visualization tools such as Plotly, Matplotlib and Seaborn

And it’s open source!

Download

PyPi

Anaconda

GitHub

import pykx as kx 
pdframe = pd.DataFrame(data = 
    {'a':[1, 2, 3], 'b': ['a', 'b', 'c']}) 
pykx_table = kx.toq(pdframe) 
pykx_table

import pykx as kx	  

# Count items of a list or dictionary  

kx.q.count([1,2,3])  

# Reverse order of items in a list or dictionary 

kx.q.reverse([1,2,3,4,5])  

# Mathematics functions  

kx.q.acos(0.5)	  

# Search Algorithms like Binary Search  

kx.q.bin([0, 2, 4, 6, 8, 10], 5)  

# Sorting  

kx.q.desc([4,2,5,1,0])  

# Correlation  

kx.q.cor([1, 2, 3], [2, 3, 4])

New to PyKX

We offer a wide range of training options, from self led to KX courses

Documentation

Explore our technical documentation for detailed guides, references and examples to unlock the full potential of PyKX.

Learn more

Releases

Keep up to date with the latest enhancements, new features, bug fixes and improvements.

Find out more

KX Academy

Learn how to generate, analyze, and query large datasets using PyKX, focusing on data structures, tables, and time series analysis.

Start learning

VISUAL STUDIO CODE

kdb VS Code extension

Enhance your development with the kdb+ VS Code extension, offering syntax highlighting, code snippets, and autocompletion for kdb+ queries. It provides an extensive set of features for creating and editing q files, connecting to multiple kdb processes, and executing queries, and is also compatible with kdb Insights Enterprise.

Download

GitHub

Marketplace

Start building with the kdb VS Code extension

Can’t wait to get started? Here are some helpful resources.

Documentation

Explore the documentation to learn how to get started and to see examples of how to unlock the full potential of the extension.

Learn more

Releases

Keep up to date with the latest enhancements, new features, bug fixes and improvements.

Find out more

Download

Install the kdb+ VS Code extension for seamless integration, code assistance, and efficient management of kdb+ and Insights Enterprise queries and connections.

Get started

DASHBOARDS

Introducing KX Dashboards

Create dynamic and interactive visual analytics with KX Dashboards, designed to interpret complex data with ease. Build custom data visualizations, integrate seamlessly with kdb+ data sources, and gain actionable insights through user-friendly, real-time displays.

Download

Get Started

Start building with KX Dashboards

Can’t wait to get started? Here are some helpful resources.

Documentation

Explore our technical documentation for detailed guides, references and examples to unlock the full potential of KX Dashboards.

Learn more

Releases

Keep up to date with the latest enhancements, new features, bug fixes and improvements.

Learn more

KX Academy

Learn how to create, query, and visualize data effectively. It’s ideal for beginners looking to enhance their skills in data visualization with kdb+ and comes with free hosted version of KX Dashboards for you to explore with.

Start learning

Introducing PyKX

Download

New to PyKX

Documentation

Releases

KX Academy

Didn’t find what you’re looking for?

Subscribe to our newsletter

Follow us on social media