Amazon DynamoDB vs PostgreSQL

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

Read full review

• 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

Read full review

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

Read full review

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

Read full review

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

Read full review

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

Read full review