Need advice about which tool to choose?Ask the StackShare community!
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
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.
DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.
Amazon RDS for PostgreSQLGood balance between easy to manage, pricing, docs and features.
Pros of ElephantSQL
- They suck10
- Monitoring1
- Geospatial support1
- Easy setup1
- Easy backup1
Pros of Heroku Postgres
- Easy to setup29
- Follower databases3
- Dataclips for sharing queries3
- Extremely reliable3
Sign up to add or upvote prosMake informed product decisions
Cons of ElephantSQL
Cons of Heroku Postgres
- Super expensive2
Sign up to add or upvote consMake informed product decisions
What is ElephantSQL?
What is Heroku Postgres?
Need advice about which tool to choose?Ask the StackShare community!
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 ElephantSQL?
Sign up to get full access to all the tool integrationsMake informed product decisions
Blog Posts
+47
+25
+24
+20