MySQL

Each of the products has its own merits and demerits. however since MySQL is a very good documentation and global community its easy to learn and apply in different stages for analytics work. compare to other data bases its simple for setup and work on it. MySQL is cost effective and low risk choice for start up organization makes it more suitable for small to medium enterprises.

Rest all the big brand databases incure high licensing cost giving almost the same value that MySQL is giving being an open source database. Other databases like Oracle, MS SQL servers need extensive resource along with a huge team to manage those databases. However, thats not the case with MySQL as it provides almost same functionality without any license.

Selection of MySQL or Oracle SQL Developer depends on various factors like timelines, requirements, features and data volumes. We are using both MySQL and Oracle SQL Developer in our organization. MySQL is more suited for small applications with few thousand TPS and less users. Where number of active users are more or volumes of data is high, Oracle SQL Developer is the better option.

In terms of capabilities, Microsoft SQL Server is one of the leaders in the database market. It provides a lot of features for high availability, disaster recovery, performance and security. The primary reason why MySQL 8 was chosen was due to the open source nature of the technology and for minimizing licensing costs.

SQLite - Is the goto DB for Mobile/Desktop Apps. Its not as elaborate as Mysql but since its a RDBMS it provides all the basic features and its lite. We use mysql at the backend and for desktop app we use SQLite

postgres - Its a formidable opponent. It is fast and reliable and is is an object-relational database. It is more suited for very complex processing as it has a very tight data integrity. For simple, read-heavy workflows, web based projects (almost all projects) mysql is a much better choice. Also writing and executing query on mysql based client is a easy job. Personally I find executing queries on PSQL terminal quite cumbersome.