ElephantSQL vs Heroku Postgres

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

ElephantSQL

15
78
+ 1
14
Heroku Postgres

339
309
+ 1
38
Add tool

ElephantSQL vs Heroku Postgres: What are the differences?

ElephantSQL: PostgreSQL as a Service. 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; 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.

ElephantSQL and Heroku Postgres can be primarily classified as "PostgreSQL as a Service" tools.

Some of the features offered by ElephantSQL are:

  • Continuous backup to S3
  • Automatic failover
  • 24/7 monitoring

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

  • High Availability
  • Rollback
  • Dataclips
Advice on 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)
Max Musing
Founder & CEO at BaseDash · | 1 upvotes · 38.6K 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 StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of ElephantSQL
Pros of Heroku Postgres
  • 10
    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 ElephantSQL
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 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 ElephantSQL?
    What companies use Heroku Postgres?
    See which teams inside your own company are using ElephantSQL or Heroku Postgres.
    Sign up for StackShare EnterpriseLearn More

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

    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

    GitHubPythonNode.js+47
    53
    71115
    GitHubPythonSlack+25
    7
    3027
    GitHubPythonDocker+24
    13
    16884
    What are some alternatives to ElephantSQL and Heroku Postgres?
    Heroku
    Heroku is a cloud application platform – a new way of building and deploying web apps. Heroku lets app developers spend 100% of their time on their application code, not managing servers, deployment, ongoing operations, or scaling.
    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.
    Google Cloud SQL for PostgreSQL
    With Cloud SQL for PostgreSQL, you can spend less time on your database operations and more time on your applications.
    Azure Database for PostgreSQL
    Azure Database for PostgreSQL provides a managed database service for app development and deployment that allows you to stand up a PostgreSQL database in minutes and scale on the fly – on the cloud you trust most.
    Database Labs
    We manage an optimized Postgres image. You focus on your core app, not on becoming a database administrator.
    See all alternatives