Collection of IP2Location & IP2Proxy CSV data import articles

Collection of IP2Location & IP2Proxy CSV data import articles

Intro

IP2Location and IP2Proxy both provides data in the form of CSV files that can be easily imported into various databases for queries. To make it easier for our users, we have collected all the relevant article links in a single page. We’ll split them into 2 sections. The first one will be for the traditional relational databases while the 2nd is for NoSQL databases.

If you’re in a hurry, click on any of the shortcuts below to jump to the relevant section that you want.

Relational databases

MySQL | IP2Location IPv4 | IP2Location IPv6 | IP2Proxy IPv4 | IP2Proxy IPv6

Microsoft SQL Server (MSSQL) | IP2Location IPv4 | IP2Location IPv6 | IP2Proxy IPv4 | IP2Proxy IPv6

PostgreSQL | IP2Location IPv4 | IP2Location IPv6 | IP2Proxy IPv4 | IP2Proxy IPv6

Oracle Database | IP2Location IPv4 | IP2Location IPv6 | IP2Proxy IPv4 | IP2Proxy IPv6

IBM DB2 | IP2Location IPv4 | IP2Location IPv6 | IP2Proxy IPv4 | IP2Proxy IPv6

SQLite | IP2Location IPv4 | IP2Location IPv6 | IP2Proxy IPv4 | IP2Proxy IPv6

NoSQL databases

MongoDB | IP2Location IPv4 | IP2Location IPv6 | IP2Proxy IPv4 | IP2Proxy IPv6

Redis | IP2Location IPv4 | IP2Location IPv6 | IP2Proxy IPv4

Amazon DynamoDB | IP2Location IPv4 | IP2Location IPv6

Amazon SimpleDB | IP2Location IPv4 | IP2Location IPv6

Apache CouchDB | IP2Location IPv4 | IP2Location IPv6


 

Relational databases

MySQL

One very popular open-source database is MySQL. Below you’ll find articles for importing our CSV data into MySQL tables.

How to automate downloading, unzipping & loading of IP2Location DB24 data into Linux MySQL
How to automate downloading, unzipping & loading of IP2Location DB24 data into Linux MySQL (IPv6)
How to automate downloading, unzipping & loading of IP2Proxy PX8 data into Linux MySQL
How to automate downloading, unzipping & loading of IP2Proxy PX8 data into Linux MySQL (IPv6)

 

Microsoft SQL Server (MSSQL)

Another popular choice of database made by Microsoft which has a free Express Edition. Below are the articles for importing data into MSSQL.

How to import DB24 (IPv4) into MSSQL 2017
How to import DB24 (IPv6) into MSSQL 2017
How to import PX8 (IPv4) into MSSQL 2017
How to import PX8 (IPv6) into MSSQL 2017

 

PostgreSQL

This open-source database is used by a lot of famous organizations. Hence, we also provides steps for importing our data.

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

 

Oracle Database

This commercial database is highly popular with enterprise customers and as such we want to make it easy for them to load our CSV data with the below articles.

Importing IP2Location data into Oracle Database and querying with PHP (IPv4)
Importing IP2Location data into Oracle Database and querying with PHP (IPv6)
Importing IP2Proxy data into Oracle Database and querying with PHP (IPv4)
Importing IP2Proxy data into Oracle Database and querying with PHP (IPv6)

 

IBM DB2

IBM products such as the DB2 are used by many enterprises, therefore it makes sense for us to provide guides on how to import our data into their tables.

Importing IP2Location data into DB2 and querying with PHP (IPv4)
Importing IP2Location data into DB2 and querying with PHP (IPv6)
Importing IP2Proxy data into DB2 and querying with PHP (IPv4)
Importing IP2Proxy data into DB2 and querying with PHP (IPv6)

 

SQLite

SQLite is a popular free database being used daily by many people without them knowing. This is because it’s meant to be embedded in programs such as your web browsers (e.g. Chrome, Firefox & Safari). See below how to import IP2Location & IP2Proxy data into it.

Importing IP2Location data into SQLITE and querying with C# (IPv4)
Importing IP2Location data into SQLITE and querying with C# (IPv6)
Importing IP2Proxy data into SQLITE and querying with C# (IPv4)
Importing IP2Proxy data into SQLITE and querying with C# (IPv6)

 

NoSQL databases

MongoDB

MongDB is one of the common NoSQL type databases in use today. See below for guides on importing our data.

Importing IP2Location data into MongoDB and querying with PHP
Importing IP2Location data into MongoDB and querying with PHP (IPv6)
Importing IP2Proxy data into MongoDB and querying with PHP (IPv4)
Importing IP2Proxy data into MongoDB and querying with PHP (IPv6)

 

Redis

Another commonly used NoSQL is Redis. Steps for data import are below.

Importing IP2Location data into Redis and querying with PHP
Importing IP2Location data into Redis and querying with PHP (IPv6)
Importing IP2Proxy data into Redis and querying with PHP

 

Amazon DynamoDB

This proprietary NoSQL comes from Amazon Web Services (AWS). We have included some steps to demonstrate how to import data into DynamoDB.

Importing IP2Location data into DynamoDB and querying with PHP
Importing IP2Location data into DynamoDB and querying with PHP (IPv6)

 

Amazon SimpleDB

Another NoSQL by AWS which you can easily import our CSV data using the steps below.

Importing IP2Location data into Amazon SimpleDB and querying with PHP
Importing IP2Location data into Amazon SimpleDB and querying with PHP (IPv6)

 

Apache CouchDB

The final NoSQL on our list is the open-source CouchDB from Apache. Find import steps below.

Importing IP2Location data into CouchDB and querying with PHP
Importing IP2Location data into CouchDB and querying with PHP (IPv6)

 

Was this article helpful?

Related Articles