=> SQL database
=> Open-source database it means we can do customization and get community support
=> Easy to manage large volumes of data
=> Allow creating custom data types, operators, events and function
=> Large community so you can solve you problem fast
=> Provide jsonb data type for store json data Review collected by and hosted on G2.com.
=> database is based on project and requirement so if your project is small then I suggest use MongoDB
=> Need the training to understand database functionality
=> Need more storage and computing power to execute query Review collected by and hosted on G2.com.
easy to use we can use it in our production environment, it provide very good features so that we can optimized our query and also data retrieval become easy also in PostgreSQL querys are easy to write, we frequently use it in our projects. Review collected by and hosted on G2.com.
what i don't like is, it is not distributed database, and some features are not supported Review collected by and hosted on G2.com.
-It has the ability to store NOSQL data as well such as JSON
-Well suited when data is transactional as well as informative
-Free to use
-Postgres's ORM is available For almost all major programming language
-Installation is very straightforward
-Easy to maintain compared to other SQL databases Review collected by and hosted on G2.com.
-Not as fast as MySQL
-Without ORM, Query writing can be tedious and slow
-As it supports JSON schema as well it can be difficult to manage at scale
-Horizontal scaling can be trickier to achieve Review collected by and hosted on G2.com.
What I like most about PostgreSQL is its open source. Being an open-source relational database, it also provides value to the customer and their users in terms of fast and internal precalculated libraries and functions that help developers and users retrieve data fastly without any hurdle.
Postgresql is also helping us with fast query execution and efficient use of memory. Review collected by and hosted on G2.com.
Being an open-source relational database, the area of improvement is its inability to handle large-volume database application support.
Another thing is its limited community or ecosystem compared to premium databases like oracle and SQL servers.
The query execution explanation plan is also not good in PostgreSQL.
Postgresql does not have any run-time debugger, so some time to hard to find the error's root cause. Review collected by and hosted on G2.com.
I have used this software for Blog Platform Management. It was very helpful & easy to manage data. It provide easier & userfriendly queries to all users. Review collected by and hosted on G2.com.
Integrating with framework it is very time consuming. Review collected by and hosted on G2.com.
The PostgreSQL relational database is a open source database system - which is free to use, easily configurable and carry overs all the basic SQL principles and Syntax. Review collected by and hosted on G2.com.
There is a downside of the PostgreSQL that it is not able to handle multiple idle connections, it loses the ability for new connections to reconnect. If that can be fixed, it's awesome. Review collected by and hosted on G2.com.
It is a open source application and allows to scale whenever needed. It is very fast and secure to manipulate data. Database creation, updation is very easy in PostgreSQL. Review collected by and hosted on G2.com.
Learning PostgreSQL is challenging in beginning because it is complex and documentation is not that much easy to understand. The documentation should have examples for reference. Review collected by and hosted on G2.com.
I have used Postgres SQL extensively for the past few years and it is few of cost effective scalable RDBMS that runs very smooth with web applications specially with Django backend. This RDBMS can be tuned for performance quickly and offers amazing support for custom functions.
This RDBMS can be scaled quickly and is available in cloud services like Amazon RDS which can make this database manageable. The error messages in the RDBMS is very clearly laid out and I just love the way it provides flexibility of using custom SQL workbenches. Review collected by and hosted on G2.com.
I have loved my experience with Postgres SQL and the user community for this RDBMS is amazing. I have faced issues in reading documentation for Postgres but online community has always helped in getting my issues resolved. Review collected by and hosted on G2.com.
Very reliable tool to use and easy to understand plus its consistent and also adapts to changing infrastructure in the market. Review collected by and hosted on G2.com.
The documentation is very dense which is nit easy to understand by beginners. Review collected by and hosted on G2.com.