News for hackers. Stuff that matters.
Re:New UUID Formats by jeremyjh on Sunday June 12, 2022 @06:16PM (#31718791)
Sure you could encode it in Crockford's base-32 but if it isn't part of the standard then tools won't implement it natively, so you couldn't copy a key from a url and look it up in postgres without running it through a conversion function, for example.
Re:New UUID Formats by tpetry on Monday June 13, 2022 @08:05AM (#31724268)
You can write a custom data type in pure SQL for PostgreSQL which is just transforming a visible string to the more efficient uuid type. That‘s basically how the uuid type can be implemented: For storage it‘s binary(16) but all operations transform the value to the visible string you see all the time. It‘s a pretty powerfull feature.
Re:New UUID Formats by yencabulator on Monday June 13, 2022 @03:45PM (#31730750)
I was enthusiastic for a while but

https://www.postgresql.org/docs/current/sql-createtype.html

> (This restriction is made because an erroneous type definition could confuse or even crash the server.)

Uhh, what..

> Generally these functions have to be coded in C or another low-level language.

Oh, okay. That sounds like this not really doable with many hosted Postgres services out there.