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.
"The initial setup was easy. I work in an agile way, which means coding and deploying quickly."
"However, it is easy to scale MySQL using the functions provided with the product."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"The solution is a small application and is very easy to deploy."
"It is a scalable solution."
"The solution is very stable."
"The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage."
"Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance."
"The solution is quite stable."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"PostgreSQL makes it very adaptable to several descriptions of a record. Instead of having several tables or several relations for one entity, I can adapt this entity. It can be a multiform entity. For example, here in Mexico, a company and a person can be sold to us as a physical entity or a physical person."
"The product is very similar to the SQL Server."
"The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution."
"We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance."
"The product is easy to use and works fast for relational databases."
"It isn't as reliable as an SQL Server."
"In the next release, I would like to see the scalability features improved to allow you to configure it and reduce the complexity with the configuration, making it easier for the end-user to scale. Make it as simple as it can be."
"It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL."
"It should provide better customer experiences."
"The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions."
"The licensing cost of the solution is expensive, which MySQL needs to consider improving."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"The only service which could be improved is its usability. The entire user experience needs to be revamped to meet the 2018 design standards."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
"I had some issues when I integrated with the Jupyter Notebook."
"Integration with other platforms could be improved."
"The interface climate could be better."
"A better graphic user-interface would be nice to see."
"There could be a plugin to distribute the data on servers for the product."
"PostgreSQL doesn't have a feature for temporal SQL, which is useful for gathering versions of data. This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2."
"The pricing could be better."
MySQL is ranked 1st in Open Source Databases with 142 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.