Amazon RDS for PostgreSQL vs ElephantSQL vs Heroku Postgres

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

Amazon RDS for PostgreSQL

814
604
+ 1
40
ElephantSQL

15
86
+ 1
15
Heroku Postgres

486
314
+ 1
38
Advice on Amazon RDS for PostgreSQL, ElephantSQL, 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)
David Weinberg

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

See more
Max Musing
Founder & CEO at BaseDash · | 1 upvotes · 49.2K views

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

See more
Manage your open source components, licenses, and vulnerabilities
Learn More
Pros of Amazon RDS for PostgreSQL
Pros of ElephantSQL
Pros of Heroku Postgres
  • 25
    Easy setup, backup, monitoring
  • 13
    Geospatial support
  • 2
    Master-master replication using Multi-AZ instance
  • 11
    They suck
  • 1
    Monitoring
  • 1
    Geospatial support
  • 1
    Easy setup
  • 1
    Easy backup
  • 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 Amazon RDS for PostgreSQL
Cons of ElephantSQL
Cons of Heroku Postgres
    Be the first to leave a con
      Be the first to leave a con
      • 2
        Super expensive

      Sign up to add or upvote consMake informed product decisions

      No Stats

      What is Amazon RDS for PostgreSQL?

      Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and back-ups for disaster recovery. With just a few clicks in the AWS Management Console, you can deploy a PostgreSQL database with automatically configured database parameters for optimal performance. Amazon RDS for PostgreSQL database instances can be provisioned with either standard storage or Provisioned IOPS storage. Once provisioned, you can scale from 10GB to 3TB of storage and from 1,000 IOPS to 30,000 IOPS.

      What is ElephantSQL?

      ElephantSQL hosts PostgreSQL on Amazon EC2 in multiple regions and availability zones. The servers are continuously transferring the Write-Ahead-Log (the transaction log) to S3 for maximum reliability.

      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 Amazon RDS for PostgreSQL?
      What companies use ElephantSQL?
      What companies use Heroku Postgres?

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

      What tools integrate with Amazon RDS for PostgreSQL?
      What tools integrate with ElephantSQL?
      What tools integrate with Heroku Postgres?

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

      Blog Posts

      DockerAmazon EC2Scala+8
      6
      2779
      GitHubPythonReact+42
      49
      41012
      GitHubPythonNode.js+47
      55
      72908
      GitHubPythonSlack+25
      7
      3242
      GitHubPythonDocker+24
      13
      17098
      What are some alternatives to Amazon RDS for PostgreSQL, ElephantSQL, 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.
      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.
      MongoDB
      MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
      Redis
      Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker. Redis provides data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams.
      Amazon S3
      Amazon Simple Storage Service provides a fully redundant data storage infrastructure for storing and retrieving any amount of data, at any time, from anywhere on the web
      See all alternatives