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?cachinggeolocationpostgis