We performed a comparison between MySQL, Oracle MySQL Cloud Service, and PostgreSQL based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases."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."
"The solution has been very easy to scale so far."
"We use MySQL for enterprise data storage as well as part of the back-end of websites and web applications."
"It has a community version. When I have to create a new database, I have no problems with licenses."
"The relations in the database, the dynamic workflow, and the ability to connect with all columns. It's useful for e-commerce."
"The solution is very simple. It's easy to use. That's the most important feature."
"It is very easy to install and has all basic database features."
"The solution is easy to use."
"The most valuable feature is the data aggregation function."
"It is very easy to start working with the product."
"The solution's performance is good."
"The access to a suite of management and administration tools that simplify tasks such as database provisioning, configuration, and monitoring."
"The most valuable features of the solution stem from the fact that it is flexible and is an open-source product."
"The solution overall is very, very good. It's got good integration with other databases and adds new features often."
"The most valuable aspect of the product is data migration."
"The product is easy to learn."
"The most valuable feature is the performance."
"The initial setup is quick and easy."
"The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use."
"It is very scalable and comes with a bonus: no licensing issues as you scale with your databases."
"The community support and the open-source community for it are good."
"Initial setup is simple."
"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."
"It's a useful solution, that can be widely used."
"It could be more secure."
"The licensing cost of the solution is expensive, which MySQL needs to consider improving."
"Integration is a key feature in need of improvement."
"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."
"MySQL needs improvements on its diagnostic features."
"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."
"Stability needs improvement and the backup needs to be enhanced."
"When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."
"The technical support is in need of improvement."
"The solution should offer memory management."
"Sometimes, we face syntax issues with the solution."
"The tool’s stability must be improved."
"The user interface is not simple."
"The support is not that great. They're not really supporting directly anymore and relying on experts to figure out technical issues."
"Sometimes MySQL does upgrades on the server. When we are still using the old server and when they integrate the upgrade, they don't carry along some of the old syntaxes. The versions don't sync."
"They could include more advanced features like clustering and replication in the Oracle databases."
"A better graphic user-interface would be nice to see."
"Integration with other platforms could be improved."
"It is possible that in the newer version this has been addressed, but I would like the deployment in microservices architecture could be improved."
"The interface could be much better."
"Instead of the installation agent downloading all the packages for the install, it should allow the user to download the packages separately on their own to do the install."
"When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties."
"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'm not really able to customize it."