What users are saying about
Amazon DynamoDB
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
92 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.5 out of 101
Based on 92 reviews and ratings
196 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 9 out of 101
Based on 196 reviews and ratings
Likelihood to Recommend
Amazon DynamoDB
It is ideal for those projects where you need to store a large amount of data, but you do not know how many will be so you need the database to increase its storage capacity together with the number of users, without having to spend extra money, it also has a great potential thanks to the fast connection it offers, so the data travels at high speed, and this speeds up the performance of the applications, excellent for projects where non-relational databases are used and what matters is to store large quantities of information and use them at high speed.
Software Developer
Globalsoft SolutionsComputer Software, 51-200 employees
PostgreSQL
Postgres is useful for perhaps 99% of apps that simply need to store user data somewhere and make it quickly retrievable at some later time. If you want to do full-text dynamic JSON searches (e.g. you are building a search engine), perhaps one of the NoSQL databases will serve you better. But regardless, you will probably need to store user data, even if you are building a search engine and storing it in Postgres (or a similar relational database) is much simpler. Postgres is also really good for work in industries where you get audited regularly (e.g. legal or financial) and cannot ever corrupt or lose user data, and that is because Postgres is fully ACID compliant, meaning if Postgres receives an update query, it will ALWAYS execute it even if lightning strikes the server.

Verified User
Engineer in Engineering
Internet Company, 201-500 employeesFeature Rating Comparison
NoSQL Databases
Amazon DynamoDB
8.6
PostgreSQL
—
Performance
Amazon DynamoDB
9.1
PostgreSQL
—
Availability
Amazon DynamoDB
9.4
PostgreSQL
—
Concurrency
Amazon DynamoDB
9.0
PostgreSQL
—
Security
Amazon DynamoDB
9.2
PostgreSQL
—
Scalability
Amazon DynamoDB
9.6
PostgreSQL
—
Data model flexibility
Amazon DynamoDB
6.7
PostgreSQL
—
Deployment model flexibility
Amazon DynamoDB
7.4
PostgreSQL
—
Pros
Amazon DynamoDB
- It's very easy to get started, creating a table with a partition/sort key and you're on your way.
- You can scale up and down your read/write IO as needed.
- You can store structured and unstructured data.
- It works great with Web Development as it's JSON based.
Founder, Owner
CodeLinguists LLCComputer Software, 1-10 employees
PostgreSQL
- Flexibility and Unicode compliance combined with nearly full SQL features support makes PostgreSQL an ideal tool to conducting complex data analyses
- Ease of administering PostgreSQL, SSL, SSO support make it possible to operate a very private and secure data repository
- Programmability of PostgreSQL is superb. Multiple standard programming languages are supported, PL/SQL flavour of programming is possible
- PostgreSQL runs on any platform
- Replication, high availability are some of the enterprise features that anyone can implement on its own
- Free, relatively mature for everyday use client tools
- Most languages have native drivers
- Superb support for JSON makes it not stop by thinking of NoSQL
Senior Data Platform Consultant
SermoHealth, Wellness and Fitness, 51-200 employees
Cons
Amazon DynamoDB
- Complex searching (no support for case-insensitive or full-text search).
- Only supports up to two-key indexes.
- Requires choosing the indexes up-front when doing searches.
- Does not have an SQL compatible query front-end.
- No join-table support (requires putting all data into one table).
VP of Technology
NewstexComputer Software, 1-10 employees
PostgreSQL
- Deployment gets difficult for folks who are habituated with commercial databases.
- We cannot write our own database engine unlike MySQL.
- PostgreSQL do not allow us to execute batch of statement. we have to embed it in a function to achieve this.
Senior Software Engineer
GGK TechHospital & Health Care, 501-1000 employees
Likelihood to Renew
Amazon DynamoDB
Amazon DynamoDB 9.0
Based on 31 answers
We will most likely continue to use DynamoDB for certain use-cases. If we stopped using DynamoDB as often, it would likely be because we started using Aurora Serverless more. Aurora Serverless may offer similar availability, management and cost benefits while allowing developers to use their MySQL tools and experience.

Verified User
Engineer in Engineering
Research Company, 11-50 employeesPostgreSQL
PostgreSQL 9.0
Based on 1 answer
As a needed software for day to day development activities
Sr. Tableau Solution Consultant
PointClickCareComputer Software, 501-1000 employees
Usability
PostgreSQL
PostgreSQL 9.0
Based on 6 answers
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.

Verified User
Engineer in Engineering
Information Technology and Services Company, 10,001+ employeesReliability and Availability
PostgreSQL
PostgreSQL 9.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.
Sr. Tableau Solution Consultant
PointClickCareComputer Software, 501-1000 employees
Performance
PostgreSQL
PostgreSQL 7.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.
Sr. Tableau Solution Consultant
PointClickCareComputer Software, 501-1000 employees
Support
PostgreSQL
PostgreSQL 8.7
Based on 4 answers
Its a really great product that has rich features which are well suited for our needs. It also has a NoSQL option which could be useful in some cases. And most importantly it's free to use which is always great.There's still room for improvement though, for example, the installation and upgrade process could be made easier, online resources could be improved as well.

Verified User
Engineer in Information Technology
Professional Training & Coaching Company, 11-50 employeesOnline Training
Amazon DynamoDB
No answers on this topic
PostgreSQL
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.
Sr. Tableau Solution Consultant
PointClickCareComputer Software, 501-1000 employees
Implementation
PostgreSQL
PostgreSQL 9.0
Based on 1 answer
The online documentation of the PostgreSQL product is elaborate and takes users step by step.
Sr. Tableau Solution Consultant
PointClickCareComputer Software, 501-1000 employees
Alternatives Considered
Amazon DynamoDB
We evaluated using MongoDB or Amazon DyanmoDB. For us, the biggest advantage is that there's no maintenance cost for Amazon DynamoDB. Mongo gets complicated when you setup sharding. With Amazon DynamoDB, it's literally a push of button to increase throughput. This saves time and money on DevOps resources.

Verified User
Engineer in Engineering
Computer Software Company, 11-50 employeesPostgreSQL
Research Assistant
AppleResearch, 5001-10,000 employees
Scalability
PostgreSQL
PostgreSQL 8.0
Based on 1 answer
The DB is reliable, scalable, easy to use and resolves most DB needs
Sr. Tableau Solution Consultant
PointClickCareComputer Software, 501-1000 employees
Return on Investment
Amazon DynamoDB
- Since the Amazon manages the instance, the amount of time a developer needs to spend configuring the database is less. For comparison, if we were to manage the same instance manually, we need to set up EC2 instance, install the DB, setup backup scripts, track backup failures, which is a great overhead for the dev. Using DynamoDB this overhead is reduced and hence having a great ROI.
- Great documentation and easy setup makes an easy learning curve to transition to DynamoDB. Only caveat is as with any database, the data structure should be thoroughly analyzed for types of querying because there are limitations with the DynamoDB API.
- Ties very well with rest of the Amazon eco system. Having rest of the applications in Amazon allows managing the application security a breeze.
Application Developer
Monsanto CompanyFarming, 10,001+ employees
PostgreSQL
- By pushing a lot of logic into database views and triggers, PostgreSQL provides the ability to write much slimmer and more maintainable controller code, reducing development costs.
- PostgreSQL's upsert capabilities enabled us to go to scale much more easily and quickly, allowing us to increase our number of customers.
Senior Software Engineer
Fast OrientationComputer & Network Security, 11-50 employees
Pricing Details
Amazon DynamoDB
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
PostgreSQL
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No