Can anyone please let me know what's the best way of using the GeoIP databases in order to detect the country of visitors by IP.
I used to have a table populated with IPv4 information ( longstart, longend, country code ) and with an INET_ATON() instruction I would get the relevant country code.
However, we would now want to use the IPv6 database and grab country code for IPv6 IPs as well. But not sure what's the best way to use these databases. I can see they offer various databases now(geolite legacy, or geolite 2, or the APIs), they also offer some update script - not sure how this works though, or in relation with what.
Any help would be appreciated. Thank you.