I am building an ASP.Net Core API. What database would you recommend?<p>I have experience with MySql, but I am wondering if MongoDB would maybe be easier..
Not sure how you expect anyone to answer this as you have provided absolutely no information other than you plan to use .net.<p>What’s the purpose of the server? Who’s the audience? What will it be doing? What sort of volume will it expect?<p>One does not simply create an API server!<p>And there a lot more to it - I’m no expert but my recent foray into this involved a front end API server in the DMZ, and a backend handler (both running under Kubernetes), RabbitMq , Redis, Sql Server and Postgres.<p>Does this API server even <i>need</i> a database? If so, why?<p>Questions, questions, questions…
Seconding Postgres recommendation - it's just so difficult to go wrong with it. It's incredibly versatile and works very well in non-pure-RDBMS scenarios too as document store, querying JSON data in jsonb fields and as vector store with pgvector.
When in doubt, just use postgres. It can handle everything you might want from either MySQL or MongoDB and take you to a scale where you can afford to pay someone to figure out a more appropriate stack for your needs