All posts by Namita Parwal

Exploring mod_geoip

Problem Statement We have been inherently using IP Lookups for various purposes : Redirecting a user based on country. Advertisements and banners specific to the country/city of access. Default landing page based on user location. Country specific contact details. Fetching country from IP seems a trivial task. However, to fetch a country name against a given IP we usually query the database (either spatial or range queries), which results in a large number of sql queries everyday, thus increasing the database load. Solution mod_geoip is an Apache extension,... Read More