Tag Archive for "How-To"

Editing Songbird Add-ons

April 8th, 2009 by Andrew

The Notify Me add-on allows you to get Growl notifications when the song changes. Unfortunately, the add-on hadn’t been updated in 4 months. Here’s how I made it work with the latest version of Songbird.

Continue Reading Editing Songbird Add-ons...

Finding Frequency Counts With SQL

January 11th, 2008 by Andrew

Finding the frequency of items in a database table is something I find myself needing to do a lot. Though for some reason when I need to do this, I always forget how, so here it is. Let’s say you have a table of tag data with two columns and a bunch of rows. Let’s say the table is a simple adjacency list of tags for posts on a blog.

Continue Reading Finding Frequency Counts With SQL...

Changing File Extensions

April 20th, 2007 by Andrew

Today at work I needed to change a whole directory (with many sub-directories and sub-sub-directories and… etc.) of .php files to the .html file extension. Since the files were on a Unix server, I wrote a quick Bash shell script to take care of this for me. #!/bin/bash   function change_extension_recursive {   #change all […]

Continue Reading Changing File Extensions...