It turns out it's quite straightforward to construct an "almost unique" constraint in PostgreSQL via EXCLUDE.

I was recently stuck in a jam in our PostgreSQL database during a feature migration. We needed a "partial UNIQUE" constraint and I was surprised to find out that PostgreSQL doesn't support them^{1 …}

This post was included in Golang Weekly issue 499. This is cross-posted from the Hardfin engineering blog.

The Go standard library uses a single overloaded type as a stand-in for both full datetimes¹ and dates. This mostly "just works", but slowly starts to degrade correctness in codebases where both …

Below, we'll show two facts which help understand the positive integer solutions to the following diophantine equation:

We'll show that there is a lone positive root and …

This is cross-posted from the Hardfin engineering blog.

As a small and growing team, we need to focus our operational efforts as much as possible. Using Tailscale as our VPN is very much aligned with this need. It's simple, with no central control plane to manage or other significant operational …

This post was included in Golang Weekly issue 414. This is cross-posted from the Hardfin engineering blog.

As programming language ecosystems evolve, they learn from each other. When this happens we all benefit from more useful features, patterns, libraries, and tools. A core part of a programming language ecosystem — packaging …