I should have mentioned that I will have to make queries based on geographical coordinates. I understand that Postgis extension can handle that. There will be hundreds of thousands of locations to scan, based on coordinates.
I have looked into AWS serverless PostgreSQL (Aurora), I think I can start with that. At some point I will have to implement sharding, which can be done at application level.
Do you know of any other DB system that can be horizontally scalable ?
