Belfast Bikes Traffic Shifts to a Different Gear

Matthew Kingston datablog, kdb+, TorQ Leave a Comment

The Belfast Bikes public bicycle rental scheme, currently sponsored by Just Eat, has been running since April 2015. It has 47 stations and, according to the operator nextbike, “over 300 bikes”. However we only ever saw evidence of 221 bikes in operation. A previous blog post on this looked at leveraging TorQ for data collection from the Belfast Bikes network. …

Matthew KingstonBelfast Bikes Traffic Shifts to a Different Gear

AquaQuarantine kdb+ Tech Talks

Jonny Press datablog, kdb, kdb+, TorQ, training 5 Comments

These are some strange times. We hope everyone and their families are safe and well. On a positive note, it does provide a good opportunity to run some technical training sessions, which we’ve been doing internally for the last few weeks. We’ve decided to open these up publicly as everyone else is in the same “working from home” boat. We’ll …

Jonny PressAquaQuarantine kdb+ Tech Talks

AquaQ Grafana kdb+ Adapter

Jamie Grant kdb+ Leave a Comment

Launched in 2014, Grafana is an increasingly popular open source data visualisation and monitoring tool.  It allows users to display near real time through a wide array of charts, graphs and alerts from several data sources and has been designed to let users easily expand its capabilities through its plugin framework. In late 2018 AquaQ added kdb+ to the list …

Jamie GrantAquaQ Grafana kdb+ Adapter

Monitoring a TorQ System With Datadog

Ellen Mooney Datadog, kdb, kdb+, TorQ Leave a Comment

Datadog is a monitoring service for cloud-scale applications, providing monitoring of servers, databases, tools, and services, through a SaaS-based data analytics platform. This post illustrates how we can create a dashboard, monitors and alerts to track metrics and events from a TorQ Data Capture System.

Ellen MooneyMonitoring a TorQ System With Datadog

Scaling kdb+ with TorQ and Google Cloud

Glen Smith kdb, kdb+, TorQ Leave a Comment

Instead of having a static infrastructure that is unresponsive to your changing usage, Google’s cloud platform enables the infrastructure to dynamically scale along with your usage. This means you only pay for what you are using, when you are using it. We’ll create a simple proof of concept demonstrating this scaling behaviour when used with kdb+. This will utilize some …

Glen SmithScaling kdb+ with TorQ and Google Cloud

Sequel to qsql

David Martin kdb+ Leave a Comment

This post is a continuation of the earlier blog post titled “An Introduction to qsql”, found here, which would be helpful to read before continuing further into this topic. This part will deal with the use of delete and update. There will be a part on aggregations and it will end with a look at both by and fby. Let’s …

David MartinSequel to qsql

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 Life At AquaQ, 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

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