Question regarding geographic queries
Our team is currently working on some killer ios location app that we fear "explode" in a good way, so we want to put effort thinking about scalability and Availability.
After we read that draw something is based on your no sql, we scanned the couch base api (specifically the .net one) and found solutions to all of our app requirements except one, and we describe the scenario:
1. Let's say we have order of 1,000,000 users around the world, with their location specified by longitude and latitude;
2. We have a user circle range c: it's location (specified by longitude and latitude) and a radius rc
3. We want to efficiently determine which of the users are in the circle.
If we write it in sql server as we did now it's something like this:
CREATE TABLE UserLocations
[UserId] [bigint] NOT NULL,
[CurrentLocation] [geography] NOT NULL
ALTER PROCEDURE sp_GetCurrentUsersInRange
select UserId from UserLocations
where @userPoint.STDistance(CurrentLocation) <= @RangeInMeters
and UserId <> @userId
But this is No SQL, there are only keys (such as longitude key and latitude key), but we can’t fetch all the values and query them all in memory
, can't we?
So the question to you is:
Is there a way you know how to accomplish such thing in couchbase?
Thank you very much,
p.s. our related question in Stackoverflow: http://stackoverflow.com/questions/10211579/how-to-determine-n-locations...