Hacker News new | past | comments | ask | show | jobs | submit login

Fun improvement from my project a long time ago, uuid has 36 char and to save space, we created a shorten version by removing all the dash character in uuid. The result is 4 char could be removed, the field in MySQL table only needs 32 char.



The point is, a uuid contains 128 bits of data, so a varchar(32) is still somewhat excessive


Why varchar over char? The length is always the same.


Yeah, true. My bad. I'm used to calling everything TEXT.




Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: