Recent Posts

How to fix strange characters in MySQL

I admit, I borrowed this from How to fix strange characters in MySQL database – Vinh Pham. But I also added a few more that were missing.

Make iPhoto show pictures with unnamed faces

I've got about 11k photos, and lots of them have faces of things like wax figures, or people I don't know in the background. I don't really care about those "people", and so I need to remove them.

2013: In Review

2013 was a good year for me: we bought a new house and I got a promotion. 2013 was a good year for this blog as well: 12,000 total page views, 4,300 unique visitors, 5,200 visits, 21 posts, and two new authors (who'll begin posting in 2014).

Finding deleted files that are still opened by a process

Recently my server ran out of space, but my checks (via du) reported that only about 60GB was actually being used. That's because if a process has a file open that is then deleted, the space is still claimed, but the file doesn't appear.

Deleting local git branches with a missing remote branch

I have about 100 git repositories at $job, and of those, about 90% of them have branches that were created locally that were set as tracking branches, but never pushed to a remote. It makes looking at the output of git branch very annoying, so I wrote the script below to clean up those branches.

Enabling Apache basic auth to work with proxied apps

Recently, I needed to make some changes to a Sinatra based app to support multiple users. I already had basic auth set up, but it wasn't being passed to the unicorn-based Sinatra app that was being proxied behind Apache.

Simple Text Agenda

Yesterday, I got tired of not having a simple way of seeing an agenda for the upcoming days of all my calendars. Between work using hosted Exchange, using a joint iCloud calendar, and still using Google Calendar quite often, getting all of the information in one place is a pain.