Geolocation Data Loading
Load the Geolocation data to learn more about prospects provided by PostgreSQL.
We'll cover the following...
We’re going to have a look at how to geolocalize an IP address and locate the nearest pub, all within a single SQL query.
Locating the nearest pub
For that, we’re going to use the ip4r extension from RhodiumToad.
The first step is to find a Geolocation ...