Tonight was the second time in a week I’ve wanted to calculate something semi-complicated in SQLite for my dissertation, only to discover that I’d already done the work months ago for something else. The perl code I found tonight was written back in August and contained this amusing comment:

1
2

# I'm sure I could do this with a single SQL query, but I don't know
# how.  So instead I'm going to brute-force it with some perl.

That was exactly the conclusion I’d reached tonight before I found this code. Instead, all I had to do was a simple select on the precomputed results. Thanks, past me!