PostgreSQL Versus MySQL – Isn’t A Database Just a Database?
MySQL and PostgreSQL are open source databases that, from a very high viewpoint, seem to do the same thing.
However, subtle and non-subtle differences can severely impact your project. There are features missing in one that are in the other (JSON_TABLE() and MERGER(), for example) that will change the way you handle your data. Administration for either database needs special skills, and backups can potentially cause you great angst. So how do you pick ‘THE ONE’ for your needs? Where are the pain points that you need to avoid?
Join Pep Pla, Percona Consultant, for this session as he explores the differences between MySQL and PostgreSQL so you can make an informed decision for your business.
Pep Pla, Percona Consultant
Pep has a broad experience in several database platforms, but in recent years he has focused on MySQL. His work abides by the motto of Mission Control at NASA: “Tough and competent”. Tough means you are accountable for what you do or fail to do, it means compromise and responsibility. Competent means that you take nothing for granted and you must never be found short in knowledge and skills. This is how Pep feels and lives database management. He is also interested in applying Lean culture to his job and enjoys living in Barcelona with his kids and his partner.