Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Perl+PostgreSQL+GeoIP = Awesome!

by cavac (Curate)
on Nov 21, 2018 at 04:23 UTC ( #1226112=CUFP: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    CREATE TABLE geoip
    (
    ...
    )
    TABLESPACE "NAMEOFDATATABLESPACE";
    ALTER TABLE geoip OWNER TO "mydatabaseuser";
    
  2. or download this
    #!/usr/bin/env bash
    
    ...
    perl inserttodb.pl
    
    rm *.csv
    
  3. or download this
    #/usr/bin/env perl
    
    ...
    
        return $val;
    }
    
  4. or download this
    20 1 * * 1 /bin/bash /home/myuser/src/geoip/updategeoip.sh
    
  5. or download this
    
    my $geoip_country = '';
    ...
        }
        $dbh->rollback;
    }
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: CUFP [id://1226112]
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (3)
As of 2019-06-20 02:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Is there a future for codeless software?



    Results (89 votes). Check out past polls.

    Notices?