The videos and slide decks from the AquaQuarantine kdb+ Tech Talks are below. 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, encryption and entitlements. Slide Deck TorQ TorQ is AquaQ’s kdb+ open source production framework. It is currently in use …
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 …
kdb+ Feedhandler Development
Setting up a kdb+ database is relatively straight forward. The TorQ Starter Pack is a good place to start. Two of the trickier bits are: Estimating how much memory your dataset will require Writing applications (generally called “feedhandlers”) to insert data into the database For (1) we’ve written previously on some database set up utilities used to estimate the size of a dataset …