Hacker News Reader

Comment by cridenour | Hacker News Reader

Has anyone seen documentation that it supports PostGIS?

Edit: Nevermind, it does! https://cloud.google.com/sql/docs/postgres/extensions

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.

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.

    gen_random_uuid()

Exists in the pgcrypto extension.

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

sadly, the only language extension is plpgsql, which is many less than aws, which happens to support plv8 as well.

What about citext? It's not on there.

I'm surprised to not see it (or other similarly popular data types) on there, but can't prove it doesn't work without trying it.

Reply on news.ycombinator.com