flickr.com/photos/andrewmwhalen
linkedin.com/in/andrewmwhalen
twitter.com/awhalen
youtube.com/user/whalenaTag Archive for "How-To"
Editing Songbird Add-ons
April 8th, 2009 by Andrew
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.
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 [...]