Archive for September, 2007
MySQL average times
Friday, September 28th, 2007I was trying to calculate average time in MySQL. I had a “time” field. After fooling around I came up with:
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(actual_arrival))/COUNT(actual_arrival))
FROM arrival_times;
It actually is pretty fast too.
Perl to ASP ICK!!
Thursday, September 27th, 2007What a shame… paying someone $75k to convert Perl web apps to asp.net.
Mid-level .NET Developer
I think I’m gonna be sick!
New Sony Headphones
Wednesday, September 19th, 2007My parents got me a pair of Sony MDR-7506 headphones for my birthday.
Previously I was using Bose Quiet Comfort 2 headphones. They were great for noise cancellation, but the bass was a bit overpowering. I sold them when I was saving for a new camera.
These new Sony headphones rock! I’m going back and listening to [...]
Making a Negroni
Monday, September 17th, 2007So I picked up some Campari tonight, as I wanted to try a Negroni. It was a lot more potent than I thought it would be.
Negroni as listed in Playboy bartender’s guide:
3/4oz. Campari
3/4oz. Sweet Vermouth
3/4oz. Bombay Sapphire Gin
Shake over ice and strain into pre chilled cocktail glass.
The drink was pretty herby and somewhat bitter. It [...]
WordPress RSS Feed Rewriting
Monday, September 17th, 2007I noticed I was getting hits for my old Movable Type feeds, yet WordPress doesn’t implement the same links by default.
Some mod_rewrite magic did the trick. I wasn’t able to find a clear simple answer anywhere so came up with this pattern. Seems to work great.
RewriteRule ^(rss|rss2|atom).xml /wordpress/?feed=$1 [QSA]
Upgraded to Wordpress
Tuesday, September 11th, 2007Moved the blog from Movable Type 4 beta to WordPress. So far so good. WordPress is easily 3x faster than Movable Type was.
Got everything migrated and setup. Seems just as easy to use.
Back From Vacation
Tuesday, September 11th, 2007Back to work today from vacation. It was relaxing. I ate too much though.
A short breakdown of the cruise:
At Sea:
The days at sea were very relaxing, mostly I ate too much, laid around, went to shows, and swam.
Montego Bay, Jamaica:
Jamaica was my least favorite stop on the cruise. Mostly because the people hassled us a [...]