Need advice about which tool to choose?Ask the StackShare community!

Google Cloud SQL

505
520
+ 1
46
Heroku Postgres

333
294
+ 1
38
Add tool

Google Cloud SQL vs Heroku Postgres: What are the differences?

What is Google Cloud SQL? Store and manage data using a fully-managed, relational MySQL database. MySQL databases deployed in the cloud without a fuss. Google Cloud Platform provides you with powerful databases that run fast, don’t run out of space and give your application the redundant, reliable storage it needs.

What is Heroku Postgres? Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL. Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.

Google Cloud SQL and Heroku Postgres are primarily classified as "SQL Database as a Service" and "PostgreSQL as a Service" tools respectively.

Some of the features offered by Google Cloud SQL are:

  • Familiar Infrastructure
  • Flexible Charging
  • Security, Availability, Durability

On the other hand, Heroku Postgres provides the following key features:

  • High Availability
  • Rollback
  • Dataclips

"Fully managed" is the top reason why over 12 developers like Google Cloud SQL, while over 27 developers mention "Easy to setup" as the leading cause for choosing Heroku Postgres.

Open Humans, PullReview, and Churn Buster are some of the popular companies that use Heroku Postgres, whereas Google Cloud SQL is used by Implisit, Policygenius, and OTOBANK. Heroku Postgres has a broader approval, being mentioned in 74 company stacks & 38 developers stacks; compared to Google Cloud SQL, which is listed in 71 company stacks and 28 developer stacks.

Advice on Google Cloud SQL and Heroku Postgres

Considering moving part of our PostgreSQL database infrastructure to the cloud, however, not quite sure between AWS, Heroku, Azure and Google cloud. Things to consider: The main reason is for backing up and centralize all our data in the cloud. With that in mind the main elements are: -Pricing for storage. -Small team. -No need for high throughput. -Support for docker swarm and Kubernetes.

See more
Replies (2)
Max Musing
Founder & CEO at BaseDash · | 1 upvotes · 29.9K views

DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.

See more
David Weinberg

Good balance between easy to manage, pricing, docs and features.

See more
Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More
Pros of Google Cloud SQL
Pros of Heroku Postgres
  • 13
    Fully managed
  • 10
    SQL
  • 10
    Backed by Google
  • 4
    Flexible
  • 3
    Automatic Software Patching
  • 3
    Replication across multiple zone by default
  • 3
    Encryption at rest and transit
  • 29
    Easy to setup
  • 3
    Follower databases
  • 3
    Dataclips for sharing queries
  • 3
    Extremely reliable

Sign up to add or upvote prosMake informed product decisions

Cons of Google Cloud SQL
Cons of Heroku Postgres
    Be the first to leave a con
    • 2
      Super expensive

    Sign up to add or upvote consMake informed product decisions

    What is Google Cloud SQL?

    MySQL databases deployed in the cloud without a fuss. Google Cloud Platform provides you with powerful databases that run fast, don’t run out of space and give your application the redundant, reliable storage it needs.

    What is Heroku Postgres?

    Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.

    Need advice about which tool to choose?Ask the StackShare community!

    What companies use Google Cloud SQL?
    What companies use Heroku Postgres?
    See which teams inside your own company are using Google Cloud SQL or Heroku Postgres.
    Sign up for Private StackShareLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Google Cloud SQL?
    What tools integrate with Heroku Postgres?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    Blog Posts

    GitHubPythonNode.js+47
    52
    70289
    GitHubPythonSlack+25
    7
    2949
    GitHubPythonDocker+24
    13
    16807
    What are some alternatives to Google Cloud SQL and Heroku Postgres?
    MySQL
    The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
    Apache Aurora
    Apache Aurora is a service scheduler that runs on top of Mesos, enabling you to run long-running services that take advantage of Mesos' scalability, fault-tolerance, and resource isolation.
    Google Cloud Datastore
    Use a managed, NoSQL, schemaless database for storing non-relational data. Cloud Datastore automatically scales as you need it and supports transactions as well as robust, SQL-like queries.
    Google Cloud Spanner
    It is a globally distributed database service that gives developers a production-ready storage solution. It provides key features such as global transactions, strongly consistent reads, and automatic multi-site replication and failover.
    PostgreSQL
    PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
    See all alternatives