back
232 comments
Your turn, Azure

https://feedback.azure.com/forums/217321-sql-database/sugges...

https://feedback.azure.com/forums/217321-sql-database/sugges...

https://feedback.azure.com/forums/170024-additional-services...

PS: managed MySQL is currently the most requested additional service on Azure:

https://feedback.azure.com/forums/170024-additional-services...

.. and managed Postgres + MySQL are currently the third most requested feature in relation to their managed DB offering

https://feedback.azure.com/forums/217321-sql-database/filter...

I really would not recommend Azure unless you are going for an all-Microsoft, all-the-time strategy. Their hosted SQL Server offerings have actually been really good, and IMO is one of the best parts of the platform.
I just met an azure representative in a event and they said managed mysql is in private beta right now. It will take them around 3 months to get it out if it. Even I'm waiting for it
While not Microsoft offerings, there are some options available: my company Aiven (https://aiven.io/postgresql) offers managed PostgreSQL service on Azure as well. ElephantSQL (https://www.elephantsql.com/) is an another provider with hosted Postgres on Azure.
Very exciting, but high availability, instance cloning, and read replicas are listed as "This functionality is not yet supported for PostgreSQL instances" in the docs. Seems like those need to be available before it's a realistic option for production workloads.
This was a tough call for the team: ship now for the folks that are okay with that, or wait until it's fully baked. They chose the former, which certainly means it's not a great idea for serious production load, but that's also true of it simply being in Beta. You won't see it go GA before it's really ready for production work (including replication, backups and so on) but I think it was a reasonable choice to get people started.

Disclosure: I work on Google Cloud (but not Cloud SQL).

(Ozgun from Citus)

As someone who interacts with PostgreSQL on-prem and cloud deployments frequently, I'm curious on the Hacker News community's thoughts on one question.

AWS has a fairly mature RDS Postgres offering. What would motivate you to use Google Cloud Postgres instead?

I've heard of four reasons from users: not on AWS, don't want to be locked into one vendor, cost, and better support. Do any of these reasons resonate with you or are there others?

> it's a realistic option for production workloads.

Surely this is only true for certain definitions of 'production workloads'?

Well it is only in a beta state
Cloud SQL for Postgres is launching today and will be available for all users early next week.

Source: Work on Cloud SQL.

Any public timeline on HA feature availability, or way to be an early adopter?
Is it wise to use Cloud SQL + GKE? Some say it is not wise to use Docker for DB
Has anyone seen documentation that it supports PostGIS?

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

This is excellent news - am currently evaluating options for cloud Postgres. Only wish they'd support a few more extensions - https://cloud.google.com/sql/docs/postgres/extensions - e.g. plv8 would be great https://github.com/plv8/plv8
One thing is really strange in this thread is that almost every opinion against Google's customer support are down voted heavily. Google advocates always say that GCP support is better. Of course they have to be better because they are the underdog in the cloud war. I can't buy the logic that GCP is Google but not that Google. What would happen if they could dominate?

Don't get me wrong. GCP as a product is really awesome. I've been using GCE and Datastore for a project and they just work. I just can't trust Google enough to bring all my works to their cloud.

I'm really excited about the future of GCP and that there is now a serious AWS competitor.
The killer for me is PITR (point in time recover). A few years ago a colleague triggered and UPDATE without WHERE and PITR saved our sorry asses (on MS SQLServer, a fair product despite my antipathy MS).

Postgres has it, but it is kind of a pain to setup correctly and I love RDS because I don't have to deal with the setup anymore.

Excited to see this, but holy shit is it unclear what expected costs could be. It seems like it might be on the cheap/affordable side of things, but it's not obvious. I almost prefer to just use Compose.io because at least the pricing is clear.
Is there a reason Google is so slow to compete with AWS? This seems like another example of where they're playing catch-up. Meanwhile, I'm blown away that Node is still just in Beta (with no SLA / deprecation guarantees) when Heroku and AWS have supported it for years.
The last piece of the puzzle for me to have a full stack alternative to AWS. Thanks Google!

Edit: not a complete end of the world, but it would be really nice (and completely easy/safe) to have the uuid-ossp extension available.

Yep.I now believe Google is serious about cloud.It is beyond me why it takes Google too long to do this.
Yes! We have been asking for this for a while now when asked for feedback about what we would value. Managed ElasticSearch is next on our wishlist.
Will it be available in the same private network as the rest of our GCE VMs? Last I checked, Google Cloud MySQL runs over the public network, which is a big pain in the ass for access control.
Huge news! This + GKE + the new improved GCE billing setup is killer for most shops.
Promising.

Is Google contributing anything back into Postgres codebase ?

They could have named something different for the product - Cloud SQL ? seriously.

Awesome, was the main service needed before being able to consider moving from AWS - let the cloud wars begin!
this is huge! I take my words back - RDS finally has a competitor.
Well, I guess I can try out Google Cloud finally
Does anyone have a good comparison between this, RDS, Aurora, Citus, Heroku PG and some of the other Postgres (and "Postgres-compatible") services?

With so many DBaaS tools available, I'd like to know the best options for things like pricing, availability, features, tooling, monitoring, etc...

What is the maximum disk space for this offering? Amazon's RDS peaks out at just 6TB currently.
Wait did this leak before the keynote announcement? :-) (I'm at Google Cloud NEXT right now).
Does anyone know if it supports PostGIS? I'm not seeing much on the page (on mobile).
This is definitely going to be very useful when it's fully fleshed out but be warned that this initial beta doesn't support Google-managed replication or HA (to say nothing of an SLA, of course).
This makes me seriously consider switching from heroku for my rails postgres app. Probably could cut my costs significantly.

Anyone have any comments or experiences with the Google app engine flex environment for ruby?

Because my first question was "What are the deviations from standard Postgres?":

https://cloud.google.com/sql/docs/features#differences-pg

It looks like there aren't many – you can't use SUPERUSER, and they enable extensions, options, and parameters one by one at request.

Awesome. Now, can you do the same for Elasticsearch ?
Any chance of seeing pipelinedb being supported?
I've been looking forward to this forever
Hopefully this pushes Microsoft to expand their offering. I'd love managed Postgres in Azure.
The day before I was about to migrate to RDS. Change of plans!
Does this use Vitess? Are those two competing products?
Extremely exciting, been waiting for this for a while
It would be awesome to see pglogical in the list of supported extensions, which can help to deal with replication for now.
5 GB database with 2 GB RAM for $132/month (tier D4)?

Seriously, who is this for? I have no idea - SSD VPS like this is about $10/mo ...

Does this support hstore and Json store?
Good news. More competition the better.
This is great news! Finally!
Fantastic news.
is there IOPS info somewhere?