Hacker News Reader

Hacker News

Comment by zawerf | Hacker News Reader

Full thread

zawerf

How do you deal with custom extensions (for example plv8)?

I started off with heroku and they don't support the same subset:

https://cloud.google.com/sql/docs/postgres/extensions

https://devcenter.heroku.com/articles/heroku-postgres-extens...

View on HN

They don't have a great story around extensions - the ones they do have are unsupported/buggy. For example, PostGIS is missing "ST_FromGeoJSON" because it was compiled with the wrong flag - and has been this way for over a year despite hundreds of user complaints.

This is what I expect from Google. They are not customer-centric and no-one is really prioritising or cares about customer feedback.

Still working for AMZN?

It appears not since 2011, according to the information sources you would have looked through.

You clearly have never talked to GCP support. They're in a different league from AWS support.

They're all the same quality. Sometimes great, sometimes terrible, but will get the job done as long as you put in the effort. Also bigger customers will obviously get more.

GCP does win on pricing now with role-based support that is a flat rate per user: https://cloud.google.com/support/role-based/

As someone considering GCP, could you relate a story or two about GCP support’s technical competence specifically?

As someone who was migrating from on-premises to gcp, and who needs extensive postgis support, this information is a deal breaker for me. Is there any place I can find more information about postgis and other extensions status? Are you aware of any other bug related to postgis?

Thanks a lot for the information

Aiven (https://aiven.io/postgresql) supports PostGIS on GCP if you are looking for an alternative choice.

Disclaimer: I work on GCP

Can you point me to the complaints? I will take a look.

Found it: https://groups.google.com/forum/#!topic/google-cloud-sql-dis...

Public issue tracker link: https://issuetracker.google.com/issues/37302950

https://cloud.google.com/sql/docs/postgres/extensions

Looks like a preset list of extensions. I'd assume custom extensions would be very difficult to support in managed postgres.

Why is that?

Systems are built for extension, to not allow it deprives one of essential qualities.

at the least, they were waiting for timeouts to appear in plv8, which came in at 2.3.1 - I do not know the current status of it being brought into cloud sql though.

Reply on news.ycombinator.com