Database support

[avgustinmm]

Supporting a database is not a trivial task. This involves:

• Supporting migration scripts
• Flyway per database dependencies, see add flywaydb postgre dependency #2024
• Testing against each database (at least we mainly test against in-memory H2 and MySQL).

I'd like to gather feedback about the usage of hawkBit with different databases. Currently, in theory, hawkBit supports H2, DB2, MySQL, MariaDB, PostgreSQL, and SQL Server.

Could you please share which database you are using? This information will help us consider which databases should be supported in the future.

[diegorondini]

Hi.

In our case we're using MariaDB.

[tommylp]

Currently running MariaDB on aws rds

[BrandonSchmitt]

We use MySQL 8.

[avgustinmm]

Since it seems not users for DB2 and MS SQL Server we decided to cancel support for these databases.
We plan to have next release (0.8.0) these days with support for both, and after that support will be removed.
This means we will stop update the flyway migration scripts for both databases. Of course, anyone could continue to maintain by himself these migrations following the supported by hawkBit project migrations.

So, the supported database list will be:

• H2 - as in memory, easy to test/evaluate DB
• PostgreSQL - as popular open source DB
• MySQL and MariaDB - as widely used and almost "the same" DBs, hence, same support