We’ve added documentation to our developer’s site giving a tutorial on how to import the CSV versions of our GeoIP2 and GeoLite2 databases into PostgreSQL and MySQL. In addition to the basic information about how to bring MaxMind’s data into these popular database frameworks, we have also included pointers from our dev team on how to index and organize them for faster searching.
You can import GeoIP2 and GeoLite2 data into your database in order to more easily manipulate and transform the data, or join and link the data with other datasets.Check out the tutorials for PostgreSQL and MySQL on our developer’s site.
With nearly two decades in the business of IP geolocation, we spend a lot of time thinking about accuracy, but, as with all things big data, a simple question usually has a complex answer. As we approach our twentieth anniversary, we’ll be offering some insights into the industry. This month we’ll cover the basics, answering questions about how accurate IP geolocation is and why. In this post, we’ll talk about some common assumptions about how IP geolocation works and contextualize those assumptions in light of the structure of the internet and the distribution of the IP space across geographical regions. In light of these considerations, we’ll develop a deeper understanding of the constraints and opportunities for IP geolocation.