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.
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.
Anonymous IP addresses (sometimes incorrectly generalized as “proxies”) serve to hide a web user’s true IP address and obfuscate their geolocation. There are legitimate reasons, usually related to privacy or security, to use anonymous IPs, but many businesses find that fraudsters and other bad actors also use anonymous IPs in malicious ways that affect the bottom line.
After careful consideration, taking into account customer feedback, we have decided against removing latitude and longitude coordinates from the GeoLite2 databases. We are in the process of reviewing coordinates used in all of our GeoLite2 and GeoIP databases to ensure there is no risk of misuse.
Moving forward, we will still be discontinuing the GeoLite Legacy databases and will continue to support open source through our GeoLite2 databases. Please continue to check our blog, Support Center, websites, and ourTwitter andLinkedIn accounts for additional updates on our review of GeoLite2 database coordinates.
At MaxMind, “open communication” is one of our core values. We’re listening to you and we take your feedback seriously.
Digitally savvy consumers areincreasingly seeking online experiences tailored to their interests; meanwhile, web personalization companies likeGeoFli are increasingly seeking ways to deliver just the right experiences to those consumers, at the right time.
“We wanted to create a service to display website content based on a visitor’s IP address,” said GeoFli co-founder Nick Shontz. “Using MaxMind’s GeoIP2 City database combined with GeoFli’s custom software, we have seen conversion rates double for our customers. It’s great having an industry-leading tool like GeoIP2 City that’s so easy to integrate with our systems and have such great application and scalability,” Shontz added.
Free and open source code has been part of MaxMind’s technical and organizational foundation since our earliest days. As we continue to develop new products to better service our customers with a broader range of diverse and innovative offerings, we occasionally find it necessary to discontinue or phase out some of our products or services.
Accordingly, we have decided to discontinue the GeoLite Legacy databases on January 2, 2019. (Note that we will begin by discontinuing updates to the free GeoLite Legacy databases as of April 1, 2018. For info, see the “Important dates to consider” section.)
MaxMind is heading to ad:tech New York, one of the world’s largest conferences for digital brands and technology leaders. Come visit us at our booth and learn more about our GeoIP and minFraud products, and stick around for a speech hosted by our Director of Business Development Jenn Sessler.
Every year, more than a billion consumers shop on e-commerce websites. And in 2016, a new startup called Fomo set out to help merchants reach that audience. To do that, Fomo first needed to find a service partner with expertise in geolocation. They chose MaxMind. “We’re a relatively new company, but our growth has been phenomenal since we added MaxMind’s GeoIP2 Precision services,” said Fomo’s co-founder Ryan Kulp.
If you use a GeoIP database, you’re probably familiar with MaxMind’s MMDB format.
At MaxMind, we created the MMDB format because we needed a format that was very fast and highly portable. MMDB comes with supported readers in many languages. In this blog post, we’ll create an MMDB file which contains an access list of IP addresses. This kind of database could be used when allowing access to a VPN or a hosted application.