Need advice about which tool to choose?Ask the StackShare community!
Advice on Amazon RDS for PostgreSQL, Azure Database for PostgreSQL, and Heroku Postgres
Jorge Perez
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.
Replies (2)
David Weinberg
Software Developer · | 1 upvotes · 48.3K views
Good balance between easy to manage, pricing, docs and features.
Max Musing
Founder & CEO at BaseDash · | 1 upvotes · 48.5K views
DigitalOcean's offering is pretty solid. Easy to scale, great UI, automatic daily backups, decent pricing.
Manage your open source components, licenses, and vulnerabilities
Learn MorePros of Amazon RDS for PostgreSQL
Pros of Azure Database for PostgreSQL
Pros of Heroku Postgres
Pros of Amazon RDS for PostgreSQL
- Easy setup, backup, monitoring25
- Geospatial support13
- Master-master replication using Multi-AZ instance2
Pros of Azure Database for PostgreSQL
Be the first to leave a pro
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 Amazon RDS for PostgreSQL
Cons of Azure Database for PostgreSQL
Cons of Heroku Postgres
Cons of Amazon RDS for PostgreSQL
Be the first to leave a con
Cons of Azure Database for PostgreSQL
Be the first to leave a con
Cons of Heroku Postgres
- Super expensive2
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 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.
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 Azure Database for PostgreSQL?
What companies use Heroku Postgres?
What companies use Azure Database for PostgreSQL?
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 Azure Database for PostgreSQL?
What tools integrate with Heroku Postgres?
What tools integrate with Amazon RDS for PostgreSQL?
What tools integrate with Azure Database for PostgreSQL?
What tools integrate with Heroku Postgres?
Sign up to get full access to all the tool integrationsMake informed product decisions
Blog Posts
+8 6
2760
+42 49
40929
+47 55
72789
+39 22
31760
+26 15
5427
+25 7
3223
+24 13
17082
+20 2
1007
What are some alternatives to Amazon RDS for PostgreSQL, Azure Database for PostgreSQL, 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