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, …
AquaQuarantine kdb+ Tech Talks Round 2
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 …
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 …
kdb+ 3.6: anymap
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 …
kdb+ IoT Database Structure
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 …
As You Bike It: Mapping Belfast Bike Usage
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 …