We compared PostgreSQL and MySQL based on our user's reviews in several parameters.
PostgreSQL is known for its robustness, scalability, and efficiency, with excellent customer service. However, it requires improvements in performance optimization and installation processes. On the other hand, MySQL is valued for its data management efficiency and security measures, with outstanding customer support. Areas for enhancement include query execution speed and documentation.
Features: PostgreSQL users appreciate its robustness, scalability, advanced SQL functionality, extensive community support, and compatibility with multiple operating systems. Meanwhile, MySQL shines with its efficient data handling, flexibility, ease of use, and strong security measures.
Pricing and ROI: PostgreSQL offers a manageable setup cost and fair licensing terms, catering to various budgets. On the other hand, MySQL is praised for its affordable setup cost and flexible licensing options, making it a reasonable choice for users., PostgreSQL offers excellent scalability, security features, and integration with other systems, delivering reliable results. MySQL is praised for its reliability, cost-effectiveness, ease of use, and ability to handle large databases.
Room for Improvement: PostgreSQL has room for improvement in enhancing overall performance, addressing difficulties during installation and configuration, improving documentation, and enhancing the user interface. On the other hand, MySQL needs enhancement in performance, documentation, support channels, scalability, compatibility, and security features.
Deployment and customer support: Users of PostgreSQL reported that the deployment and setup of a new tech solution took either 3 months for deployment and an additional week for setup or 1 week for both phases. On the other hand, users of MySQL reported longer deployment durations, ranging from several months to 1 week for both deployment and setup., PostgreSQL's customer service and support have been praised for their responsiveness, helpfulness, and effectiveness. Users appreciate the prompt and knowledgeable assistance provided by the team. In comparison, MySQL's customer service and support are highly praised. Users appreciate the prompt and helpful assistance they receive when facing any issues or inquiries. The support team is described as knowledgeable and reliable.
The summary above is based on 35 interviews we conducted recently with PostgreSQL and MySQL users. To access the review's full transcripts, download our report.
"We use it as a data store and from that perspective, we get everything we need."
"I like MySQL because of its community."
"It is a very stable solution. I deployed the product six years ago, and it still works fine."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"MySQL gives us all of the critical features that we need in a database, but without the costs."
"The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
"The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres."
"PostgreSQL is stable. It's available, stable, and reliable."
"The community support and the open-source community for it are good."
"The product is very similar to the SQL Server."
"This is an open-source solution, operates at a high speed, and supports more than one SQL language."
"The solution has many valuable features such as it easy to use and the interface is intuitive."
"We often use PostgreSQL for operations monitoring because we are a manufacturing company."
"We are able to create many different types of jobs and items with this solution making it one of the most valuable features."
"From a user perspective, the initial setup could be simplified a bit."
"MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers."
"I would like to see more integrations of the solution with other platforms and improve the support on different data types."
"The solution could improve by having better performance and security."
"The solution is expensive."
"Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."
"Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it."
"When I run into issues, I really have to research how to fix them."
"They need to improve the user experience of the management."
"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."
"The user interface for the clients could be easier to use as they are small businesses. From a technical support perspective, the documentation could be improved."
"The database and applications can become very slow."
"There could be a plugin to distribute the data on servers for the product."
"The interface climate could be better."
"They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great."
"A better graphic user-interface would be nice to see."
MySQL is ranked 1st in Open Source Databases with 141 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 120 reviews. MySQL is rated 8.2, while PostgreSQL is rated 8.6. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of PostgreSQL writes " A scalable and stable database for transactional purposes". MySQL is most compared with Firebird SQL, MariaDB, Teradata, SQL Server and Oracle Database, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MariaDB, SQLite and YugabyteDB. See our MySQL vs. PostgreSQL report.
See our list of best Open Source Databases vendors.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
