squash-last-commit.sh

Sometimes you make a git commit, but there's a typo or syntax error in there by accident. I normally use git rebase -i HEAD~2 and then through the magic of vim I'm fairly productive at squashing the two commits together.

But wouldn't it be nice if there was a way to run one command to squash your most recent commit (which probably has a useless message like "typo" anyway) into the next most recent? Lucky for you, there is now!

Make mosh print the message of the day on Ubuntu 14.04

I'm running mosh 1.2.4 on my Ubuntu server, and it's always annoyed me that it doesn't print the message of the day (MOTD) on startup. ssh prints helpful information when you log in, like if you need to reboot or update packages, that I miss when logging in via mosh.

So you can imagine my surprise when I found out that this issue was fixed in version 1.2 of mosh, 4 versions ago!

Turn off MySQL Password Expiry

The other day my computer begain repeatedly giving me this MySQL error:

Your password has expired. To log in you must change it using a client that supports expired passwords.

It happened to my root account and my Devin account. I searched online quickly and found out (after more looking than I'd hoped for) how to change my password.... but the problem came back a few days later.

Copy ssh key in one command

This is absolutely brilliant

cat .ssh/id_rsa.pub | ssh remoteserver.example.com 'cat >> .ssh/authorized_keys'

All credit to Matt Might

Working more efficiently with rails migrations

I've been working on a major schema refactor on a rails application recently, and time and again I've had to reset my database because of some syntax error or another in my migrations. I'm changing schemas and moving data between columns, which makes the migrations really fragile.

It's also been fun learning about the rake tools that allow you to manage database migrations. In particular, three rails commands have come in handy:

HSTS and git

I've been in China for two months now, and I enjoy programming so I've checked probably 5-6 projects out of github at this point.

During this time, I've had troubles accessing https://gist.github.com. This always struck me as weird, but I didn't think too much of it.

In praise of the spreadsheet

Spreadsheets are amazing. They are arguably a Turing-complete programming language (only stretching the definition slightly). There are definitely as many spreadsheets as people in the world, and I'd even guess there are over a trillion actively used spreadsheets out there somewhere.

Simple touch-friendly HTML menus (using javascript)

I have a website with a two-level dropdown menu (it's not this one!). I want it to be slick, so I used CSS to only show the submenus when the user was hovering on the relevant parent menu item. This was great, until I realized people liked to access my website from their phones. The only way to reveal the submenus using a touch screen is to click the top menu item, but that will activate the link and change the page before you can find the link you want.

Convert ovpn file to inline format (all in one ovpn client config file)

Whenever I use openvpn I'm stuck carting around 5 files, sending them over Bluetooth and cluttering up my phone's downloads directory or confusing people I'm setting up with openvpn

I decided finally to figure out inline openvpn client config files (note: all-in-one files don't work on the Securepoint SSL windows client). I made this sed script/command that will automate the process. Imagine that the following five correctly configured openvpn files are in my current directory, with the openvpn file referencing the others:

Chinese software development and computer terms

I scoured the internet for a cheat sheet list of Chinese vocabulary related to computers/tech work, but I couldn't find one. So here goes nothing!

Short link to this list: www.devinhoward.ca/chinese

Pages