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 […]
How to create map visualization in Kibana using IP2Location Data
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. With the help of region maps, you will be able to learn more about your visitors. For example, where are they coming from, […]
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 […]
Using IP2Location .NET component in ASP.NET MVC with C#
Intro For this article, we will look into how to integrate the IP2Location .NET component within an 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 a simple form […]
How to detect the location from a visitor’s IP using the Free IP2Location™ LITE Database in Symfony 4
In this tutorial, we’ll show you how to get the current location from a visitor’s IP using the Free IP2Location™ LITE Database in Symfony 4 project. This project only supported for Symfony 4. Step 1. Download Free IP2Location™ LITE Database As the first step, you will need the CSV database […]