MrJoy

Just a Coder, Carryin' On Cranky

Fast GeoIP Queries in MySQL

Permalink

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

Permalink

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

Permalink

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

Permalink

“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

Permalink

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.