AquaQuarantine kdb+ Tech Talk Content

Jonny Press datablog, kdb+, TorQ Leave a Comment

The videos and slide decks from the AquaQuarantine kdb+ Tech Talks are below. kdb+ Security TorQ Overview Gateway Design Principles Grafana kdb+ 4.0 kdb+ in Containers MemVerge and kdb+ Optane TorQ Tickerplant kdb+ Security kdb+ can be configured to conform to current security standards. Jonny Press will talk about what these are and how it can be done including authentication, …

Jonny PressAquaQuarantine kdb+ Tech Talk Content

AquaQuarantine kdb+ Tech Talks Round 2

Jonny Press datablog, kdb, kdb+, TorQ, training Leave a Comment

We gave some talks a few months ago which seem to have gone down well. We’ve decided to go again with a short series of 3, including a guest talk from Nick Psaris on his new book Fun Q. If you’d like to sign up for any of these sessions, please use the form below. If you have trouble accessing …

Jonny PressAquaQuarantine kdb+ Tech Talks Round 2

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

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

kdb+ IoT Database Structure

Jonny Press data capture, datablog, kdb+ Leave a Comment

When implementing a kdb+ database the partitioning structure is a key decision point. kdb+ provides four in-built ways to partition database tables: by year, month, date or integer. Only one partitioning scheme may be used. The best option is usually based on two factors: how data arrives how it is accessed The partitioning scheme should facilitate easy addition of data …

Jonny Presskdb+ IoT Database Structure

As You Bike It: Mapping Belfast Bike Usage

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

We recently noted the ability to use our TorQ package to collect data on our local Belfast Bikes transport network. So how does our cycle network look after collecting for a while? We recorded data on the status of each station in the network for 6 months, and we can now use this data to observe how the population of …

Ryan McCarronAs You Bike It: Mapping Belfast Bike Usage