PostgreSQL has rich feature sets and it's completely free!
Anonymous | TrustRadius Reviewer
November 07, 2019

PostgreSQL has rich feature sets and it's completely free!

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with PostgreSQL

We are using PostgreSQL as a database for our microservices application. Since microservice is light by nature, performance is never a problem.
We have a lot of microservices applications since PostgreSQL is free, we could use as many database instances as we need without massive cost increase.
The main thing that we like is PostgreSQL supports the JSON column and query which is really useful in our use case.
  • Support the JSON column and able to query by the JSON value.
  • Free to use.
  • Has fairly high performance.
  • Installation and configuration can be difficult for first time users.
  • Somewhat hard to upgrade/update, especially for major releases.
  • Less online documentation and resources available compared to MySQL or SQL Server.
  • Free to use, means that we can have as many database instances as we need without cost increase.
  • JSON support is very helpful and saves quite a lot of time querying and searching for data.
  • ACID compliance means with the right implementation and usage we can almost certainly trust the data.
PostgreSQL is rich in features and free to use which is perfect for our organization. PostgreSQL is our goto RDBMS if we want to create an application or services backend with the database if there's no specific requirement.
For example for the most important and largest database, we use SQL Server since we trust SQL Server and we might need dedicated support if things go wrong. Or if we are using third-party software that's only compatible with MySQL we are using MySQL, other than that we always use PostgreSQL by default.
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.

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 perfect if you are an experienced software engineer or database admin. Its wide feature set will be really useful the more you use it. It is also a cheap alternative to SQL Server since you need to pay a fairly pricey SQL Server license especially for business and enterprise, meanwhile, PostgreSQL is completely free to use.
The learning curve is a bit steep compared to MySQL and SQL Server, so might not be suited for a beginner.