News for hackers. Stuff that matters.

A comment on Cloud SQL for PostgreSQL now generally available.

Re:Cloud SQL for PostgreSQL now generally available by zawerf on Wednesday April 18, 2018 @04:45PM (#16871021)
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...

[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by contrahax on Wednesday April 18, 2018 @05:34PM (#16871427)
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.
[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by napsterbr on Wednesday April 18, 2018 @07:23PM (#16872142)
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

[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by vtainio on Thursday April 19, 2018 @06:02AM (#16874603)
Aiven (https://aiven.io/postgresql) supports PostGIS on GCP if you are looking for an alternative choice.
[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by deesix on Wednesday April 18, 2018 @07:40PM (#16872228)
Disclaimer: I work on GCP

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

[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by joatmon-snoo on Thursday April 19, 2018 @12:16AM (#16873293)
Found it: https://groups.google.com/forum/#!topic/google-cloud-sql-dis...

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

[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by aserafini on Wednesday April 18, 2018 @06:09PM (#16871687)
This is what I expect from Google. They are not customer-centric and no-one is really prioritising or cares about customer feedback.
[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by TurningCanadian on Wednesday April 18, 2018 @10:03PM (#16872800)
You clearly have never talked to GCP support. They're in a different league from AWS support.
[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by manigandham on Wednesday April 18, 2018 @10:32PM (#16872915)
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/

[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by wikibob on Thursday April 19, 2018 @02:42AM (#16873828)
As someone considering GCP, could you relate a story or two about GCP support’s technical competence specifically?
[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by numbsafari on Wednesday April 18, 2018 @07:46PM (#16872255)
Still working for AMZN?
[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by dastbe on Wednesday April 18, 2018 @08:21PM (#16872411)
It appears not since 2011, according to the information sources you would have looked through.
[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by Goopplesoft on Wednesday April 18, 2018 @05:23PM (#16871326)
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.

[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by sitkack on Thursday April 19, 2018 @12:13AM (#16873284)
Why is that?

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

[ Parent | on HN ]
Re:Cloud SQL for PostgreSQL now generally available by jerrysievert on Wednesday April 18, 2018 @11:57PM (#16873228)
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.
[ Parent | on HN ]