Pomelo.EntityFrameworkCore.MySql icon indicating copy to clipboard operation
Pomelo.EntityFrameworkCore.MySql copied to clipboard

Published 20 hours ago • verified publisher icon PomeloFoundation

Feature request: MariaDB UUID type

Open nkelemen18 opened this issue 3 years ago • 11 comments

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

nkelemen18 avatar Oct 03 '22 23:10 nkelemen18

See https://github.com/mysql-net/MySqlConnector/issues/1151.

mguinness avatar Oct 03 '22 23:10 mguinness

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 avatar Aug 15 '23 14:08 nkelemen18

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

nkelemen18 avatar Aug 20 '23 22:08 nkelemen18

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

jbdocuphase avatar May 20 '24 16:05 jbdocuphase

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

nkelemen18 avatar May 21 '24 13:05 nkelemen18

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

jbdocuphase avatar Jun 28 '24 22:06 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

jbdocuphase avatar Jul 18 '24 23:07 jbdocuphase