5 ms·

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

by zawerf 9y ago

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://cloud.google.com/sql/docs/postgres/extensions https://devcenter.heroku.com/articles/heroku-postgres-extensions-postgis-full-text-search https://devcenter.heroku.com/articles/heroku-postgres-extens...

Goopplesoft 9y ago
https://cloud.google.com/sql/docs/postgres/extensions 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.
- sitkack 9y ago
  Why is that? Systems are built for extension, to not allow it deprives one of essential qualities.
contrahax 9y ago
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.
- aserafini 9y ago
  This is what I expect from Google. They are not customer-centric and no-one is really prioritising or cares about customer feedback.
  - numbsafari 9y ago
    Still working for AMZN?
    - dastbe 9y ago
      It appears not since 2011, according to the information sources you would have looked through.
  - TurningCanadian 9y ago
    You clearly have never talked to GCP support. They're in a different league from AWS support.
    - manigandham 9y ago
      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/ https://cloud.google.com/support/role-based/
    - wikibob 9y ago
      As someone considering GCP, could you relate a story or two about GCP support’s technical competence specifically?
- napsterbr 9y ago
  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
  - vtainio 9y ago
    Aiven (https://aiven.io/postgresql https://aiven.io/postgresql) supports PostGIS on GCP if you are looking for an alternative choice.
- deesix 9y ago
  Disclaimer: I work on GCP Can you point me to the complaints? I will take a look.
  - joatmon-snoo 9y ago
    Found it: https://groups.google.com/forum/#!topic/google-cloud-sql-discuss/u8XSP2kF__A https://groups.google.com/forum/#!topic/google-cloud-sql-dis... Public issue tracker link: https://issuetracker.google.com/issues/37302950 https://issuetracker.google.com/issues/37302950
jerrysievert 9y ago
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.

by zawerf 9y ago

Goopplesoft 9y ago

https://cloud.google.com/sql/docs/postgres/extensions 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.

sitkack 9y ago
Why is that? Systems are built for extension, to not allow it deprives one of essential qualities.

contrahax 9y ago

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.

aserafini 9y ago
This is what I expect from Google. They are not customer-centric and no-one is really prioritising or cares about customer feedback.
- numbsafari 9y ago
  Still working for AMZN?
  - dastbe 9y ago
    It appears not since 2011, according to the information sources you would have looked through.
- TurningCanadian 9y ago
  You clearly have never talked to GCP support. They're in a different league from AWS support.
  - manigandham 9y ago
    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/ https://cloud.google.com/support/role-based/
  - wikibob 9y ago
    As someone considering GCP, could you relate a story or two about GCP support’s technical competence specifically?
napsterbr 9y ago
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
- vtainio 9y ago
  Aiven (https://aiven.io/postgresql https://aiven.io/postgresql) supports PostGIS on GCP if you are looking for an alternative choice.
deesix 9y ago
Disclaimer: I work on GCP Can you point me to the complaints? I will take a look.
- joatmon-snoo 9y ago
  Found it: https://groups.google.com/forum/#!topic/google-cloud-sql-discuss/u8XSP2kF__A https://groups.google.com/forum/#!topic/google-cloud-sql-dis... Public issue tracker link: https://issuetracker.google.com/issues/37302950 https://issuetracker.google.com/issues/37302950

jerrysievert 9y ago

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.