Not sure where to post this so I thought I'd ask for ideas here..
We have a potential requirement to have a database (postgres) full of postcodes (including Latitude/Longditude etc) so distances between 2 postcodes can be calculated using basig trig. Every user of the site would have their "position" stored.
The question is how to store data efficiently to enable a user to see all "postcodes" within a certain radius yet allow scalability as to the number of users ? The "radius" would be modifiable by the user and needs to be calculated on a real time basis.
If anyone has any ideas I would appreciate it, although I will be investigating myself... Now where is Google
If you can afford go for any geotargetting database, to build a comprehensive and accurate database is too cumbersome, for my company we are using geotargetting extensively for advertisements and fraud detection
Country Code
Country
Distance to Nearby Cities
Region Code
Region
City Code
City
CityId
Certainty
Latitude
Longitude
Capital City
TimeZone
Nationality Singular
Population
Nationality Plural
Is proxy
Currency
there are many service providers though , do a search with geotargetting or ip2country on you search engine you will get many offers