Changes in United Kingdom Postcodes

The United Kingdom postcodes are alphanumeric and are variable in length including a space such as “SW1A 1AA”. Each postcode is divided into two parts separated by a single space known as the outward code and the inward code respectively. The outward code includes the postcode area and the postcode […]

How to create region maps display in Kibana

You are able to create region maps via the Kibana Visualize Service. Region maps are thematic maps in which boundary vector shapes are colored using a gradient. The region maps in Kibana provides various selections of vector map. For example, World Countries, Argentina Provinces, Australia States, Belarus Regions and more. […]

MySQL vs. MongoDB IP2Location DB24 query benchmark

Intro For this article, we will be running a few tests to determine whether MySQL or MongoDB is better when it comes to the query speed for the IP2Location DB24 data. We have generated some test data with random IP addresses. There are 10 test files containing IP addresses with […]

Changes to Country Names in IP2Location and IP2Proxy

IP2Location is going to update the country names used in IP2Location or IP2Proxy products as according to the latest ISO-3166 standards defined by ISO, the International Organization for Standardization. There will be no changes to the ISO3166-1 Alpha-2 Codes (the 2-digits Country Code), but only for certain full country names. […]

Importing IP2Location data into Cassandra and querying with PHP (IPv4)

Intro The guide will demonstrate how to import IP2Location data (DB11) in CSV form into Apache Cassandra and then query the data in a PHP page. First of all, you will need to download the IP2Location DB11 CSV file. Download Free LITE version at https://lite.ip2location.com/database-ip-country-region-city-latitude-longitude-zipcode-timezone Download commercial version at https://ip2location.com/download?code=DB11CSV Extract […]

Importing IP2Location data into PostgreSQL and querying with PHP (IPv4)

Intro The guide will demonstrate how to import IP2Location data (DB11) in CSV form into PostgreSQL and then query the data in a PHP page. First of all, you will need to download the IP2Location DB11 CSV file. Download Free LITE version at https://lite.ip2location.com/database-ip-country-region-city-latitude-longitude-zipcode-timezone Download commercial version at https://ip2location.com/download?code=DB11CSV Extract […]

Blocking country visitors in ASP.NET MVC with C#

Intro For this article, we will look into how to use the IP2Location .NET Component to block website visitors in ASP.NET MVC 5 project. We will assume that you already know the basics of ASP.NET MVC so we will just show the relevant codes using C#. Our example will be […]