Reasoning about “complicated” Postgres SQL queries

TL;DR When building non-trivial SQL queries, it helps to: State your objective in as "declarative" a way as possible Work from the "inside out". When using subqueries in SQL it helps to find the innermost nested subquery and work your way outwards to figure out what is going on. Similarly, I find that when building … Continue reading Reasoning about “complicated” Postgres SQL queries

Lessons Learned: Building statically-linked Rust binaries (OpenSSL)

In a couple of modules which used in CyberSift, Rust is slowly making an appearance, depending on the use-case at hand. Generally we develop in GoLang, and one of the advantages was the resulting binary, which pretty much ran anywhere as long as the right architecture and OS are used. We could develop on Ubuntu, … Continue reading Lessons Learned: Building statically-linked Rust binaries (OpenSSL)