Forum Discussion
When should I use SQL Server, MySQL, or PostgreSQL?
I'm working on a web application (using C#/.NET backend), and I need to choose a relational database. I'm considering three options: Microsoft SQL Server MySQL PostgreSQL I want to understand: ...
Azure SQL database would be a good fit for your use case. It can handle complex queries and joins with ease and highly scalable on azure(depends on your pricing tiers) . You can also use elastic pools for cost optimization.
postgres sql would be a close second as it is only being supported by azure recently and it may be slightly cheaper option to go with
both are fully supported by entityframework core and you may keep you business logic in linq to have db options flexible as you have only moderate traffic. However , if you need to hadle complex db logic, both db's are ideal as they both offer robust server side programming tools. Hope this helps