logoalt Hacker News

bismarkyesterday at 4:04 PM3 repliesview on HN

My biggest issue w/ UUIDv7 is how challenging they are to visually diff when looking at a list. Having some sort of visual translation layer in psql that would render them with the random bits first while maintaining the time sorting underneath would be a major UX boost...


Replies

phs2501yesterday at 7:46 PM

I just taught myself to look at the end of the UUID, rather than the beginning.

nine_kyesterday at 4:37 PM

Write a function that does that, use it in your queries. E.g. simple hex representation + string reversal should help. Or a reversed base64 representation for shorter output.