Learn how to import MaxMind GeoIP2 and GeoLite2 databases into PostgreSQL or MySQL

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.

How accurate is IP geolocation?

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.

Continue reading

Research Defender uses minFraud as part of a homegrown solution to protect the integrity of research done on behalf of its customers.

When Vignesh Krishan founded Research Defender in 2018 he knew that managing fraud was critical in the global market research industry. The company set out to deliver high-quality consumer insights for companies in diverse industries all over the world. They understood even before they got started that ensuring the quality and integrity of the research was going to be essential to their success and the success of their customers.

Continue reading

UMass’s Rescue Lab uses GeoIP2 to Help Rescue Children from Abuse

Leveraging the strengths and understanding the limits of IP geolocation, the Rescue Lab plays a critical role in rescuing children from online sexual exploitation crimes.

Warning: The following article discusses child sexual abuse and may be disturbing to some readers.

The scale of the problem is staggering. Every month, more than 800,000 people share images and videos of children being sexually abused. The sharing of these images is a re-victimization of the abused, haunting them well into their adulthood. And the investigation of sharing by law enforcement has time and time again led to the rescue of a different child being actively abused. The sheer volume of child sexual abuse materials being shared online poses what was, for many years, an impossible logistical challenge. 

The issue isn’t a lack of people who care. The problem is one of sorting. If there’s a pool of 800,000 potential cases, all of which occur in the geographically nebulous space of “the internet,” how do you distribute these cases among the thousands of people—law enforcement officers—who have devoted their lives to fighting child sexual abuse? Without a method to effectively sort investigations into geographical jurisdictions, the cases are unmanageable. Figuring which of these offenders may be in your area would be like looking for a needle in a haystack.

Continue reading

How to map custom boundaries in Kibana with reverse geocoding

by Thomas Neirnyck
This article was originally published on The Elastic Blog on Jan 20, 2021.

This tutorial shows how you can leverage GeoIP data using tools developed by Elastic. Elastic builds software to make data usable in real time and at scale for search, logging, security, and analytics use cases. Elastic’s tools make it easier for operations teams to keep applications running, or give security professionals a one-stop-shop for spotting and neutralizing digital threats. Learn more at elastic.co.

Want to create a map of where your users are? With the GeoIP processor, you can easily attach the location of your users to your user metrics

Continue reading

Changes to Database Access for Expired Subscriptions

In order to better ensure that out-of-date IP data is not being used, MaxMind will no longer allow customers to continue to download old GeoIP and GeoLite databases once their subscription expires. This will help us to ensure compliance with digital privacy laws, protecting our business and yours.

This change will come into effect on February 8, 2021. No action is required on the part of customers.

In the past, we have allowed customers to continue to download databases past their subscription date as a courtesy, removing access only when the latest version of the databases they have paid for are 30 days old. Moving forward, customers will not be able to download paid databases once their subscription has expired. By removing access to these databases, we are working to ensure that only the latest versions of our databases, which regularly incorporate critical updates, corrections, and changes based on digital privacy rights, are being used in production.

Integrating MaxMind’s Free and Paid IP Geolocation Web Services (in PHP)

In December MaxMind released the new GeoLite2 web services, an IP geolocation API available free of charge.

IP geolocation services provide information about the geographic location of an IP address. MaxMind offers such free web services, GeoLite2 City and GeoLite2 Country, which are comparable to, but less accurate than, MaxMind’s paid GeoIP2 Precision City and GeoIP2 Precision Country web services. GeoLite2 is fully compatible with GeoIP2, using the same API and integration method, making it easy to switch between the free and paid services as your needs change. You can compare accuracy of the GeoLite2 and GeoIP2 web services by selecting a country on the GeoIP2 City Accuracy page.

In this blog post, we are going to review how to build a simple web page in PHP that uses GeoLite2 City. We will learn how to easily upgrade to the paid GeoIP2 Precision City web service, for greater accuracy and unlimited queries (GeoLite2 web service users are limited to 1,000 queries per day).

Continue reading

GeoLite2 Web Service: Free IP Geolocation API

We are happy to announce the release of the GeoLite2 web service, a limited free IP geolocation API. You may use up to 1000 look-ups per day for the GeoLite2 web service.

Since 2002 MaxMind has been trusted by hundreds of thousands of developers to provide IP geolocation data for projects of passion to enterprise-grade applications and everything in between. 

We’ll keep this brief: why should you use the GeoLite2 web service?

  • Reliability.
    We have been at this for 18 years and our web service infrastructure serves tens of billions of requests annually with 99.99% uptime.
  • Accuracy.
    We know that IP geolocation has its limitations and we strive to be as transparent as possible about our accuracy numbers for both our free and paid solutions.
  • Accessibility.
    Our APIs are public and widely adopted which is why you have probably seen MaxMind integrated in some of the platforms you use, and probably why you know about us.
  • Flexibility.
    If you need more accurate or other kinds of IP data all you need to do is switch out the URL  to call one of our paid web services. We don’t require a subscription or commitment. You can pay as you go and service credits don’t expire.

To sign up for GeoLite2, head over to our GeoLite2 page.

If you’re an existing GeoLite2 database user, you can generate a license key and start using the service immediately. Our GeoIP2 Precision web service client APIs may be used with the GeoLite2 web services.

Enriching MMDB files with your own data using Go

MaxMind DB (or MMDB) files facilitate the storage and retrieval of data in connection with IP addresses and IP address ranges, making queries for such data very fast and easy to perform. While MMDB files are usable on a variety of platforms and in a number of different programming languages, this article will focus on building MMDB files using the Go programming language.

Continue reading