What might help if you *do* have a local postgres database, is App::geoip, a tool that uses GeoIP2 data from MaxMind ...

(note that you need a free MaxMind account for which you need te enter the data in ~/.config/geoip. Your own location is optional, but when available, the tool can show the distance)

$ cpan App::geoip
$ echo "create database geoip;" | psql
$ mkdir ~/geoip
$ cd ~/geoip
$ cat >~/.config/geoip <<::
cat ~/.config/geoip
local-location  = 50.607080/50.607080
use_distance    : True
json-pretty     : yes

maxmind-account : 123456
license-id      : GeoIP2-Lite
license-key     : aAbBcCdDeEfFgGhH
::
$ geoip --fetch
-- be patient. This will take a while to populate your database
$ geoip -d -l 50.607080/50.607080 ipinfo.io
GeoIP data for 34.117.186.192 - ipinfo.io:
   CIDR      : 34.117.0.0/16
   IP range  : 34.117.0.0 - 34.117.255.255
   Provider  : GOOGLE-CLOUD-PLATFORM
   City      : Kansas City, 616, 64184
   Country   : US  United States
   Continent : North America
   Timezone  : America/Chicago
   Location  :   39.1027 /  -94.5778 (1000)   39°06'09.72" /  -94°34'4
+0.08"
               https://www.openstreetmap.org/#map=10/39.1027/-94.5778
               https://www.google.com/maps/place/@39.1027,-94.5778,10z
   Location  :   50.6071 /   50.6071          50°36'25.49" /   50°36'2
+5.49"
   Distance  : ± 9477.56km
   EU member : No
   Satellite : No
   Anon Proxy: No

[download]

Enjoy, Have FUN! H.Merijn

In reply to Re: IP Lookup Tables by Tux
in thread IP Lookup Tables by monsignor

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.