PostgreSQL to kdb+ Extension

3 Dec 2019 |
Share on:

by Hugh Hyndman

Former director of Industrial IoT Solutions at Kx, Hugh Hyndman, has clearly retained his interest in kdb+ since deciding to step down from full-time work within the company. In a recent GitHub post he outlined a PostgreSQL extension that allows a Postgres process to access kdb+ data via an SQL interface thereby enabling the two technologies to combine their respective strengths – Postgres’ excellent transactional support for reference/master data and the high-performance capabilities of kdb+ solution to storing and analyzing extreme volumes of time-series data.

As well as outlining some performance considerations, the blog summarizes data mappings between the two systems and discusses utilities and regression test scripts that can be used to accelerate the development of new solutions incorporating both technologies.

We would like to thank Hugh for his ongoing interest and support for Kx

Please click on this link to read the blog in full

SUGGESTED ARTICLES

Dovetailing Software – kdb+ and Spark

9 Jan 2020 |

Hugh Hyndman outlines how the storage capabilities of kdb+ and the distributed clustering capabilities of Apache Spark can be cleverly combined, using their shared columnar design, to achieve higher throughput and performance than via a row-based JDBC intermediary.