Week 1Oh my goodness, I am loving this. My bosses just video called me and they totally bought my “I am taking working from home very seriously”-attitude. What they didn’t know is that I am currently businessperson from the waist up, pyjama party from the waist down. Week 2Yep, still doing great. Third Skype call with friends this week and …
Belfast Bikes Traffic Shifts to a Different Gear
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. …
AquaQuarantine kdb+ Tech Talks
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 …
AquaQ Grafana kdb+ Adapter
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 …
Monitoring a TorQ System With Datadog
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.
Scaling kdb+ with TorQ and Google Cloud
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 …
AquaQ Analytics London Meetup – 7th November 2019
AquaQ Analytics is hosting its first ever London tech Meetup tomorrow night (Thursday 7th November)! Join us at CodeNode at 6pm for drinks and pizza followed by some talks from the following speakers: “Bigger Data” David Demner, kdb+ Developer, will be presenting some strategies that he’s implemented on a single very large data set to make it more manageable. “Scaling and …
AI NI Datathon
On Saturday 26th and Sunday 27th October, AquaQ Analytics were Platinum Sponsors for the AI NI Datathon. With the event being held across two sites in Magee and QUB, it was a fantastic opportunity to engage closely with some of the top programming talent in Northern Ireland! The teams were tasked to complete one of the five challenges set by …
Sequel to qsql
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 …
AquaQ Analytics NY Event [10.17.2019]
AquaQ is pleased to announce this years New York event will involve a kdb+ Architecture Workshop and an evening drinks reception: EVENT DATE : Thursday 17th October 2019 EVENT VENUE: W Hotel New York – Downtown Event Schedule : Architecture Workshop Start Time : 3.00PMThe workshop will cover all aspects of kdb+ market data capture system design, including: – the …