Storing of uuid

CrateDB SQL
1

Is there any best practices for storing uuid in CrateDb?
ie in mysql it is stored as binary(16) so it takes only 16 bytes to store instead of varchar(32)

2

We are currently looking into adding a dedicate UUID type [1]. Right now best practice would be to use TEXT or VARCHAR.

[1] Add a uuid type · Issue #11032 · crate/crate · GitHub

3

Do you have any ETA for adding dedicate UUID type?

4

Hi @kamcio181,

this issue is currently a candidate for 4.7 which would be the release after the next with a potential release date end of Q3. Note that this is maybe to change (compare Projects · crate/crate · GitHub for our rough plans for upcoming releases)

Code contributions are always welcome