Paper Title
A BASIC COMPARISON OF MYSQL, POSTGRESQL, AND MARIADB RELATIONAL DATABASES USING PHP ON DOCKER

Abstract
Abstract - The database is a way to store data electronically in an organized way. There are different types of databases, brands, query languages, and execution environments in the market. Depending on the product (software), a suitable database needs to be selected. This depends on the platform (web, desktop, mobile), programming language, licensing, costs, security, performance, etc. For the decision of databases, it is possible to check the rankings, scores, and popularity of databases. In this study, we compared 3 different relational databases which are MySQL (versions: 5.7.42 and 8.0.33), PostgreSQL (versions: 12.14, and 15.3), and MariaDB (versions: 10.6.13 and 11.0.1-rc). We performed custom tests and benchmarks. For our custom testing, we developed a basic PHP application. We used official Docker images of the given databases and PHP 7.4.33-Apache Docker image from Docker Hub and run these images using Docker version 20.10.17. In our custom testing scenarios, we inserted 1.000.000 (1M) rows to a table in these databases. We performed comparisons on execution times of 1M-Insert and different Select & Update queries in these databases. For the benchmarking, we used Sysbench with OLTP Read-Only and Read-Write benchmarks. We observed the best result with MariaDB version 10.6.13 for 1M-Insert. For other Select & Update tests, we had the best results with PostgreSQL version 12.14. We obtained the best benchmark results from MariaDB overall. Keywords - Relational databases, MySQL, PostgreSQL, MariaDB, PHP, Docker, DB Testing.