Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 1 of 1 « Previous | Next »
Displaying posts with tag: geoip (reset)
How to create your own IP to Location translation

Several years ago (looking at archive.org it was at the end of 2001) I wrote a database that translated IPs to locations. Very similar to the city-db from maxmind.com. Perhaps someone still remembers the article in the iX about it ?

Anyway, now it is time to release the idea to the public. The idea is a distributed, open-source IP to location translation. Source comes later.

The basic idea

The idea behind IP-to-location translation is pretty old already. For I stumbled over it when I was running traceroute to some IP addresses on IRC. If you are in city-specific channels, you can easy proof if the basic idea works or not.

# traceroute -w 1 -q 1 …
[Read more]