Positional Lookup of Cached Geolocation Data

Meister Source

I have a project where I have many different users connecting to my server and providing their geolocation (latitude, longitude), and I would like to "broadcast" messages to users within a certain radius of a point. After a time, the provided locations should expire. I can do this with PostGIS, but I'm not sure if this would scale well, would like to avoid database calls as much as possible, and I think perhaps an in-memory cache would be more efficient. It is definitely too early to start optimizing, but I'd like to know what other options I might have from the start.

Does anyone have any experience or have any insight in the different options (database, cache) to store and retrieve geolocation data based upon location?



comments powered by Disqus