What users are saying about

Amazon DynamoDB

Top Rated
52 Ratings

PostgreSQL

146 Ratings

Amazon DynamoDB

Top Rated
52 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101

PostgreSQL

146 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Add comparison

Likelihood to Recommend

Amazon DynamoDB

DynamoDB is great for two cases. The first is for services that do not experience high loads or demand high availability. DynamoDB is inexpensive, and it provides great developer velocity. The second is for applications that demand high performance, have well-understood requirements, and a narrow range of queries.
No photo available

PostgreSQL

1. Open source and object relational2. Great community3. New versions for every six months and very stable4. Support for JSON, XML and Geospatial
Venkateswar Reddy Thatikonda profile photo

Feature Rating Comparison

NoSQL Databases

Amazon DynamoDB
7.9
PostgreSQL
Performance
Amazon DynamoDB
8.0
PostgreSQL
Availability
Amazon DynamoDB
8.4
PostgreSQL
Concurrency
Amazon DynamoDB
9.0
PostgreSQL
Security
Amazon DynamoDB
8.7
PostgreSQL
Scalability
Amazon DynamoDB
9.7
PostgreSQL
Data model flexibility
Amazon DynamoDB
4.0
PostgreSQL
Deployment model flexibility
Amazon DynamoDB
7.3
PostgreSQL

Pros

  • Security and managing infrastructure are the first reason why we selected DynamoDB. It takes quite an effort to set other NoSQL databases up in EC2 instances. Since DynamoDB offers single click table (Collection equivalent in MongoDB) setup, it's pragmatic to give this a first shot.
  • It provides decent querying capabilities with excellent documentation. If you have a JSON structure that's relatively flat (not more than 2 nested JSON objects) that needs querying, DynamoDB would be a great choice for you.
  • Neat CLI API that allows for easy setup in a local development environment would make the life of a developer a breeze. This again brings the benefit of having great documentation.
Anudeep Palanki profile photo
  • Relational database with great collection of GeoSpatial functions
  • Open source which enables researchers to tweak and extend
  • Good resource for learning internals of a database like Query Optimizer, Buffer Manager etc.
Nitin Pasumarthy profile photo

Cons

  • Query "language" leaves much to be desired. If you're coming from a database like MongoDB or SQL you'll find it extremely difficult to get data back out of the system without breaking the bank.
  • Because querying is poor, often the only way to get data out of arbitrary fields is by scanning the records – but the pricing model for this is cost prohibitive. This means you frequently need additional architecture to keep track of where data is stored in the hash table. While this is an issue for lots of NoSQL database, DynamoDB is probably the worst offender I've used to date because of the pricing model.
  • Amazon does offer a local version of DynamoDB you can run in development, but its an extremely clunky and very hard to integrate into any kind of continuous integration.
Justin Schroeder profile photo
  • Some of the custom SQL functions thatPostgreSQL provides could be optimized. Specifically I've seen that the "is contained within" operator for inet columns is slow to the point of being unusable in bulk (e.g. as a join criteria).
David McCann profile photo

Likelihood to Renew

Amazon DynamoDB6.9
Based on 13 answers
I wouldn't stay with the product, but may simply because I have no other choice. The reason for keeping it will depend on if we are given time by management to go to another solution (back to an SQL database) or the purchase of an ETL tool.
No photo available
PostgreSQL9.0
Based on 1 answer
As a needed software for day to day development activities
Ojoswi Basu profile photo

Usability

No score
No answers yet
No answers on this topic
PostgreSQL8.0
Based on 1 answer
There are a few areas of improvement
Ojoswi Basu profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
PostgreSQL9.0
Based on 1 answer
PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.
Ojoswi Basu profile photo

Performance

No score
No answers yet
No answers on this topic
PostgreSQL7.0
Based on 1 answer
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
Ojoswi Basu profile photo

Support

No score
No answers yet
No answers on this topic
PostgreSQL9.0
Based on 1 answer
Easy, quick, to the point support
Ojoswi Basu profile photo

Online Training

No answers on this topic
The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
Ojoswi Basu profile photo

Implementation

No score
No answers yet
No answers on this topic
PostgreSQL9.0
Based on 1 answer
The online documentation of the PostgreSQL product is elaborate and takes users step by step.
Ojoswi Basu profile photo

Alternatives Considered

Richard Rout profile photo
MySQL is a popular open-source alternative to PostgreSQL, but in my experience it lacks the robustness, durability, and flexibility of PostgreSQL. It has also changed hands frequently, so support isn't the greatest. MongoDB and other NoSQL databases are helpful in certain programming environments and for certain use cases, but sometimes you just need a really robust relational database.
No photo available

Scalability

No score
No answers yet
No answers on this topic
PostgreSQL8.0
Based on 1 answer
The DB is reliable, scalable, easy to use and resolves most DB needs
Ojoswi Basu profile photo

Return on Investment

  • Scalability out of the box
  • No server maintenance
  • Infrastructure comes for "free"
Richard Rout profile photo
  • PostgreSQL's speed is a massive boon to our environment: we can query the email we load in, and retrieve results almost immediately.
Benjamin Albrecht profile photo

Pricing Details

Amazon DynamoDB

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

PostgreSQL

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details