Support UUID data type for MySQL 8.0+ and MariaDB 10.7+ about umami HOT 3 OPEN

A quick warning about this, because it isn't totally accurate.

There are two issues :

• MySQL indeed supports UUID, but not as a data type, contrary to MariaDB.
  So moving from varchar to uuid is only possible with MariaDB.

• Even though a Prisma string field apparently works with a MariaDB UUID column,
  Prisma doesn't offer @db.Uuid attribute with it.
  It doesn't look good having a difference between schema and actual database,
  and this could lead to some issues, SQL may be incorrectly generated by Prisma, which should be manually tweaked.

varchar isn't probably the ideal solution, but I don't think there's an easy alternative at the moment.

from umami.

Unfortunately we only support 1 schema file per database. It is possible to detect the db version before the build-db step and target a different schema file / migration folder, but it will add more maintenance and support on our side. Ideally we just cut-off support for older MySQL / MariaDB versions, update the schema off of VARCHAR(36) and move forward.

from umami.

Agree, just moving forward and require proper versions of MySQL/MariaDB that support the UUID data type seems OK to me too.

I don't have very high traffic sites right now and the degradation using VARCHAR(36) was noticeable to the point we observed timeouts (i.e. when deleting a site or just asking for data), so I gave a try and manually converting to UUID all of the column IDs and references really worked like a charm.

Anyway I understand this could require some testing for the initial structure and migrations. I can try help with MariaDB and MySQL, drop me a message and I can try to help / test.

from umami.