Projects
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.
Site Update
Wednesday, August 27th, 2003Made some more changes to the sites today.. Added three random images to the top right of the main page, from my photoblog. It updates the random images everytime I make a new entry. Also at the bottom of the photoblog I now display the last 6 entries thumbnails. Looks better i think.
Some links to [...]
Prokyon3 MP3 Manager
Thursday, July 24th, 2003Hmm.. looks interesting. Wonder if it will be good.. Gonna try it some time today. It even has a windows port for you inferior minds out there.
prokyon3 is a multithreaded MP3 manager and tag editor for Linux / Windows. It was written in C using the Qt3 widget set (Qt2 on Windows) and [...]
Mircoblogger
Thursday, July 24th, 2003Neat blogging tool. Very light weight. I like my movable type, but maybe for some people this might be interesting.
… MicroBlogger, as the name implies, is a small, simple, flexible, reliable weblog engine written entirely in bash script. It has absolutely no dependencies on any other programs–No PHP, no SQL, no CGI, no Perl, nothing. [...]