Will Umami Continue Supporting MariaDB?

[rogue-ninja-creative]

On the website docs, MariaDB is not included in the list of compatible databases:

"Umami supports MySQL (minimum v8.0) and PostgreSQL (minimum v12.14) databases"

But here on the Github page, it is: "Umami supports MariaDB (minimum v10.5), MySQL (minimum v8.0) and PostgreSQL (minimum v12.14) databases."

Installing Umami with MariaDB 11.7.2 was a bit tricky due to issues with Prisma and the migration files. In particular, a migration file tries to use the BIN_TO_UUID function, which doesn't exist in MariaDB. There are several closed issues about this error.

Since mine was a fresh install, my workaround was to just generate the schema manually and bypass the migrations, but future migrations in new versions of Umami might cause similar issues. So, it does raise the question:

Is Umami moving away from supporting MariaDB?

[mikecao]

We may be moving away from MySQL entirely. It's a lot of work supporting multiple databases. Have you run Postgres before?

[rogue-ninja-creative]

That is good to know. I haven't used PostgreSQL before, but I'm in the middle of considering moving away from MongoDB and was thinking of MariaDB. Perhaps Postgres is a strong contender I should have considered.

Thank you for the reply!