An Introduction to qsql

George Saunders kdb+ Leave a Comment

This blog post gives users with a basic knowledge of SQL a brief introduction to querying q/kdb databases, with a focus on filtering data. If you are experimenting on an on-disk database, please read all the way to the bottom before starting as there are some important points about accessing partitioned data structures! q has its own syntax for querying …

George SaundersAn Introduction to qsql

Thank you for joining us at AquaQ’s Summer Event 2019

Rachel Marrinan Uncategorized 1 Comment

Last week we held our Summer Party at The Pearson Room in London, which was a great opportunity to enjoy an abundance of charcuterie boards whilst vying for the coveted title Summer Party Pub Quiz Champions! With a fantastic turnout, our teams locked horns over a range of hotly contested rounds, with “The Hoggets” being crowned victors*. Our new AquaQ …

Rachel MarrinanThank you for joining us at AquaQ’s Summer Event 2019

Kafka with kdb+ and Java

Paul Doherty kdb, kdb+ 3 Comments

Kafka is a distributed messaging service used to achieve a low-latency, high-throughput transfer of data using persistent logs to prevent loss of data. This blog will: Illustrate the various components used in Kafka. Show how Kafka can be used to share data between different technologies, for example, a Java producer and a kdb+ consumer. Highlight a use case for Kafka …

Paul DohertyKafka with kdb+ and Java

AquaQ London Summer Party 2019

Rachel Marrinan News Leave a Comment

It’s time for AquaQ’s annual London Summer Party… So save the date: Thursday 13th June! AquaQ are excited to be hosting a Pub Quiz at The Pearson Room, Canary Wharf. The evening will begin at 6pm with some welcome drinks, followed by a few words from our CEO, Ronan Pairceir, and of course, the Pub Quiz! Food and drinks will …

Rachel MarrinanAquaQ London Summer Party 2019

Grafana kdb+ Adaptor Update

Dylan Creighton kdb, kdb+ 1 Comment

One of the most requested features to our kdb+ Grafana adaptor was the ability to create panels from the results of server side functions. This most recent update to the adaptor continues to build on the SimpleJSON datasource created by Grafana by working around the limitation of the single drop down menu for queries, whilst also allowing parameters to be supplied. The adaptor is also integrated into TorQ …

Dylan CreightonGrafana kdb+ Adaptor Update

TorQ Release v3.4

Joseph Griffiths kdb+, TorQ Leave a Comment

We are delighted to announce release v3.4 of TorQ, the latest instalment of our kdb+ framework; which can be found here. The main changes are outlined below. Grafana Adaptor Integration As part of this update we have included AquaQ’s recent release, the Grafana-KDB adaptor. With this inclusion, the adaptor script is loaded in to all TorQ processes, allowing connection via a Grafana session. Full installation & usage can be found in the original blog and TorQ documentation. …

Joseph GriffithsTorQ Release v3.4

Grafana – kdb+ adaptor

AquaQ Admin kdb, kdb+ 3 Comments

AquaQ Analytics are often involved in projects using different visualisation tools connected to kdb+.  We have recently spent some time reviewing and then implementing a simple Grafana-kdb+ adaptor. This open-source script has been developed using the inbuilt Grafana SimpleJSON datasource and comes with the capability of table and time series visualisation and manipulation. Instructions for installation and usage can be …

AquaQ AdminGrafana – kdb+ adaptor

kdb+ 3.6: anymap

Jonny Press datablog, kdb+ 3 Comments

The recent release of kdb+3.6 brought a new data structure: anymap. As database nerds, this is very exciting news for us. We thought we’d have a play with it to see how it could be used. New Nested Lists The anymap features replaces all the previous structures used to create nested lists. It also supports storing non-uniform values within the …

Jonny Presskdb+ 3.6: anymap