I admit it. I am bad. I run raw SQL in my migrations. The dataset I am working with requires it of me. It must be punished. To aid in its punishment, I found a post explaining how to get at PostgreSQL’s COPY from within the Postgres Ruby driver.

Read the rest of “Rails Migrations and PostgreSQL COPY” »

I had no idea my blog was so popular. 100,000 page views in ten days. That’s 10,000 views a day! What kind of crack am I selling? A quick check of the logs indicates it is merely referrer spam. I’ve never seen it so bad, though. Serious brute force is in play. Time to clean up.

Read the rest of “Referrer Spam Annoys Me” »

Should you need to download packages from a unofficial repository, you need not disable gpg signature verification. Instead, you can import the key used to sign the packages into your local keyring.

Read the rest of “apt-key gpg key import on Ubuntu and Debian” »