kdb+ Database Setup Utilities

Aidan O'Gorman data capture, datablog, kdb, kdb+, TorQ 1 Comment

This blog post describes tools to help setup a new kdb+ database. The tools allow you to: calculate the expected memory requirements of the database check columns have been typed correctly in order to avoid sym file bloat Background The volume of data that a kdb+ process can store in memory is finite and must be estimated and considered when designing …

Aidan O'Gormankdb+ Database Setup Utilities

kdb+ Online Training Updated- Architecture

Jonny Press data capture, kdb, kdb+, TorQ, training Leave a Comment

We recorded our recent kdb+ Architecture Workshop in London, and we’ve added the video and slide deck as a bonus module on our kdb+ Bootcamp Online Training Course.  Above is a snapshot – a three hour in-depth workshop in 15 seconds.  Topics covered include: the basics of data capture extending kdb+ tick and alternative strategies scaling throughput versus latency removing …

Jonny Presskdb+ Online Training Updated- Architecture

kdb+ Architecture Workshop

AquaQ Admin kdb, kdb+, News, TorQ, training Leave a Comment

Thanks to everyone who attended our kdb+ Architecture Workshop in Code Node, London.  We had a full house, and lots of great feedback.  If you would like to get more information on future events, or have any topic suggestions for future workshops, please get in touch.  

AquaQ Adminkdb+ Architecture Workshop

TorQ Release v3.0.0- LDAP and Permissions

Jonathon McMurray kdb, kdb+, TorQ 2 Comments

We are very excited to announce release v3.0.0 of TorQ, our kdb+ production framework! There are a number of exciting new features added in this release. For starters, we have updated our documentation to an easy to navigate new website: http://aquaqanalytics.github.io/TorQ/ – here you’ll find information about all the functionality of TorQ, without having to wade through a massive PDF …

Jonathon McMurrayTorQ Release v3.0.0- LDAP and Permissions

TorQ Permission Framework

Ryan McCarron datablog, kdb, kdb+, TorQ Leave a Comment

Our latest update to TorQ adds our new permissions system. Using this system any user connecting over IPC to a permissioned process can have selectively tiered access to any table or variable. This extends to limiting access to functions, through a fully customisable set of user privileges, while still allowing a super-user role with access to all functions, variables, and …

Ryan McCarronTorQ Permission Framework

AquaQ News Letter

AquaQ Admin kdb, kdb+, News Leave a Comment

The latest release of the AquaQ newsletter is now available.   The winner of the previous newsletter challenge, Gary Davies (right), is the proud owner of a new iPad Mini.  Congratulations Gary!!

AquaQ AdminAquaQ News Letter

Free of Charge kdb+ Architecture Workshop, London, Thursday 26th January 2017

AquaQ Admin kdb, kdb+, News 4 Comments

In November we ran a kdb+ Architecture Workshop in NYC which, apart from a bout of mild food poisoning for one of the presenters, went very well.  We will be running the workshop for our London friends between 2 and 5pm on Thursday 26th January 2017 in CodeNode.  The workshop will cover all aspects of kdb+ market data capture system …

AquaQ AdminFree of Charge kdb+ Architecture Workshop, London, Thursday 26th January 2017

Parallel kdb+ Database Access with QPad and TorQ

Allan Moore kdb, kdb+, TorQ Leave a Comment

We’ve been working with Oleg Zakharov, who created QPad, to implement asynchronous querying and allow users to run multiple concurrent queries more efficiently.  This blog explains how it works, using a new version which Oleg will make available soon (but can be downloaded from here for now). The Problem A common usage pattern in kdb+ environments is to have multiple …

Allan MooreParallel kdb+ Database Access with QPad and TorQ

Faster Recovery with kdb+ tick

Jonathon McMurray data capture, kdb, kdb+, TorQ Leave a Comment

The standard tickerplant (tick.q) from kdb+tick receives updates from feeds and pushes these updates to subscribing processes, as well as writing them to the log file. The tickerplant (TP) will count the number of messages received from the feed and written to the log file (in a variable .u.j) as well as the number of messages pushed to subscribers (in …

Jonathon McMurrayFaster Recovery with kdb+ tick

Learn kdb+ in X minutes

Matt Doherty kdb, kdb+, News, training Leave a Comment

  No programming language is an island. In modern data infrastructures many languages and tools peacefully co-exist, and so do the engineers who specialise in using these technologies. The q gods and Java masters must live alongside one another! When working on a large system it can be very useful – and sometimes necessary – to gain some knowledge outside …

Matt DohertyLearn kdb+ in X minutes