PostgreSQL Reviews

It is free although there are some paid options that include support and special configurations. It is very stable, I have not had any critical situations like data loss. As a ASP.NET developer, it integrates easy using ADO.NET Data Providers for which there are many choices. Concurrency control is included which is very useful for data integrity. Versions for Linux, Mac, Solaris and BSD are available which increases the integration power. A huge number of third party add-ons (paid and free) can be found. PostgreSQL is being continuously improving, there is a well defined plan of maintenance and new versions are coming out regularly.

I have not found anything against this DMBS product. I have accomplished all of my goals successfully.

in general is a good database manager like MySQL you have many functions and one, in particular, the notifications, you can send a notify and it's like a broadcast message, useful for interaction with the backend

the way how to backup and restore is sometimes complicated, we tried to automatized and sometimes works others not, the same script! and because of that, you can have an empty DB

- Good management of data tables & possibility to have service of multiple Servers

- Great to improve user interface & SQL query error classification to make easy accessibilities of data.

It’s an industry standard tool - we use it for all kinds of CRUDS

Only gave 3 stars on ease of use because I am not the most educated user!

No cons - mostly PEBKAC issues at most, but it’s not PostgreSQL’s fault!

It's a very powerful DB for the price, it has all the features and customization that any db admin needs.

Without a db admin, the features may be restricted to the basic ones, unless someone researches how to do things

I have used this several times while I was studying and in my company also. t supports ACID properties and it can handle high traffic. I can use database indexing, different data types. functions, aggregates and complex queries. There's a huge community support and I asked for assistance twice from them.

I doubt the performance of this when I handle complex queries.

It provides additional data types than traditional MySQL database. Easy deployment and faster write operation with massive dataset really makes it best choice among the open source RDBMS.

No major cons, I faced as of now for PostgreSQL

PostgreSQL excels in its strong documentation, large data handling, and exceptional security.

Challenges with screen navigation, JSON handling, and data comparison can make it less user-friendly

Highly recommended. It's the most powerful database engine I ever worked with. It has a lot of features that I used and worked very well: postgis for spatial searches, full-text search, partitions, etc.

At some point, we start having problems with very slow queries, and after some debugging we discover postgres decided to use the wrong index to perform the query plan. Probably because of bad stats but from time to time the problem happens again.

PostgreSQL has several advantages. It is lightweight and reliable. Search filters are very easy to understand. People who know the basics of the SQL language can do several queries, since PostgreSQL assembles selects. I can change it within the table itself, so I don't need to do the update command. On top of that, it's free and open source!

Sometimes the connection to the database drops (internal server error 500), and it is necessary to connect again. When the query has many records, the data return is slow. They are the only negative points of this tool.

PostgreSQL is the most flexible database management system out there. It has a lot of plugins (data visualization, backup, performance, etc), which make it very expandable too, incredibly powerful configuration options, etc. It has almost any type of column that your system will ever need.

I really don't found any PostgreSQL problem until now, so I would recommend that you use it without any fear.

Postgresql is the best database system to store data.

The most usaged features is an extensions. I think that this features should include to standard postgresql distribution.

PostgreSQL is highly regarded for its robustness, scalability, and reliability, making it the perfect choice for businesses looking for a dependable and secure database. It has a wide array of features such as advanced indexing, support for stored procedures and triggers, as well as a wide array of data types, making it ideal for creating complex applications. It also supports an extensive range of languages and tools, making it easy to use for developers and administrators. Additionally, PostgreSQL has high availability and fault tolerance, making it suitable for mission-critical environments. Furthermore, PostgreSQL can be used in the cloud, making it an ideal solution for businesses looking for a reliable and secure database solution.

PostgreSQL can be a challenging platform to learn, especially for beginners. Its steep learning curve, complex structure, and lack of user-friendly documentation make it difficult to get started. Furthermore, troubleshooting and debugging can be difficult, causing even more frustration for those just starting out.

I like that it is easy to learn, that there are lots of good tutorials, and lots of opportunities to practice. I use PostgreSQL almost daily in my job as a data scientist

There are some weird minute differences between the different versions of SQL.

It supports a wide range of query syntax and is the most user-friendly software.

There are way too many reserved keywords. Because of reserved keyword restrictions, we are unable to choose meaningful column names with this many keywords.

how easy it is to use, install, and deploy on any OS. Enterprise grade open source software!

There are no major cons that I can think of.

It allows me to implement a robust database in a very short time, using a structure very similar to Oracle, in addition to having many tools that allow us to manage the data in the best way.

There are functionalities that with third-party products can obtain better results.

It is a good Software for those who need SQL.

It can sometimes take a while to compile and have errors like all programming softwares.