Try our new research platform with insights from 80,000+ expert users

Oracle MySQL Cloud Service vs PostgreSQL comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Oracle MySQL Cloud Service
Ranking in Open Source Databases
7th
Average Rating
8.2
Reviews Sentiment
8.5
Number of Reviews
16
Ranking in other categories
Relational Databases Tools (12th)
PostgreSQL
Ranking in Open Source Databases
2nd
Average Rating
8.4
Reviews Sentiment
7.9
Number of Reviews
125
Ranking in other categories
Vector Databases (9th)
 

Mindshare comparison

As of November 2024, in the Open Source Databases category, the mindshare of Oracle MySQL Cloud Service is 0.5%, down from 0.7% compared to the previous year. The mindshare of PostgreSQL is 25.6%, up from 23.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Open Source Databases
 

Featured Reviews

Raghuram K M - PeerSpot reviewer
Ideal, stable, good support and it helps with the developer console
I have used MongoDB, MySQL, and Oracle. MongoDB is entirely different. It's a NoSQL platform database, so it's totally different. It is a little bit hard to work with. The way it is organized and structured is different. But between Microsoft Azure MySQL and Oracle, they are pretty similar. * Cost: Microsoft is not a preferred platform. Their licensing is very complex and expensive. Oracle is much better. * AI: In terms of data analytics and AI, Microsoft is better. Certain complex transformations are easier to do in MSSQL. So, if you have to analyze data from a lot of different data sources, it becomes much easier. However, the usage of the particular product depends on the project. Personally, I would like to work on MySQL. But in certain cases where the application scale is very large, and custom models from certain regions of the globe prefer Microsoft, then we have to go with MSSQL. But technically, there is not much difference.
AdityaSharma3 - PeerSpot reviewer
Transaction processes are fast and good replication capability
Use cases include querying data warehouses and databases to fetch data for clients already working on PostgreSQL.  We also use Postgres for building reports It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping. The query speed is fast, and the…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The access to a suite of management and administration tools that simplify tasks such as database provisioning, configuration, and monitoring."
"The most valuable aspect of the product is data migration."
"The scalability of the database is absolutely guaranteed by the new features."
"The product is easy to learn."
"MySQL is a centralized RDBMS in itself, and you don't have the overkill of having the full Oracle or Microsoft SQL Server. It's ideal, and it helps with the developer console. It has three versions for developers. It's a very good tool for open source."
"Oracle MySQL Cloud Service is easy to use and implement."
"It's easy to use."
"The initial setup was straightforward."
"The solution has many valuable features such as it easy to use and the interface is intuitive."
"The built-in code procedural language is the most valuable. It has a built-in layer for code procedures. Its installation is very easy and quick, and it is free. It is also stable, and its performance is also good."
"The performance is good."
"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."
"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"What I like is that it's quite powerful in terms of performance."
"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."
 

Cons

"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."
"The user interface is not simple."
"Integrating business intelligence or NLP solutions would help us save time and would prevent us from having to take a deep dive. Data problems seem to multiply on the system when you interact with it. Automation would save a lot of man-hours."
"In a production environment, upgrading from a lower to an upper version is a very long process that needs to be improved."
"Sometimes, we face syntax issues with the solution."
"It requires a significant amount of expertise and effort to manage, especially when dealing with substantial volumes of data."
"The product has many bugs."
"The technical support is in need of improvement."
"The pricing 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."
"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."
"I have noticed that user and access management should be improved."
"We often find the solution's datetime datatype challenging."
"I don't think PostgreSQL supports bulk databases, so it needs to have more capabilities in terms of managing the bulk data."
"PostgreSQL’s performance could 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."
 

Pricing and Cost Advice

"The license is expensive."
"The product is expensive."
"While the core solution itself is not exorbitant, the support services are associated with a significant maintenance fee, often ranging from twenty to thirty percent."
"The product is free since it is an open-source tool."
"Oracle has a better licensing model compared to its competitors."
"It is an open-source product."
"The solution’s paid plans are expensive."
"It could be much cheaper. If you would like to build an application on Amazon today, PostgreSQL is the standard database with Redshift. If you want other databases, you can add them, but PostgreSQL is the basis of everything. It's a question of money, that's it."
"It is free. In terms of operating costs, it basically needs the same platform on which Oracle runs."
"The solution requires a license."
"PostgreSQL is a free and open-source database."
"This solution can offer a cheaper choice for customers since it is open-source."
"It is free. There is no license on it."
"We use the open-source version of PostgreSQL and not the enterprise edition."
"The tool is cheaply priced compared to other RDBMS providers in the market."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
20%
Financial Services Firm
16%
University
15%
Real Estate/Law Firm
7%
Computer Software Company
16%
Financial Services Firm
12%
Manufacturing Company
8%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle MySQL Cloud Service?
Oracle MySQL Cloud Service handles data easily.
What needs improvement with Oracle MySQL Cloud Service?
MySQL should have some kind of native query browser. If it could come with a built-in connector, then the relationship... We are just able to fix it. Right now, we have to install it separately. So...
How does Firebird SQL compare with PostgreSQL?
PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit yo...
What do you like most about PostgreSQL?
It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping.
What is your experience regarding pricing and costs for PostgreSQL?
The tool is free of cost. For now, it's not about making money. But once we perfect it, we can offer it to customers willing to pay for support and other services. Most of my deployments are free.
 

Learn More

Video not available
 

Overview

 

Sample Customers

Omnis, Naveex, Rehash Technologies
1. Apple 2. Cisco 3. Fujitsu 4. Instagram 5. Netflix 6. Red Hat 7. Sony 8. Uber 9. Cisco Systems 10. Skype 11. LinkedIn 12. Etsy 13. Yelp 14. Reddit 15. Dropbox 16. Slack 17. Twitch 18. WhatsApp 19. Snapchat 20. Shazam 21. SoundCloud 22. The New York Times 23. Cisco WebEx 24. Atlassian 25. Cisco Meraki 26. Heroku 27. GitLab 28. Zalando 29. OpenTable 30. Trello 31. Square Enix 32. Bloomberg
Find out what your peers are saying about Oracle MySQL Cloud Service vs. PostgreSQL and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.