3 ms·

Has anyone seen documentation that it supports PostGIS? Edit: Nevermind, it does! https://cloud.google.com/sql/docs/postgres/extensions https://cloud.google.co

Has anyone seen documentation that it supports PostGIS? Edit: Nevermind, it does! https://cloud.google.com/sql/docs/postgres/extensions https://cloud.google.com/sql/docs/postgres/extensions

masterleep 10y ago
What about citext? It's not on there.
- cridenour 10y ago
  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.
jerrysievert 10y ago
sadly, the only language extension is plpgsql, which is many less than aws, which happens to support plv8 as well.
clhodapp 10y ago
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.
- koolba 10y ago
  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.
  - shawn-butler 10y ago
    What exactly do you mean by this? Your comment is uninformative without some substance.
    - koolba 10y ago
      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%40ohmu.fi#52CF07C2.3080101@ohmu.fi https://www.postgresql.org/message-id/flat/52CF07C2.3080101%...
      - clhodapp 10y ago
        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.
- X-Istence 10y ago
  gen_random_uuid() Exists in the pgcrypto extension. Only does UUID 4, which should work for many applications.

Has anyone seen documentation that it supports PostGIS? Edit: Nevermind, it does! https://cloud.google.com/sql/docs/postgres/extensions https://cloud.google.com/sql/docs/postgres/extensions

masterleep 10y ago

What about citext? It's not on there.

cridenour 10y ago
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.

jerrysievert 10y ago

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

clhodapp 10y ago

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.

koolba 10y ago
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.
- shawn-butler 10y ago
  What exactly do you mean by this? Your comment is uninformative without some substance.
  - koolba 10y ago
    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%40ohmu.fi#52CF07C2.3080101@ohmu.fi https://www.postgresql.org/message-id/flat/52CF07C2.3080101%...
    - clhodapp 10y ago
      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.
X-Istence 10y ago
gen_random_uuid() Exists in the pgcrypto extension. Only does UUID 4, which should work for many applications.