kdb+ Gateways

AquaQ Admin kdb, kdb+, TorQ 1 Comment

In a typical kdb+ system, there are several q processes running concurrently. These will commonly include services such as a Real-Time Database (RDB), which contains today’s or recent information in memory, or a Historical Database (HDB), which stores information from previous days. The client can have the ability to access these directly, but in some cases these services are hidden in …

AquaQ Adminkdb+ Gateways

An alternative ODBC client for kdb+

Jamie Grant kdb+ 1 Comment

As the adoption of kdb+ has expanded both within and outside of its traditional domain in finance, the options for interfacing kdb+ with other technologies have also grown. kdb+ has always had an excellent set of external interfaces out of the box – with a native C/C++ interface capable of creating and accessing low level data structures and extending the …

Jamie GrantAn alternative ODBC client for kdb+

kdb programming challenge – Minesweeper

AquaQ Admin kdb+ 2 Comments

Happy New Year everyone! I hope everyone had a very good holiday and wouldn’t it be great to start the new year with a big bang right?? It has been a while since the last challenge and I’m sure my fans are dreading for one 🙂 Ok, enough of messing around. Let’s get down to business! I’m sure everyone is …

AquaQ Adminkdb programming challenge – Minesweeper

Fast, Flexible, Low Memory end-of-day writes with TorQ 2.3

Chris McCracken data capture, kdb, kdb+, TorQ Leave a Comment

If you are given the option, is it to your advantage to switch on your initial choice? The Monty Hall problem: Suppose you’re on a game show, and you’re given the choice of three doors: Behind one door is a car; behind the others, goats. You pick a door, say No 1, and the host, who knows what’s behind the …

Chris McCrackenFast, Flexible, Low Memory end-of-day writes with TorQ 2.3

kdb+ Pharmaceutical Clinical Trial Costing and Forecasting

Jonny Press kdb, kdb+, TorQ 1 Comment

In a previous post we identified the reasons we chose kdb+ in the Internet Of Things application that we developed. This blog discusses which features we utilized in our Clinical Trail Costing Application, again built on our TorQ Framework, incorporating node.js and making kdb+ behave a bit like a document store.  If you would like a demonstration of the product …

Jonny Presskdb+ Pharmaceutical Clinical Trial Costing and Forecasting

GCHQ Christmas Card Puzzle

Jamie Grant kdb+ 1 Comment

Rikesh posted a link to the GCHQ Christmas Card Puzzle on the K4 listbox, so I decided to take a look. Described as a grid shading problem, it consists of a 25 X 25 grid, on which a number of cells are shaded black. The sequence of numbers against each row and column specifies the length of runs of unbroken …

Jamie GrantGCHQ Christmas Card Puzzle

Adventure in Retrieving Memory Size of kdb+ Object

AquaQ Admin kdb+ Leave a Comment

It has been quite a puzzle to figure out how much memory a kdb+ object uses within a q session, so we decided to write this utility script and add it to the latest release of our TorQ Framework. My first naïve impression was why not just use -22!, that should be a good estimate. Um no, -22! is only returning …

AquaQ AdminAdventure in Retrieving Memory Size of kdb+ Object

kdb+ Internet of Things and Pharmaceutical Applications

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

We at AquaQ Analytics have recently built two kdb+ applications which are outside its traditional finance domain.  One is an IoT application which monitors vehicle movements, the other is a cost forecasting and analysis tool for clinical trials in the pharmaceutical industry.  Both are built on our TorQ Framework.  We had to do some slightly novel things, moving away from the …

Jonny Presskdb+ Internet of Things and Pharmaceutical Applications

kdb programming challenge – Fibonacci Clock

AquaQ Admin kdb+ 4 Comments

We all know what the Fibonacci Sequence is. It is basically the summation of last 2 numbers of a series starting from 1 (i.e. 1 1 2 3 5 8 13 ….). It exists in nature and can be seen in a sunflower head or in a snail shell as shown above. It is also related to the famous golden …

AquaQ Adminkdb programming challenge – Fibonacci Clock

Avoiding End-of-Day Halts with TorQ

Jonny Press data capture, kdb, kdb+, TorQ 3 Comments

kdb+tick is great, but there’s a problem- when the RDB (real time database) writes to disk on its daily schedule, users cannot access that day’s data until the write out is complete.  There are various solutions to this issue including: using something similar to w.q to write out the data periodically intraday have a replicated system and staggering the save down, …

Jonny PressAvoiding End-of-Day Halts with TorQ