MYSQL used as database

Acronym
sig-api-database
Belongs to
SIG APIs
Responsible
TheBuro und FalahSama
History
(v1)   2021-01-13 - created initially
(v2)   2021-01-28 - need for decision
(v3)   2021-02-12 - edit Resolution Details, todos

Why is there need for such a decision?

There are many database systems for different purposes. It is therefore important to find a database system that is useful for our project. A database is needed to centrally manage the data. This database allows us to store data persistently.

Additional sources for better understanding the background

Comparing Database Management Systems: MySQL, PostgreSQL, MSSQL Server, MongoDB, Elasticsearch and others. Here you can find the different open source database-systems and their basic structure e.g. relational and non-relational database-systems.

Viable Options

Alternatives not seriously considered

Commercial database-systems are unsuitable for open source projects.

How is this decision evaluated?

Resolution Details

After implementing the concept, the following findings emerged:

Both database systems behaved the same. There were no noticeable differences. In our opinion, this is more a matter of taste. In the end we decided to use the MySQL databases. Due to our experience with this database, this decision was easy for us.

Database table prefix convention.

Setup spring database connection.

Database version controlling with Flyway.

Reasons for the resolution

Based on personal experiences and testing both systems. The better choice is Mysql.