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, MariaDB and others in Open Source Databases."It's a mature solution that's been around for decades."
"It has a remote access feature to manage the database from a remote location. This enables in-work collaboration."
"MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source."
"MySQL is a popular database platform for businesses because it is extremely easy to use."
"MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"Table partitioning is most valuable. It is easy to use."
"My main reason for using MySQL for this small customer database company and for some kinds of scientific projects was that I had to do the installation myself. I didn't have a database administration team behind me. Therefore, I was looking for something very easy to handle. MySQL is easy to install, connect, and do all such things."
"Oracle MySQL Cloud Service handles data easily."
"The most valuable aspect of the product is data migration."
"The product is easy to learn."
"It is very easy to start working with the product."
"It's easy to use."
"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."
"Scalable, stable, and easy to manage database system, with a straightforward installation."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community. When it's installed correctly, PostgreSQL is an enterprise-grade solution."
"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 initial setup is quick and easy."
"PostgreSQL is very easy to use. I have experience in Oracle SQL and PostgreSQL uses the same syntax which makes it is easy for me to develop."
"The product is very similar to the SQL Server."
"It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job."
"While utilizing a comparable algorithm, is noted to be sensitive, especially when configuring the inner device."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"The full-text search feature must be improved."
"The technical support should be more knowledgeable and available worldwide."
"The solution could improve by having better performance and security."
"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."
"On the database side, it should be really lightweight, and the data structure should be like MongoDB."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
"The technical support is in need of improvement."
"There could be more courses where the people could learn more easily how to use the tool."
"Sometimes, we face syntax issues with the solution."
"The user interface is not simple."
"The product has many bugs."
"It requires a significant amount of expertise and effort to manage, especially when dealing with substantial volumes of data."
"The support is not that great. They're not really supporting directly anymore and relying on experts to figure out technical issues."
"The tool’s stability must be improved."
"I find it difficult to get connectors on the tool. For example, .NET has only one free provider in PostgreSQL. I need to pay the provider if I need something more sophisticated features. Other languages like PHP and Java have good community support. We need community support for .NET."
"The performance of PostgreSQL could improve."
"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."
"Integration with other platforms could be improved."
"It needs more integration."
"I have noticed that user and access management should be improved."
"PostgreSQL uses high memory compared to its counterparts when a highly demanding load is involved, especially one that makes many concurrent connections to the database."
"PostgreSQL’s performance could be improved."