Comparative analysis of selected databases on the example of a proprietary web application

Database performance is one of the most important factors affecting the usability of the system. Therefore, the authors of the article decided to examine 3 popular database systems: MySQL, MS SQL and PostgreSQL, analyzing their performance. For this purpose, a test application was prepared and Docker software was used to simulate different hardware parameters. Depending on the selected settings and the number of records, different results were obtained. For small data sets, the differences were almost imperceptible. They have drastically increased for large data sets. In this case, MySQL fared poorly, and MS SQL was the best. This means that the choice of the database is very important, and it is worth considering the available hardware, the amount of data and the queries performed.