Does Amazon Web Services have a solution to store objects in a database with a latitude and longitude and then to do a geo query on them to give you all objects in a specific radius and sort them by what is closest to the center of that radius?
There are geohashing solutions for DynamoDB but those don't allow you to sort results by what is closest to the target location.
CodePudding user response：
I think the term you’re looking for is spatial search or spatial indexing. DynamoDB does not have such a feature, but the SQL-based products in the RDS area support spatial indices, including geofencing just like their “normal” counterparts (MySQL, Postrgres etc.).
If you are looking for a low-touch solution, you can look into the different Aurora options, including Aurora Serverless. For example, Aurora MySQL has support for different spatial types/indices.
CodePudding user response：
There are many offerings from AWS which can offer geo-spatial queries, depending on your specific use-case will determine which option is best for you.