PostgreSQL has been developed for a long time, so it probably has the most functionality in the database market.
It is open-source, so its development will keep growing rapidly.
It is free.
It solves all of the problems that a relational database would solve, just like MySQL or Microsoft SQL Server, but is cost-effective and has similar performance. Review collected by and hosted on G2.com.
The graphical tooling isn't as good as some of the tools provided by Microsoft or Oracle.
Can be hard to figure out problems unless you know SQL very well.
PostgreSQL does not allow to execute batch of statements. Review collected by and hosted on G2.com.
The features which i like the most are :
User-defined types , table inheritance ,sophisticated locking mechanism and many more.
Fetching data and modifying it is very easy with postgres.
Best part is the high speed. Review collected by and hosted on G2.com.
Does not support the entire ANSI SQL 92' standard, much less the ANSI SQL 99' standard. Review collected by and hosted on G2.com.
Free database manager, with only download and install you can have the world of databases in full, with the best options of any proprietary driver, it is easy to install especially in free operating systems, it is ideal for database relational data, in terms of support, the best ally is the community of people who help others through forums, it is compatible with several graphic tools if they do not like to use the console, configuring a cluster is super simple and on the Internet the information works wonderfully with large databases. Review collected by and hosted on G2.com.
If you use postgres by console and not with any graphical tool such as pgadmin or dbeaver you must have intermediate knowledge, you may notice some slowness in massive insertions but this is related to the good design of the database Review collected by and hosted on G2.com.
Database with brilliant highlights to store information, incorporation with numerous applications created in various dialects of application advancement, similarity with Windows working frameworks, Linux, and so on. Simplicity of reconciliation with ETL arrangements, to store information stockrooms to communicate with business insight programming, permits replication of information with streamig replication, the accessibility of operational progression through the usage of pgpool, doubles to perform reinforcement and recuperation forms , execution of WAL, plausibility of executing auto vacuum to keep the objects of the database clean, variant updates of the postgresql SMBD, are simple and applications are not influenced. Review collected by and hosted on G2.com.
PostgreSQL question sentence structure for some mind boggling inquiries like array,string capacities and case administrator are isn't anything but difficult to compose . Establishment and setup of PostgreSQL isn't as simple as MySQL. Documentation isn't in the same class as MySQL and it is bit more diligently to google query items. Review collected by and hosted on G2.com.
1. Free code database manager, which is not used for licensing.
2. Easy to install and configure in any operating system.
3. Ideal for relational databases.
4. It has a large community in which you can share doubts.
5. It is stable and reliable, scalable and secure with the correct user management.
6. Can work with small and large databases.
7. Handles the SQL language. Review collected by and hosted on G2.com.
For some, not having support online or with an official help center can be a big disadvantage Review collected by and hosted on G2.com.
PostgreSQL offering is way above the one of competitors like Oracle, MySQL or Microsoft's SQL Server Review collected by and hosted on G2.com.
Major version upgrade process requires downtime. Most other databases avoid this painful process. Review collected by and hosted on G2.com.
Open source, lots of data types (like arrays and queryable JSON), lots of support in the community like Docker Hub, lots of examples online to reference, many managed services available form various cloud providers. Review collected by and hosted on G2.com.
Bad free tooling - pgAdmin4 is very awkward and slow to use. Review collected by and hosted on G2.com.
Open-source relational database management system and easier to handle and simple database architecture compare to other database base engine. It also supports NoSQL features. It's also easier to implement clustering and replication of the database, and migration to the cloud. Review collected by and hosted on G2.com.
Table Indexing, A found it bit complicated compared to Oracle and MS SQL Review collected by and hosted on G2.com.