Hacker News Reader

Comment by clhodapp | Hacker News Reader

I wish uuid-ossp was in there... Being able to generate type 4 and 5 UUIDs on the database side is extremely convenient, especially during migrations.

View on HN

    gen_random_uuid()

Exists in the pgcrypto extension.

Only does UUID 4, which should work for many applications.

It includes pgcrypto so you can use the new gen_random_uuid() from there to generate UUIDs.

For the record, uuid-ossp is a steaming pile and there's no reason to use it for anything on a modern Postgres install.

What exactly do you mean by this? Your comment is uninformative without some substance.

The code is pretty much unmaintained at this point, it's a pain in the ass to build, besides the v4 UUID generation function everything else in there is useless, and the v4 UUID generation function is 6x slower than the one in pgcrypto[1].

There's no reason to use it and incorporating it into projects just creates headaches down the road.

[1]: https://www.postgresql.org/message-id/flat/52CF07C2.3080101%...

I believe that type 5 (and I guess type 3) UUIDs both have legitimate use cases, especially when data migrations are involved. Both of these types are supported by uuid-ossp but not by pgcrypto.

Reply on news.ycombinator.com