28
Sep
I 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.
Flickr Stream
Archive for the ‘Projects’ Category
27
Aug
Made 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 keep you occupied
Georgia for the second year in a row scored lowest in the nation on SAT.
Governor Jeb Bush Sends Lawyers to Represent a Fetus.
People killed a young autistic boy while trying to “lift” his spirits at a prayer meeting.
How to use Japanese Toilets.
New HP Device Converts VHS to DVD
Arnold interview from 1977 talking about bodybuilding and gangbangs
24
Jul
Hmm.. 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 the MySQL database. prokyon3 can access MP3 files on harddisk, CDROM, SMB and NFS. Files can be played using XMMS (WinAmp on Windows), and can even be played when the files are on CD as prokyon3 identifies CDs by content. The files view is customizable and favorite artists are supported. prokyon3 also offers an editor for ID3 and Ogg tags and has been designed to support tagging for multiple files en mass.
Looky here : prokyon3 – MP3/OggVorbis manager
24
Jul
Neat 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. Basically, if you have a Unix shell account, you can blog with the best of ‘em. MicroBlogger is self-regulating, self-maintaining, and ready to fly straight out of the box. Just unpack the archive in your web directory, add a greeting, and whammo, you’re all set! MicroBlogger’s simplicity has another advantage; its fast, stable, and easy to customize!
Peep it Here : MicroBlogger – Or, Who The Heck Is Bowie J. Poag?!
-
EE V.10!
