Best open source relational database you can have
May 24, 2021

Best open source relational database you can have

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

PostgreSQL is one of the databases we use for our systems and products. Most of our IT systems run on PostgreSQL, such as issue tracker and wiki. We also use PostgreSQL to store analytic data which would then be fed to analytic and reporting tools to generate graphs and dashboards.
  • Supports and runs on most popular operating systems and environments.
  • Most cloud vendors support PostgreSQL.
  • Solid and reliable, PostgreSQL has been around for a very long time.
  • Has a huge online community that can help you with any questions and challenges.
  • Open source, so cost of initial ownership is much lower than Oracle, MS SQL Server.
  • Horizontal scaling can be difficult.
  • Has support for JSON type, but needs more work if compared to something like MongoDB.
  • SQL compliant.
  • ACID compliant.
  • Reliability and performance.
  • Open source means reduced initial startup cost.
  • Very reliable means we do not need to worry about data loss.
We evaluated both PostgreSQL and MySQL, two popular open source relational databases. While they are very similar in most areas, PostgreSQL's reliability and performance won us over, plus it has much better support from cloud vendors we also work with.

Do you think PostgreSQL delivers good value for the price?

Yes

Are you happy with PostgreSQL's feature set?

Yes

Did PostgreSQL live up to sales and marketing promises?

Yes

Did implementation of PostgreSQL go as expected?

Yes

Would you buy PostgreSQL again?

Yes

PostgreSQL is a phenomenal product that can satisfy most relational data needs. If you are in an environment where cost is a factor, or you are just starting with a project and needs to get up and running quickly, then PostgreSQL should be your go-to choice. It is robust, reliable, and has all the features you would need from a SQL compliant database, without all the additional baggage that comes with other more heavyweight alternatives.