Hello, IPLocation.db provides access to MaxMind's GeoLite City data as a - rather hefty- SQLite3 database.
http://alt.textdrive.com/assets/public/Nanoki/IPLocation.100.zip (48.3 MB) Usage example: % sqlite3 IPLocation.db select location.start as start, location.end as end, city.name as city, region.name as region, region.code as region_code, country.name as country, country.code as country_code from location join city on city.id = location.city_id join region on region.id = city.region_id join country on country.id = region.country_id where location.start <= 2154863525 order by location.start desc limit 1 > 2154823680|2154889215|Princeton|New Jersey|NJ|United States|US Kudos to Igor Tandetnik for highlighting an efficient way of querying such data [1]. There is also a Lua [2] front-end for it: #!/usr/bin/env lua local IPLocation = require( 'IPLocation' ) local aLocation = IPLocation[ '128.112.155.165' ] print( aLocation.city, aLocation.region, aLocation.country ) > Princeton New Jersey United States Cheers, -- PA. http://alt.textdrive.com/nanoki/ [1] http://www.mail-archive.com/[email protected]/msg28622.html [2] http://www.lua.org/about.html _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
