uuid primary key as binary(16) in mysql

[rakesh410]

I want to use uuid as primary key but stored as binary 16 in mysql db. is there anyway to apply hook on insert and apply hex/unhex on the uuid with dashes removed?

[mde]

I'm not entirely clear what you're trying to do here. If it's essentially string keys, you could simply use string UUIDs, and generate your own via some auto-increment function, then save them as custom UUID strings on each item.

This is just a workaround, but I'm not entirely clearly why you would want to do this.

[rakesh410]

let me explain:

1. I want to use UUID as primary key
2. In geddy I created demo app using tutorial and observed that it created primary key as string and database store was varchar(255), where it was storing UUID as string.
3. I want change this database store to binary(16) where UUID will not be stored as string but as a 16bit HEX number - strip off "-" and open close braces from UUID and convert that string to binary coded hex number while storing, reverse should happen while retrieving primary key.

Is this possible?

Thanks

[der-On]

I did this before in PHP. It's tricky because UUIDs contain dashes which need to be removed before storage and added after read. It is indeed a lot faster and saves disk space.

Currently this is not possible but we welcome PRs.

[der-On]

You can take a look at how I did it in PHP: https://github.com/der-On/PHP-FluxAPI-Plugins-Core/blob/master/Storage/MySql.php#L805