(Slightly) Advanced cache use cases to improve performance

Posted on by David Vassallo

In this article we will explore two related use cases, using caches to improve performance. The use cases are probably very familiar to engineers coming from a front-end background, but I rarely see documentation on the concepts used within a back-end context. The use cases are based off real world scenarios we've encountered in CyberSift. … Continue reading (Slightly) Advanced cache use cases to improve performance

Scaling INET queries in POSTGRESQL

Posted on by David Vassallo

A very common requirement in most SOCs is to compare a given IP address against a table to extract contextual information such as originating country, owning organization and so on. At CyberSift we had a similar challenge. Most geo providers will allow you to download data to a table in this format: CREATE TABLE "ip_loc" … Continue reading Scaling INET queries in POSTGRESQL