1.34k views1.34k
CommentsAmazon DynamoDB vs Amazon RDS for PostgreSQL
Overview
Share your Stack
Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.
CLI (Node.js)
Manual
Advice on Amazon DynamoDB, Amazon RDS for PostgreSQL
akash
Aug 27, 2020
199k views199k
Comments
Lonnie
CEO - Co-founder US, Mexico Binational Tech Start-up Accelerator, Incubator at Framework Science
May 9, 2019
9.18k views9.18k
CommentsDetailed Comparison
With it , you can offload the administrative burden of operating and scaling a highly available distributed database cluster, while paying a low price for only what you use. | 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. |
Automated Storage Scaling – There is no limit to the amount of data you can store in a DynamoDB table, and the service automatically allocates more storage, as you store more data using the DynamoDB write APIs;Provisioned Throughput – When creating a table, simply specify how much request capacity you require. DynamoDB allocates dedicated resources to your table to meet your performance requirements, and automatically partitions data over a sufficient number of servers to meet your request capacity;Fully Distributed, Shared Nothing Architecture | Monitoring and Metrics –Amazon RDS provides Amazon CloudWatch metrics for you DB Instance deployments at no additional charge.;DB Event Notifications –Amazon RDS provides Amazon SNS notifications via email or SMS for your DB Instance deployments.;Automatic Software Patching – Amazon RDS will make sure that the PostgreSQL software powering your deployment stays up-to-date with the latest patches.;Automated Backups – Turned on by default, the automated backup feature of Amazon RDS enables point-in-time recovery for your DB Instance.;DB Snapshots – DB Snapshots are user-initiated backups of your DB Instance.;Pre-configured Parameters – Amazon RDS for PostgreSQL deployments are pre-configured with a sensible set of parameters and settings appropriate for the DB Instance class you have selected.;PostGIS;Language Extensions :PL/Perl, PL/pgSQL, PL/Tcl;Full Text Search Dictionaries;Advanced Data Types : HStore, JSON;Core PostgreSQL engine features |
Statistics | |
Stacks 4.0K | Stacks 813 |
Followers 3.2K | Followers 607 |
Votes 195 | Votes 40 |
Pros & Cons | |
Pros
Cons
| Pros
|
Integrations | |
| No integrations available | |
What are some alternatives to Amazon DynamoDB, Amazon RDS for PostgreSQL?
Azure Cosmos DB
Azure DocumentDB is a fully managed NoSQL database service built for fast and predictable performance, high availability, elastic scaling, global distribution, and ease of development.
Cloud Firestore
Cloud Firestore is a NoSQL document database that lets you easily store, sync, and query data for your mobile and web apps - at global scale.
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.
Cloudant
Cloudant’s distributed database as a service (DBaaS) allows developers of fast-growing web and mobile apps to focus on building and improving their products, instead of worrying about scaling and managing databases on their own.
Google Cloud Bigtable
Google Cloud Bigtable offers you a fast, fully managed, massively scalable NoSQL database service that's ideal for web, mobile, and Internet of Things applications requiring terabytes to petabytes of data. Unlike comparable market offerings, Cloud Bigtable doesn't require you to sacrifice speed, scale, or cost efficiency when your applications grow. Cloud Bigtable has been battle-tested at Google for more than 10 years—it's the database driving major applications such as Google Analytics and Gmail.
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.
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.
CloudBoost
CloudBoost.io is a database service for the “next web” - that not only does data-storage, but also search, real-time and a whole lot more which enables developers to build much richer apps with 50% less time saving them a ton of cost and helping them go to market much faster.
Firebase Realtime Database
It is a cloud-hosted NoSQL database that lets you store and sync data between your users in realtime. Data is synced across all clients in realtime, and remains available when your app goes offline.
restdb.io
RestDB is a NoSql document oriented database cloud service. Data is accessed as JSON objects via HTTPS. This gives great flexibility, easy system integration and future compatibility.
