We performed a comparison between MySQL and PostgreSQL based on real PeerSpot user reviews.
Find out in this report how the two Open Source Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is pretty simple to use and I don't have anything really bad to say about it."
"Table partitioning is most valuable. It is easy to use."
"What I really like about MySQL is the opportunity to search for information and organize it any way I like."
"MySQL is a popular database platform for businesses because it is extremely easy to use."
"I like the JSON stuff."
"It has a community version. When I have to create a new database, I have no problems with licenses."
"It's a mature solution that's been around for decades."
"It is very easy to install and has all basic database features."
"We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance."
"It is a pretty comprehensive database system. Its performance is good, and it does what it is supposed to do. It also integrates very well."
"It is very scalable and comes with a bonus: no licensing issues as you scale with your databases."
"The solution is quite stable."
"It is very useful for both structured and unstructured data. You can store unstructured and structured data in PostgreSQL. It is easy to use. You can easily manage things through PostgreSQL Admin. It is cost-effective. Its on-premise version is free. It is agnostic of on-premise or cloud. You can install it on the cloud or on-premises. It is available with all clouds, and you can also install it on desktop or Windows Servers."
"It's a standard reliable database management system."
"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 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."
"In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful."
"Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance."
"As an open-source product, there isn't really any technical support available if you get into trouble or have issues."
"The solution could improve by having better performance and security."
"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."
"The licensing of the solution is on the expensive side."
"It could be a little bit simpler to use."
"Scalability could be improved."
"I'd like to see better memory management. I think that that's one of the few areas that Postgres does not handle as well as MySQL does or did."
"I had some issues when I integrated with the Jupyter Notebook."
"PostgreSQL could improve by adding data warehousing tools."
"It is possible that in the newer version this has been addressed, but I would like the deployment in microservices architecture could be improved."
"Integration with other platforms could be improved."
"I'm not really able to customize it."
"It would be good to have machine learning functionality in this solution, similar to Microsoft SQL Server and other solutions. Machine learning capability for a basic level or a common user would be useful. It can also have good reporting capabilities."
"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."
MySQL is ranked 1st in Open Source Databases with 43 reviews while PostgreSQL is ranked 2nd in Open Source Databases with 35 reviews. MySQL is rated 8.0, while PostgreSQL is rated 8.0. The top reviewer of MySQL writes "A great open-source product that offers great scalability and compatibility". On the other hand, the top reviewer of PostgreSQL writes "A stable solution with an easy setup for media management". MySQL is most compared with Firebird SQL, MariaDB, Oracle Database, SQL Server and SAP HANA, whereas PostgreSQL is most compared with Firebird SQL, MariaDB, EDB Postgres Advanced Server, YugabyteDB and SQLite. 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.
