The April release is now available.

For previous users of the database there is some changes in the database structure. These mods are from suggestions from users in the forum :

1) IP are now stored using the following formula (256 times bigger int than before) :

ip = ((A*256+B)*256+C)*256

Why? to use directly the INET_ATON function in MySQL. Now queries are simply :

SELECT * FROM `ip_group_city` where `ip_start` <= INET_ATON('74.125.45.100') order by ip_start desc limit 1

IP are stored as bigint NOT int(11) anymore...

2) Added reserved and unallocated IP classes (iana.org)

3) Canada and USA region codes are now using the FIPS standard (no more 2 letters abreviation)

4) Country table renamed to iso3166_countries

In a few days I will release an even smaller database. City, latitude and longitude will be store in different tables because there is alot of redundant data...

Stay tuned, during the month of april I will release some new tools as well!

THE DATABASE