Just a Coder, Carryin' On Cranky

Fast GeoIP Queries in MySQL


Many moons ago, I tried to use the GeoIP database, via MySQL – and discovered that MySQL was doing the wrong thing with the queries. Naturally, I found some tricks to make it faster.

The AAIA ACES Datasets


Recently, I've been introduced to the AAIA's 'ACES' datasets. These datasets aim to describe the make, model, and configuration of pretty much every vehicle in recent history.

These datasets are a terrifying case study in how not to design datasets.

Kill it With Fire Friday


I previously wrote about an idea I had for managing technical debt in the face of continuous and inevitable business pressures. I want to take a moment to follow up with some of the comments I've received on the technique, how it evolved, and where it proved strong/weak.

Cloudability Looking for Senior Data Developer


“As Data Engineer, you’ll design and architect the pipeline for data ingested from multiple sources. We are looking for creative, results-driven developer who is excited about big, fast and flexible data.”

Know What You're Actually Testing


Getting At Awkward Code, For Great Testing

A couple days ago, I wound up helping out a colleague on a problem he was having coming up with an appropriate test case for a piece of code in a Rails app. It reminded me that I had wanted to talk about how structuring your code affects what you are actually testing, and how that related to what you want to test.