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.
One very popular open-source database is MySQL. Below you’ll find articles for importing our CSV data into MySQL tables.
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|
This open-source database is used by a lot of famous organizations. Hence, we also provides steps for importing our data.
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.
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.
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.
MongDB is one of the common NoSQL type databases in use today. See below for guides on importing our data.
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|
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)|
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)|
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)|