I'm writing a client-server application where geotagged photos are main content.
Backend is based on ASP.NET Core tech stack.
Backend should be able to search photo in area (by radius), search photo by tag and probably suggest tags (kind of autocomplete), all that stuff will be visible thru some simple REST API.
I'm not really sure if i need relational DB for such a simple task. Also i'd love to see search by distance from point made by DB not by my code. Good integration with .NET Core is a great plus.
I've worked with SQL Server from MSFT, but it seems a bit overweight for this simple task.
Could you guys with some experience in area, advise a DB for my task?