What users are saying about
44 Ratings
155 Ratings
44 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101
155 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

Add comparison

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

  • 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
  • Broad array of custom functionality/formulae built atop standard SQL statements
  • Transactional support for schema migrations
  • Great low-level performance tuning capabilities
  • Performant implementation of bulk merge (upsert)
David McCann profile photo

Cons

  • Without direct access to the instances it isn't possible to do a few things you'd be able to do if you were running your own database server, but this is rarely an issue
Andrew Raines 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

No score
No answers yet
No answers on this topic
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
PostgreSQL9.0
Based on 2 answers
If you are used to using Microsoft SQL Server, the tooling around PostgreSQL is not as good. Some new solutions by Devart and open source projects like DBeaver help, but it's just not as good. However, that really won't matter if you are just writing scripts and queries anyway.
Aaron Smith 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

Aurora MySQL 5.6 lacks many of the features of PostgreSQL, and even more recent versions of MySQL or MariaDB. You may be able to tolerate these deficiencies; simple OLTP use-cases will be served adequately. Like RDS and DynamoDB, Aurora is managed and integrates well with other AWS products. Amazon Aurora Serverless can be much less expensive than RDS, however.
No photo available
Despite being all open source options, what ended up making us choose PostgreSQL was the robustness of its core, which allows the great workflow that can support timely and efficient response to the demand and demand for resources. In the case of MongoDB, it is a non-relational handler, and the other options showed a lower performance than that offered by PostgreSQL.
Carlos Alberto Pedron Espinett profile photo

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

  • Aurora Serverless has allowed us to inexpensively implement best-practices for our microservices architecture.
  • Aurora is mostly managed; our engineers can focus on features instead of database administration.
  • Aurora is capable of high throughput. Speed is not our first priority, but we still benefit from it.
No photo available
  • I find that there is just positive ROI when using postgreSQL. SQL from one database to another and concepts are fairly universal. Most third party support PostgreSQL. There are many db reporting tools that support PostgreSQL as well.
  • negative ROI. none.
Louis Marceau 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