PostgreSQL vs MySQL, a comparison

A quick comparison between PostgreSQL and MySQL

⭐️ 👀 2023 WEB DEVELOPMENT BOOTCAMP starting in days! Join the waiting list to reserve your spot in my 10-weeks cohort course and learn the fundamentals, HTML, CSS, JS, Tailwind, React, Next.js and much much more! 👀 ⭐️

In this post I want to make a high-level comparison of PostgreSQL and MySQL.

One of the main selling points of PostgreSQL is the license. PostgreSQL is Open Source, has the GPL license, and it is owned by the PostgreSQL Global Development Group community.

MySQL today is owned by Oracle, and has 2 difference licenses. One is open source, the other one is commercial. This does not mean that if you want to use MySQL for a commercial project you need to pay. The commercial license provides paid support and additional software built on top of MySQL, from Oracle.

There is a fully Open Source fork of MySQL called MariaDB, which is much less popular in terms of usage and branding, because it does not have the same history of MySQL, but it’s an optimal drop-in replacement if you prefer MySQL but you are worried about licensing.

Let’s talk about features.

More or less, the feature set of both MySQL and PostgreSQL is equivalent. One might do something that the other does not, but we’re talking about very advanced features that I’m not getting into here.

Both are very advanced database management systems that have a long history.

Both support the SQL standard (not completely, but a large portion) and add features on top of it. Both provide ACID (Atomicity, Consistency, Isolation, Durability) compliance.

Both allow to easily create replication, both are very secure, both have a huge community around them for any problem you might have.

Both have a large set of tooling built around them.

Which one should you choose? It’s hard to say.

Unless you need one particular feature implemented in one and not implemented in the other, I would choose the one you are already familiar with.

For example, if you come from WordPress and have interacted with MySQL before, you can just stick to it (or MariaDB).

It might also depend on the platform you want to deploy your software on. Heroku for example provides a built-in managed PostgreSQL cloud database as a service, which might be very convenient instead of managing your own database server.

One more thing! ⚠️ ✋

At the end of January I will organize the Web Development Bootcamp.

It's a 10-weeks long cohort online course where I will guide you to becoming a Web Developer.

It's not "just a course". It's a big event I organize once a year.

We'll start from zero, learn the fundamentals of Web Development, HTML CSS, JavaScript, Tailwind, Git, using the command line, VS Code, GitHub, Node.js, we'll then learn React, JSX, how to use PostgreSQL, Astro, Next.js, Prisma, deploying on Netlify/DigitalOcean/Fly/Vercel and much more! 

At the end of the first 10 weeks you'll know how to create web sites and web applications and I'll unlock you the 2nd phase of the Bootcamp: you will get access to a large number of projects exclusive to the Bootcamp graduates, so you can follow my instructions to build things like private areas with authentication, clones of popular sites like Twitter YouTube Reddit, create e-commerce sites, and much much more.

Because once you got the fundamentals, you only learn by working on real, exciting projects.

To find out more, visit bootcamp.dev