What users are saying about
50 Ratings
170 Ratings
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101
170 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.9 out of 101

Likelihood to Recommend

Amazon Aurora

Many places where Aurora is well suited:
  • If you are trying to build a serverless backend.
  • Amazon hosted relational database service (RDS). So we do not have to manage the database maintenance.
  • Backup and archival can be done to AWS S3, which is very convenient.
  • It provides high performance and scalability.
  • It's very secure. You could use AWS Key management service (KMS) to encrypt and store data on AWS Aurora.
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

Pros

Amazon Aurora

  • Aurora is a relational database as a service on AWS which is MySQL and Postgres compatible. So if you are looking for a serverless option which going through need to host and manage a database then Aurora as a service is great.
  • It is a simple and cost-effective open source database which is much cheaper than a normal database cost. Hence very efficient for microservices database where you do not need one very large centralized database but many small databases that are available and low latency.
  • Aurora provides high performance and low latency. Last year they also announced multi-master in the same region and read replicas in multiple regions. This is very convenient if you are trying to design and build a highly reliable application.
No photo available

PostgreSQL

  • Object relational database
  • Rich support of procedural languages like R, C, Python, Perl and PL/ PGSQL
  • Geo Spatial and JSON support
  • MVCC concurrency model gives less locking
Venkateswar Reddy Thatikonda profile photo

Cons

Amazon Aurora

  • The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
  • Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
  • Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.
Vasco Mendes profile photo

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.
Venkateswar Reddy Thatikonda profile photo

Likelihood to Renew

Amazon Aurora

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 1 answer
As a needed software for day to day development activities
Ojoswi Basu profile photo

Usability

Amazon Aurora

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 4 answers
It is open-source, easy to install/configure, provided more features and growing database solution. It has a good future. supporting redshift as it is the same family. Easy to manage both at one time.
Jacob Biguvu profile photo

Reliability and Availability

Amazon Aurora

No score
No answers yet
No answers on this topic

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.
Ojoswi Basu profile photo

Performance

Amazon Aurora

No score
No answers yet
No answers on this topic

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.
Ojoswi Basu profile photo

Support

Amazon Aurora

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 1 answer
Easy, quick, to the point support
Ojoswi Basu profile photo

Online Training

Amazon Aurora

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.
Ojoswi Basu profile photo

Implementation

Amazon Aurora

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.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

Amazon Aurora

While they use similar services depending on the use case but Amazon Aurora significantly reduced our costs with Datadog. Being able to leverage our S3 buckets and using Amazon Aurora has allowed us to retain logs to meet our up to six-year requirement of retention without using the inflated costs Datadog hot storage. We were able to reduce the retention down to 30 days and have all logs after 30 days automatically dump into S3
Jesse Bickel, MS - PMP profile photo

PostgreSQL

Compared to MySQL, it works well if you need to extend to your use caseCompared to Spark, it works better w.r.t development time in a central database settingLike Redis, it cannot be used for caching and quick access of non-structured data
Nitin Pasumarthy profile photo

Scalability

Amazon Aurora

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 8.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

Amazon Aurora

  • Amazon Aurora has significantly reduced our third-party logging software costs.
  • Amazon Aurora has significantly increased our ability to store logs long term with the peace of mind of being able to access and query the database with ease.
Jesse Bickel, MS - PMP profile photo

PostgreSQL

  • Saves money as it's open source
  • Liberal open source licensing
  • GreenPlum and Redshift were built on PostgreSQL.
Venkateswar Reddy Thatikonda profile photo

Pricing Details

Amazon Aurora

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

Add comparison