I am having a problem to solve this issue in DynamoDB. I need to create a table of sellers and their location expressed as Long and Lat attributes.
Now if I have a Buyer. I need to return all sellers within 1 Mile radius of the buyer.
How do I structure my seller table, and if I need a GSI what do I do there? Assuming that I have a formula that works out the starting long/lat and ending long/lat. So I need DynamoDB to return any sellers located in between the lower and upper boundaries.
Also what partitioning logic do I need to adopt?
Thank you in advance!