GitXplorerGitXplorer
j

ip_country_code_lookup_importer

public
0 stars
0 forks
0 issues

Commits

List of commits on branch master.
Verified
e4326e30711474466034eae3e2c5445045323935

Tweak README for clarity

jjustinclift committed 6 years ago
Verified
552595b0cb70b69030b2a57da6f2143e84c8bf1a

Add license and readme

jjustinclift committed 6 years ago
Verified
119d083d2784d88fa2222fbe1ca7fb750441fd24

Code cleanup. Code works.

jjustinclift committed 6 years ago
Verified
b98e332fb97e15198c279cd18bd7ee1ba8ddb815

Initial untested concept code

jjustinclift committed 6 years ago

README

The README file for this repository.

IP Country Code lookup importer

This is a simple command line utility to import the SQLite Geo-IP database into PostgreSQL.

Created this because I need to do some bulk lookups (~3.5 million) on historical data in a PostgreSQL database. The code I was initially doing it with yesterday uses a mix of SQLite and PG calls, and isn't fast enough (~120/second maximum).

With both the historical data and the country code lookup data in PostgreSQL, it should be possible to try some approaches with a much faster throughput.