Where do my visitors come from? The ip-address does not tell you too much about the visitor and I always wanted to see where those ip-addresses are located.
Just the other day I saw link to a free IP address geolocation SQL database (thanks Marc for making that one available). I downloaded the 11MB file and added the database to my mysql server.
Next, I created a simple perl script, that walks over my web servers (apache) access_log, extracts ip-addresses, access-date/time and url and finally converts all those items (using above mentioned database) into a KML file that can be fed to Google Earth.
The result looks like this in Google Earth: