Fast insert or update statements with Django

TLDR: use update_or_create / get_or_create when the likelihood of updating existing instances is high. Use create with an IntegrityError catch when the odds of inserting new instances is higher.

My Front Row Seat to Pigeon Parenting

A couple months ago, a pair of pigeons landed on a tree I’d laid out on the balcony. They were acting a little strange, so I went outside to shoo them away. As they reluctantly flew away, I discovered they’d been sitting on two fresh new eggs. And that was the…

Setting up a Python and Postgres development environment using Vagrant

Encoding Video with .NET Core and Azure Media Services — Part 1

Part 1: Authenticating with Azure…

How does Dropbox Paper have such pretty text?

I’ve been hearing good things about Dropbox Paper for a while now, but it wasn’t until a couple of days ago that I finally got around to trying it.

Wow, what a beautiful tool.

Encoding Video with .NET Core and Azure Media Services — Part 2

Part 2: Uploading Videos to Azure…

Encoding Video with .NET Core and Azure Media Services — Part 3

Part 3: Running an Azure Media…

Sloquet Hot Springs

6 hours north of Vancouver, BC

Suboptimal Python

Why it doesn’t always make sense to think about performance