Looking for suggestions for a good DB to use given the archictecture of this application.
I have been given a pretty open ended choice to make so looking for reasons to use on dB over another.
Here is the environment:
I will be developing a web application using .net core.
I will be building a parallel deployment ..
1) Traditional Azure deployment.
2) I will be using Docker in the future..so was hoping to put that planning in at the beginning of my design...but this initial rollout will just be using Azure in the private cloud.
3) I will have some level of web api and microservices...to what extent I am not sure.
4) My front end so far I am leaning the latest Angular 7.
My company wants me to pilot something new so that rules out SQL Server versions or Oracle.
I am gussing this leaves me to Mysql or MariaDB. PostGresSQl
some version of NoSQL such as Mongo or Cassandra.
This application will be low transactional...and will not be very large..thus the reason the company wants to use it to pilot...yet
at the same time I dont want to put that in as the requirement as its possible this is more a pilot for the company to think about one database going forward
versus having many different versions of Dbs in the enterprise.
Currently we have alot of SQL Server, Oracle, and DB2. I also believe out external website is Maria.
So any thoughts?
I honestly hate just picking one only to say lets test it. But that does seem to be the requirement.
I plan on putting something together that really shows the pros and cons.
We are moving from onPrem to on the Cloud more and more in the coming months...So new projects will most likely be on something different unless we have to using existing db licensing.