Dark Light

Data is fun.

One of the nicest things you can do to a programmer like me is give him (or her) a pile of data in a nice format that is easily extractable, and tell him (or her) to go have fun.

Last night, after a couple of weeks of looking at it, pol installed mod_log_sql which is an Apache module that makes all access logs become a mysql database, so a list of referers becomes simply “select count(referer) as referals, referer from table group by referer order by referals desc”. Hit counters become easy, life becomes good, and I get to do all the automatic “This is popular, if you like $foo, go see $bar” stuff without parseing text files! Woot, and indeed, yay.

Related Posts

Wheee! Design!

Another day, another design. A couple of known errors: It looks crap in IE. Yeah, we know. Not…

Discussion Matrix

Whilst other people may be listening to the queens speech, watching Bond Films, playing with presents or stuffing…

Buffometer

The Buffometer is a level of how far I am into viewing episodes of Buffy and Angel (And…