News for hackers. Stuff that matters.

A comment on Unexpected downsides of UUID keys in PostgreSQL. Parent comment

Re:Unexpected downsides of UUID keys in PostgreSQL by lolinder on Thursday June 22, 2023 @01:57PM (#36436139)
ULIDs are byte-compatible with UUIDs, so the only thing Postgres's native support gives you over ULIDs is that Postgres can generate new UUIDs for you instead of having to do it in the application before insertion.
[ Parent | on HN ]
Re:Unexpected downsides of UUID keys in PostgreSQL by letitbeirie on Thursday June 22, 2023 @06:11PM (#36439819)
It also buys you that support in the driver libraries.

I ran into this last year - storing them as UUIDs works great, unless all of the drivers for the language you're using (Go, in my case) try to cast/validate those bytes as a UUID before you can access them.

[ Parent | on HN ]