Author Archives: Joe McMahon

Postgres array_to_string() and array_agg() to decouple your interface

Let’s say you’ve got a collection of job data for a set of users that looks like this, and you want to create a nice summary of it to be displayed, with a count of how many jobs are in … Continue reading

Posted in Postgres, Programming | Tagged , , , , | Leave a comment

Reducing Google access for Pokemon GO

Pokemon GO players on iOS: the new release today (7/12/16, in the App Store now) reduces the information it wants from your Google account from “full access” to your email and “know who you are on Google”. If you were … Continue reading

Posted in Uncategorized | Leave a comment

A quick note on Mac malware

The most recent bit of OS X malware making the rounds is a fake file converter program that installs a PHP backdoor accessible via Tor, allowing some rando to rummage around on your machine. As is usual, you, the victim, … Continue reading

Posted in Programming | Leave a comment

Squashing commits in the same branch

Okay, I’m sure this is documented lots of places, but I just now figured out that git rebase -i is perfectly happy to rebase from a commit on the same branch, so if you’ve got a branch that you’d like … Continue reading

Posted in Programming | Tagged | Leave a comment

Creating a submissions log with Airtable

Okay, so Twitter ads were useful for once. They pointed me to Airtable, which is a very slick site which is halfway between a spreadsheet and a database. You create tables, like you would in a database, but adding, updating, … Continue reading

Posted in Programming | Tagged , | Leave a comment

An open letter to my namesakes

Hi, all you other Joe McMahons out there. I’m sure you’re all great guys, a pleasure to know, upstanding in your community, and a blessing to your families. Kidding – I know at least one of you wanted to cheat on … Continue reading

Posted in Social | Leave a comment

“PG::UnableToSend: SSL error: sslv3 alert bad record mac”: not Postgres, not SSL

If you see this error in the build log for your Rails app (we were getting it during our Cucumber tests): PG::UnableToSend: SSL error: sslv3 alert bad record mac : …SQL query… then what you have is probably not an SSL … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Note on Vagrant UID conflicts

If you’ve restored from backup on OS X and are seeing this message when you issue vagrant up: The VirtualBox VM was created with a user that doesn’t match the current user running Vagrant. VirtualBox requires that the same user be … Continue reading

Posted in Programming | Leave a comment

Git: undoer of bad decisions

I’ve been working on a major Perl code refactor since March; this is a fairly critical subsystem that unifies two slightly different ways of doing the same thing under the One True Way. I’m finally starting to come out the … Continue reading

Posted in Programming | Tagged , | Leave a comment

Intro to Testing at SVPerl

As promised, here are the slides from my talk: Intro to Testing. This version of the talk covers a little more ground than the previous version, and gives you the preferred ways of dealing with leaking output and warnings, and includes … Continue reading

Posted in Programming | Tagged , | Leave a comment