Feature request: MariaDB UUID type

[nkelemen18]

Hi all,

MariaDB has UUID data type as of 10.7: https://mariadb.com/kb/en/uuid-data-type/. Do you plan to make it possible to map System.Guid as UUID type?

Regards,
nk

[mguinness]

See mysql-net/MySqlConnector#1151.

[nkelemen18]

Reopening this issue. See the latest discussion on linked MySqlConnector issue:

See mysql-net/MySqlConnector#1151.

My observation is that using uuid instead of char(36) data type has advantages.

[nkelemen18]

@yukozh Could you check if it is possible to use uuid as data type for GUIDs?.

[jbdocuphase]

@nkelemen18 @yukozh
Any updates on this? Latest versions of MariaDb, UUID are better optimized for indexing vs. char(36)

[nkelemen18]

@lauxjpn Could you please share your thoughts on this discussion?

[jbdocuphase]

Following up on this. I asked MySqlConnector about it and was told it's something for Pomelo needs to address.

[jbdocuphase]

@nkelemen18 @lauxjpn @mguinness I need some direction here. I'm willing to help contribute on this effort but it's unclear where the responsibility lies as the puck has been passed around a few times. This ticket has been opened since 2022 and it's still unclear what the next steps are.

Thank you

[singatias]

Would be nice to have

[ninety7]

I've kind of resolved it on my own by mapping 'uuid' type columns to dotnet guid manually on dbcontext configuration and it works pretty well!

[jbdocuphase]

I've kind of resolved it on my own by mapping 'uuid' type columns to dotnet guid manually on dbcontext configuration and it works pretty well!

Are you doing code-first or database-first? I tried this in the past but ran into issues. Will update by version of Pomelo and give it another go.

[ninety7]

I started with scaffolding a mariadb database and then created migrations. I had to update the model mappings so the generated migrations would create the right schema