Postgresql - OpenSource and objecr relation database with NOSQL(JSON type) support
Venkateswar Reddy Thatikonda | TrustRadius Reviewer
November 14, 2017

Postgresql - OpenSource and objecr relation database with NOSQL(JSON type) support

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with PostgreSQL

PostgreSQL is a good alternative in the open source database world. We were looking for an open source, reliable database for one of our products and selected PostgreSQL over MySQL due to its rich features. We used it as a transaction database.it has server side programming languages such as PL/Pg-SQL and have options to write functions in Python, Perl , Java, Ruby, C and R. With its latest releases it has support for JSON and is the only open source database with Geo spatial support.
  • 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
  • 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.
  • Saves money as it's open source
  • Liberal open source licensing
  • GreenPlum and Redshift were built on PostgreSQL.
I have used MS SQL and MySQL. Microsoft SQL Server is a good option for small applications in the commercial space. PostgreSQL can be more compared with Oracle in the feature set.
1. Open source and object relational
2. Great community
3. New versions for every six months and very stable
4. Support for JSON, XML and Geospatial