What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
944 Ratings
Top Rated
290 Ratings

MySQL

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
944 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100
Top Rated
290 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100

Highlights

Community Pulse

Reviewers Who Considered Both Products

MySQL

Chose MySQL

MySQL performs very well and has a great feature set. It gives the user, developer, and DBA a lot of bang for no bucks. It is efficient, cost-effective, and doesn't require other specialized hardware or software to run. Microsoft SQL Server generally only works on Windows. …

Chose MySQL

MySQL is a standard across many industries and is familiar to most developers as a result. When comparing to something like MongoDB, most developers are more familiar and comfortable with MySQL. When comparing to something like Oracle, MySQL clearly wins in the expense …

Chose MySQL

The three are relational databases or managers for relational database (except for MariaDB whose approach is based on NoSQL models) with the ability to store large databases and respond to demanding business circumstances, however MySQL compared to Microsoft SQL Server

Chose MySQL

Of course compare to no SQL databases it's slower but there is a completely different use case for them... In my opinion it is better than PostgreSQL, it's easier to configure and has the same performance, or approximately the same. Of course Oracle Database is a way bigger …

Chose MySQL

MySQL is relatively easier to use and than PostgreSQL or SQL Server; it's also cheap to use in production compared to SQL Server. For a beginner who wants to ship something quickly, MySQL is really suited for it.

Chose MySQL

I have also used Microsoft SQL Server. It is quite similar to MySQL. However, MySQL has always been my first choice, I have been using it for a very long time. I have also worked with PostgreSQL in a DevOps project. It is good too but a bit hard to learn and understand.

Chose MySQL

I would say that in a Linux environment MySQL works great compared to both PostgreSQL and MS SQL. The added benefit compared to MS SQL is the low or absent licensing cost. As we use it mainly from PHP the programming interface is great for MySQL. PostgreSQL has many of the …

Chose MySQL

SQLite - Is the goto DB for Mobile/Desktop Apps. Its not as elaborate as Mysql but since its a RDBMS it provides all the basic features and its lite. We use mysql at the backend and for desktop app we use SQLite

postgres - Its a formidable opponent. It is fast and reliable and …

Chose MySQL

So the main reason i would stack up Mysql from rest of the others is that it is open source which can be helpful for doing any POC on the products and learning new technologies and it is also compatible with all other softwares like Microsoft SQL serve and Postgre Sql

Chose MySQL

MySQL is the best platform and it has the ability to even automate time-consuming tasks with a fully managed database service that has enhanced productivity. This tool keeps me up to date about any new features and through instant provisioning it is providing me fast delivery …

Chose MySQL

A bit on the more complex side, but definitely one of the more popular solutions between our customers. As a stable alternative to the sometimes really pricy Oracle DB, it performed well for most of our not-database-heavy projects. It was a bit slower than no-SQL solutions on …

Chose MySQL

MySQL offers best conditions for a rapid adoption at the organization.
Also because it's free software, you can scale up in implementations without worrying about licenses fees.

Chose MySQL

MySQL has a GUI which makes it easy for developers to work upon. It has all features like replication, backup and crash recovery. Also since it is freely available it becomes commercially feasible for people to use this DB. Also MySQL can be easily used as a back end for the …

Chose MySQL

I selected MySQL for small and medium companies and software.

Chose MySQL

For our needs, MySql was enough and it was better known than the others.

Chose MySQL

MySQL is not used very often for ML.

Chose MySQL

Oracle gives more safety as a product provider. MySQL is definitely easier to use and with more concise API.

Chose MySQL

We use MySQL because it's easy to set up and use.

Chose MySQL

I think it is easy to learn when someone with technical skills tries to connect with it, and it is easy to handle data.

Chose MySQL

MySQL is a most generic implementation of a database of a sort that is coherent with major designs of web engines and frameworks. As it works in cross-platform environments and easy to deploy it seems to be a competitive choice and prospective solution for integration into web …

Chose MySQL

Frankly, there is not much difference between MySQL, GoogleSQL, Dremel SQL, SQL, etc. The main differences would be the syntax and pricing. MySQL has a free version, and it includes loads of important features, which were good enough for my company. The User Interface was also …

Chose MySQL

After Oracle bought MySQL, I have pivoted some projects to use MariaDB instead, which is a fork of MySQL and maintained by the community and original developers of MySQL. This is free under the GNU GPL, and is not impacted by decisions Oracle makes for MySQL. RDS has the …

Chose MySQL

MySQL has it's pros / cons. The best things about MySQL are that it is open-source/free and has such a vast community of users. If you want a free database MySQL is the quickest to use, but if you're trying to build a strong foundation for your company, I prefer Postgres. If …

PostgreSQL

Chose PostgreSQL

MySQL is a popular open-source alternative to PostgreSQL, but in my experience it lacks the robustness, durability, and flexibility of PostgreSQL. It has also changed hands frequently, so support isn't the greatest. MongoDB and other NoSQL databases are helpful in certain …

Chose PostgreSQL

They each have their pros and cons. MySQL is probably the other popular "free" alternative in this space, but it's not as popular or have as much community support as PostgreSQL.
Microsoft SQL Server is amazing in the microsoft tech stack, but it's pretty useless and provides …

Chose PostgreSQL

PostgreSQL is very similar to both MySQL and Microsoft's SQL Server. With no licensing costs, it's clearly a win against SQL Server, plus it can be run on either Linux or Windows. MySQL and PostgreSQL also have many similarities, however, PostgreSQL offers many more options for …

Chose PostgreSQL

MySQL is also an open-source relational database management system. Both support ACID requirements, Full-text-search. Both are available for Cloud solutions. However, I would recommend PostgreSQL.

Chose PostgreSQL

PostgreSQL has more features than MySQL, and it has better documentation.
Microsoft SQL Server is more complicated to set up and administer, and its syntax is not as easy to write as PLPGSQL. Moreover, the built-in functions in PostgreSQL are better than what's on offer from MS …

Chose PostgreSQL

PostgreSQL works better than MySQL for analytics workflows where a massively parallel processing database architecture is necessary. We used PostgreSQL because it allows better scalability for querying and data analysis compared to the transactional database MySQL that we use.

Chose PostgreSQL

Faster than MySQL/MariaDB and obviously cheaper than Microsoft. Performance is amazing.

Chose PostgreSQL

MySQL: As I mentioned before, MySQL has superior write performance. However, Postgres has super read performance and safer ACID transactions, i.e. less potential data loss.
Elasticsearch: we use Elasticsearch to store free-form customer data, but that's a different use-case. …

Chose PostgreSQL

Both Oracle and MS-SQL database option fell when we evaluated the effect on our overall solution cost to our customers. customer examine the overall cost of the solution they buy, selecting Oracle or MS-SQL would leave less money in our pockets.
We are Linux based solutions and …

Chose PostgreSQL

Much more mature and stable when compared to MySQL with features such as MVCC, complex subquery plans, ORDBMS, and NoSQL support. With Oracle retaining rights to MySQL its future as an open database is less secure and is no longer in the hands of the community. PostgreSQL also …

Chose PostgreSQL

When we were originally evaluating Redshift we ran into some issue with dates. Either way, Postgres is a better choice than Redshift because it avoids vendor lockin. We ended up choosing Postgres over MySQL because it was easier at the time to get a hosted Postgres cluster up …

Chose PostgreSQL

Postgres stacks up just [fine] along the other big players in the RDBMS world. It's very popular for a reason. It's very close to MySQL in terms of cost and features - I'd pick either solution and be just as happy. Compared to Oracle it is a MUCH cheaper solution that is just …

Chose PostgreSQL

We evaluated both PostgreSQL and MySQL, two popular open source relational databases. While they are very similar in most areas, PostgreSQL's reliability and performance won us over, plus it has much better support from cloud vendors we also work with.

Chose PostgreSQL

PostgreSQL is rich in features and free to use which is perfect for our organization. PostgreSQL is our goto RDBMS if we want to create an application or services backend with the database if there's no specific requirement.
For example for the most important and largest …

Chose PostgreSQL

PostgrPostgreSQL as a transaction db engine against oracle and sql server works well. TPM wise compared to MySQL and MariaDB, on an evan scale.
SQL function supports, far outweighs compared to MySQL and MariaDB. PG Extensions allow for flexibiltity and scalability. Allows …

Chose PostgreSQL

In this case, Postgres is preferred because it handles large data sets and requires fewer hardware resources than its competitor, MySQL. Compared to PostgreSQL, Microsoft products are excellent, but the installation process for MS SQL is lengthy. PostgreSQL has an advantage …

Chose PostgreSQL

For our use cases, PostgreSQL is just as feature rich as other options, costs less, and is simple to get up and running. There is also a plethora of documentation to support it which makes it a great option for a small scale startup without needing high levels of expertise to …

Chose PostgreSQL

Although the competition between the different databases is increasingly aggressive in the sense that they provide many improvements, new functionalities, compatibility with complementary components or environments, in some cases it requires that it be followed within the same …

Chose PostgreSQL

  • Object oriented approach
  • Json data type support
  • Timezone aware timestamps

Chose PostgreSQL

Its main characteristic is the integrity of the data. In addition, being free software, it has no costs associated with its license, which allows the number of installations to be scaled without problems.
The technical staff quickly learns about its installation, configuration …

Chose PostgreSQL

We selected PostgreSQL due to the number of employees who have used it in the past.
The data consistency guarantees.
The multiple transaction isolation levels support.

Chose PostgreSQL

PostgreSQL outperforms every other option. It is faster, more flexible, more reliable, easier to maintain, and more consistent in behaviour than any of the other offerings.

Chose PostgreSQL

I think Postgres stacks up great against all modern database solutions and has continued to be a trend leader in this space.

Chose PostgreSQL

It's a viable alternative, with a rich feature set and a reliable system. PostgreSQL is one of the best RDBMS's currently on the market in 2020, it serves just as well as a starter, PoC DB for any software idea as a final, highly valuable database solution for big systems.

Chose PostgreSQL

PostgreSQL beats every other RDBMS offering for being truly Open Source. Since it does not belong to a specific company it is poised to remain as such for a long time to come. PostgreSQL has a huge user base and active community. The releases are coming out often with …

Attribute Ratings

  • MySQL is rated higher in 2 areas: Likelihood to Renew, Usability
  • PostgreSQL is rated higher in 3 areas: Likelihood to Recommend, Support Rating, Implementation Rating

Likelihood to Recommend

8.5

MySQL

85%
133 Ratings
8.9

PostgreSQL

89%
55 Ratings

Likelihood to Renew

9.9

MySQL

99%
4 Ratings
9.0

PostgreSQL

90%
1 Rating

Usability

10.0

MySQL

100%
6 Ratings
9.0

PostgreSQL

90%
6 Ratings

Availability

MySQL

N/A
0 Ratings
9.0

PostgreSQL

90%
2 Ratings

Performance

MySQL

N/A
0 Ratings
7.0

PostgreSQL

70%
2 Ratings

Support Rating

8.6

MySQL

86%
4 Ratings
9.4

PostgreSQL

94%
13 Ratings

Implementation Rating

8.0

MySQL

80%
2 Ratings
9.0

PostgreSQL

90%
3 Ratings

Product Scalability

MySQL

N/A
0 Ratings
8.0

PostgreSQL

80%
1 Rating

Likelihood to Recommend

Oracle

For smaller database backends, this product works well. Our backend printer management software is using MySQL as its backend and we have not had any issues since it went live 2 years ago. It's also free so no licensing worries.
Read full review

PostgreSQL Global Development Group

PostgreSQL, unlike other databases, is user-friendly and uses an open-source database. Ideal for relational databases, they can be accessed when speed and efficiency are required. It enables high-availability and disaster recovery replication from instance to instance. PostgreSQL can store data in a JSON format, including hashes, keys, and values. Multi-platform compatibility is also a big selling point. We could, however, use all the DBMS’s cores. While it works well in fast environments, it can be problematic in slower ones or cause multiple master replication.
Read full review

Pros

Oracle

  • Security: is embedded at each level in MySQL. Authentication mechanisms are in place for configuring user access and even service account access to applications. MySQL is secure enough under the hood to store your sensitive information. Also, additional plugins are available that sit on top of MySQL for even tighter security.
  • Widely adopted: MySQL is used across the industry and is trusted the most. Therefore, if you face any problems, simply Google it and you shall land in plenty of forums. This is a great relief as when you are in a need of help, you can find it right in your browser.
  • Lightweight application: MySQL is not a heavy application. However, the data you store in the database can get heavy with time, but as in the configuration and MySql application files, those are not very heavy and can easily be installed on legacy systems as well.
Read full review

PostgreSQL Global Development Group

  • The stability it offers, its speed of response and its resource management is excellent even in complex database environments and with low-resource machines.
  • The large amount of resources it has in addition to the many own and third-party tools that are compatible that make productivity greatly increase.
  • The adaptability in various environments, whether distributed or not, [is a] complete set of configuration options which allows to greatly customize the work configuration according to the needs that are required.
  • The excellent handling of referential and transactional integrity, its internal security scheme, the ease with which we can create backups are some of the strengths that can be mentioned.
Read full review

Cons

Oracle

  • Although you can add the data you require as more and more data is added, the fixity of it becomes more critical.
  • As the demand, size, and use of the system increase, you may also need to change or acquire more equipment on your servers, although this is an internal inconvenience for the company.
Read full review

PostgreSQL Global Development Group

  • The query syntax for JSON fields is unwieldy when you start getting into complex queries with many joins.
  • I wish there was a distinction (a flag) you could set for automated scripts vs working in the psql CLI, which would provide an 'Are you sure you want to do X?' type prompt if your query is likely to affect more than a certain number of rows. Especially on updates/deletes. Setting the flag in the headless(scripted) flow would disable the prompt.
  • Better documentation around JSON and Array aggregation, with more examples of how the data is transformed.
Read full review

Pricing Details

MySQL

Starting Price

Editions & Modules

MySQL editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    PostgreSQL

    Starting Price

    Editions & Modules

    PostgreSQL editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Likelihood to Renew

      Oracle

      For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
      Read full review

      PostgreSQL Global Development Group

      As a needed software for day to day development activities
      Read full review

      Usability

      Oracle

      I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
      Read full review

      PostgreSQL Global Development Group

      Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
      Read full review

      Reliability and Availability

      Oracle

      No answers on this topic

      PostgreSQL Global Development Group

      PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.
      Read full review

      Performance

      Oracle

      No answers on this topic

      PostgreSQL Global Development Group

      The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
      Read full review

      Support Rating

      Oracle

      The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
      Read full review

      PostgreSQL Global Development Group

      There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.
      But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.
      Read full review

      Online Training

      Oracle

      No answers on this topic

      PostgreSQL Global Development Group

      The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
      Read full review

      Implementation Rating

      Oracle

      1. Estimate your data size. 2. Test, test, and test.
      Read full review

      PostgreSQL Global Development Group

      The online documentation of the PostgreSQL product is elaborate and takes users step by step.
      Read full review

      Alternatives Considered

      Oracle

      MongoDB is an application oriented solution with unstructured data. Percona Server for MySQL is a good solution when looking for performance peaks and the amount of data grows continuously over time. MySQL is the ideal solution when we have a data schema defined and we do not have great requirements at the performance level.
      Read full review

      PostgreSQL Global Development Group

      Postgres stacks up just [fine] along the other big players in the RDBMS world. It's very popular for a reason. It's very close to MySQL in terms of cost and features - I'd pick either solution and be just as happy. Compared to Oracle it is a MUCH cheaper solution that is just as usable.
      Read full review

      Scalability

      Oracle

      No answers on this topic

      PostgreSQL Global Development Group

      The DB is reliable, scalable, easy to use and resolves most DB needs
      Read full review

      Return on Investment

      Oracle

      • It has made site management through a CMS like WordPress or Drupal infinitely easier to manage.
      • It is a critical part of the LAMP, WAMP and MAMP stack and has been a major driver of innovation in the content-management-system space, pushing site and web-application development toward greater democratization.
      • It has proved to be very reliable and easy to set up and administer and saves me tremendous time troubleshooting query and performance issues.
      Read full review

      PostgreSQL Global Development Group

      • The user-role system has saved us tons of time and thus money. As I mentioned in the "Use Case" section, Postgres is not only used by engineering but also finance to measure how much to charge customers and customer support to debug customer issues. Sure, it's not easy for non-technical employees to psql in and view raw tables, but it has saved engineering hundreds of man-hours that would have had to be spent on building equivalent tools to serve finance or customer support.
      • It provides incredibly trustworthy storage for wherever customer data dumped in. In our 6 years of Postgres existence, we have not lost a byte of customer data due to Postgres messing up a transaction or during the multiple times the hard-drives failed (thanks to ACID compliance!).
      • This is less significant, but Postgres is also quite easy to manage (unless you are going above and beyond to squeeze out every last bit of performance). There's not much to configure, and the out of the box settings are quite sane. That has saved us engineers lots of time that would have gone into Postgres administration.
      Read full review

      Add comparison