Postgresql - OpenSource and objecr relation database with NOSQL(JSON type) support
November 14, 2017
Postgresql - OpenSource and objecr relation database with NOSQL(JSON type) support
Score 9 out of 10
Vetted Review
Verified User
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.
- MS SQL and MySQL
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.