Amazon DynamoDBย vsย Amazon RDS for PostgreSQL

Get Advice Icon

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

Amazon DynamoDB
Amazon DynamoDB

1.8K
1.2K
+ 1
163
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL

455
223
+ 1
37
Add tool

Amazon DynamoDB vs Amazon RDS for PostgreSQL: What are the differences?

Developers describe Amazon DynamoDB as "Fully managed NoSQL database service". All data items are stored on Solid State Drives (SSDs), and are replicated across 3 Availability Zones for high availability and durability. With DynamoDB, 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. On the other hand, Amazon RDS for PostgreSQL is detailed as "* Set up, operate, and scale PostgreSQL deployments in the cloud*". 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.

Amazon DynamoDB can be classified as a tool in the "NoSQL Database as a Service" category, while Amazon RDS for PostgreSQL is grouped under "PostgreSQL as a Service".

Some of the features offered by Amazon DynamoDB are:

  • 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. If your throughput requirements change, simply update your table's request capacity using the AWS Management Console or the Amazon DynamoDB APIs. You are still able to achieve your prior throughput levels while scaling is underway.
  • Fully Distributed, Shared Nothing Architecture โ€“ Amazon DynamoDB scales horizontally and can seamlessly scale a single table over hundreds of servers.

On the other hand, Amazon RDS for PostgreSQL provides the following key features:

  • 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.

"Predictable performance and cost" is the top reason why over 53 developers like Amazon DynamoDB, while over 22 developers mention "Easy setup, backup, monitoring" as the leading cause for choosing Amazon RDS for PostgreSQL.

Lyft, New Relic, and Sellsuki are some of the popular companies that use Amazon DynamoDB, whereas Amazon RDS for PostgreSQL is used by Instacart, Tictail, and DSTLD. Amazon DynamoDB has a broader approval, being mentioned in 429 company stacks & 173 developers stacks; compared to Amazon RDS for PostgreSQL, which is listed in 164 company stacks and 27 developer stacks.

No Stats
- No public GitHub repository available -
- No public GitHub repository available -

What is Amazon DynamoDB?

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.

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.
Get Advice Icon

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

Why do developers choose Amazon DynamoDB?
Why do developers choose Amazon RDS for PostgreSQL?

Sign up to add, upvote and see more prosMake informed product decisions

    Be the first to leave a con
    What companies use Amazon DynamoDB?
    What companies use Amazon RDS for PostgreSQL?

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

    What tools integrate with Amazon DynamoDB?
    What tools integrate with Amazon RDS for PostgreSQL?

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

    What are some alternatives to Amazon DynamoDB and Amazon RDS for PostgreSQL?
    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.
    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.
    Amazon SimpleDB
    Developers simply store and query data items via web services requests and Amazon SimpleDB does the rest. Behind the scenes, Amazon SimpleDB creates and manages multiple geographically distributed replicas of your data automatically to enable high availability and data durability. Amazon SimpleDB provides a simple web services interface to create and store multiple data sets, query your data easily, and return the results. Your data is automatically indexed, making it easy to quickly find the information that you need. There is no need to pre-define a schema or change a schema if new data is added later. And scale-out is as simple as creating new domains, rather than building out new servers.
    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.
    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
    Decisions about Amazon DynamoDB and Amazon RDS for PostgreSQL
    FWScience
    FWScience
    | 4 upvotes ยท 5K views
    atFramework ScienceFramework Science
    Amazon DynamoDB
    Amazon DynamoDB
    Amazon RDS for PostgreSQL
    Amazon RDS for PostgreSQL

    We use Amazon RDS for PostgreSQL because RDS and Amazon DynamoDB are two distinct database systems. DynamoDB is NoSQL DB whereas RDS is a relational database on the cloud. The pricing will mainly differ in the type of application you are using and your requirements. For some applications, both DynamoDB and RDS, can serve well, for some it might not. I do not think DynamoDB is cheaper. Right now we are helping Companies in Silicon Valley and in Southern California go SERVERLESS - drastically lowering costs if you are interested in hearing how we go about it.

    See more
    Fรกbio Augusto Falavinha
    Fรกbio Augusto Falavinha
    Amazon RDS for PostgreSQL
    Amazon RDS for PostgreSQL
    Amazon DynamoDB
    Amazon DynamoDB
    PostgreSQL
    PostgreSQL

    Amazon RDS for PostgreSQL or Amazon DynamoDB? If you need to follow RDBS concepts choose Amazon RDS (PostgreSQL). This choice will guarantee a stable relational database with a great support for years from PostgreSQL Global Development Group. But, you need a great scalable NoSQL database. You can use Amazon DynamoDB. The most important thing about this is that you can use RESTful HTTP API to access data.

    See more
    Doru Mihai
    Doru Mihai
    Solution Architect ยท | 4 upvotes ยท 455 views
    Amazon DynamoDB
    Amazon DynamoDB

    I use Amazon DynamoDB because it integrates seamlessly with other AWS SaaS solutions and if cost is the primary concern early on, then this will be a better choice when compared to AWS RDS or any other solution that requires the creation of a HA cluster of IaaS components that will cost money just for being there, the costs not being influenced primarily by usage.

    See more
    Amazon EC2
    Amazon EC2
    PostgreSQL
    PostgreSQL
    Amazon EBS
    Amazon EBS
    Amazon RDS for PostgreSQL
    Amazon RDS for PostgreSQL
    Heroku Postgres
    Heroku Postgres
    Amazon RDS
    Amazon RDS

    I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.

    Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...

    See more
    Interest over time
    Reviews of Amazon DynamoDB and Amazon RDS for PostgreSQL
    No reviews found
    How developers use Amazon DynamoDB and Amazon RDS for PostgreSQL
    Avatar of Karma
    Karma uses Amazon DynamoDBAmazon DynamoDB

    For most of the stuff we use MySQL. We just use Amazon RDS. But for some stuff we use Amazon DynamoDB. We love DynamoDB. It's amazing. We store usage data in there, for example. I think we have close to seven or eight hundred million records in there and it's scaled like you don't even notice it. You never notice any performance degradation whatsoever. It's insane, and the last time I checked we were paying $150 bucks for that.

    Avatar of Volkan ร–zรงelik
    Volkan ร–zรงelik uses Amazon DynamoDBAmazon DynamoDB

    zerotoherojs.com โ€™s userbase, and course details are stored in DynamoDB tables.

    The good thing about AWS DynamoDB is: For the amount of traffic that I have, it is free. It is highly-scalable, it is managed by Amazon, and it is pretty fast.

    It is, again, one less thing to worry about (when compared to managing your own MongoDB elsewhere).

    Avatar of CloudRepo
    CloudRepo uses Amazon DynamoDBAmazon DynamoDB

    We store customer metadata in DynamoDB. We decided to use Amazon DynamoDB because it was a fully managed, highly available solution. We didn't want to operate our own SQL server and we wanted to ensure that we built CloudRepo on high availability components so that we could pass that benefit back to our customers.

    Avatar of nrise
    nrise uses Amazon DynamoDBAmazon DynamoDB

    ๋ช‡๋ช‡ ๋กœ๊ทธ๋Š” ํ˜„์žฌ AWS DynamoDB ์— ๊ธฐ๋ก๋˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค. ๊ฐœ์„ ์„ ํ†ตํ•ด mongodb ๋กœ ์˜ฎ๊ธธ ๊ณ„ํš์„ ํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค. ์•„์ฃผ ๊ฐ„๋‹จํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ์Œ“๋Š” ์šฉ๋„๋กœ๋Š” ๋‚˜์˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๋‹ค๋งŒ, ์ฟผ๋ฆฌ๊ฐ€ ์•„์ฃผ ์ œํ•œ์ ์ž…๋‹ˆ๋‹ค. ์‚ฌ์šฉํ•˜๊ธฐ ์ „์— ๋ฐ˜๋“œ์‹œ DynamoDB ์˜ ์ŠคํŽ™์„ ํ™•์ธํ•  ํ•„์š”๊ฐ€ ์žˆ์Šต๋‹ˆ๋‹ค.

    Avatar of HyperTrack
    HyperTrack uses Amazon DynamoDBAmazon DynamoDB

    To store device health records as it allows super fast writes and range queries.

    Avatar of Mark Walle
    Mark Walle uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

    Using PostGIS to serve GeoJSON data for the Leaflet front-end.

    Avatar of Tinkhaven
    Tinkhaven uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

    Main relational DB engine

    Avatar of Solcast
    Solcast uses Amazon RDS for PostgreSQLAmazon RDS for PostgreSQL

    Store and query data

    How much does Amazon DynamoDB cost?
    How much does Amazon RDS for PostgreSQL cost?
    Pricing unavailable