PostgreSQL is awesome opensource database with NoSQL support
May 16, 2021

PostgreSQL is awesome opensource database with NoSQL support

Amit Gupta | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

Postgre[SQL] is awesome, as it ha[s] lots of distinct things in itself. It is [a] highly extensible object relation database. We are using this for our current applications like Virtual Class and StudyShot purposes. We are storing larger pools of servers for virtual class purposes, which uses Postgre[SQL] as backend server. These applications are organization-wide products. Overall, Postgre[SQL] is superb in larger queries, where it is solving our day-to-day business problems in complex programs. Its performance and security both are satisfactory. Postgre[SQL] have features to extend which is a very good [quality].

It [is] platform independent, so we need not to worry about [having a] specific environment. Very good support for replication also relieves us from [the] data lost burden. Its cost for owning and maintaining [in] comparison to SQL server is low so it [suits us well].
  • Built in Json support which usually takes less space and eliminates us from re-parsing again in application and can be indexed
  • Support for large size data is awesome. Currently for loggings of analytics data we use it
  • Postgre[SQL] is more secure which we have experienced. MySQL got corrupted but it retained our data.
  • Its extension support is awesome. Through its inbuilt concurrent, we get faster results
  • Its management is not easy as expected
  • Data compression needs to be more better
  • Clustering and replication need to be improved
  • For JSON datatype, queries need to be better
  • Large data size support
  • JSON storing
  • Faster reliable processing of queries
  • Data consistency and security
  • Cost of running and maintenance is very low
  • License free of cost
  • Sufficient resources available to implement and practices
  • Object oriented approach
  • Json data type support
  • Timezone aware timestamps
  • Community driven software

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

Postgre[SQL] is well suited for various application and scenarios. Looking to its various distinct features, it is good for applications where a large data size is needed, and Analysis programs. In our case, we specifically utilized software for these too. Apart from this we saw that its distinct JSON support, custom data size, object oriented approach are too good.