&gt; Is there really something about PSQL that makes it better than MySQL these days?<p>In a word: correctness.<p>Yes, MySQL has an UPSERT implementation. Like so many things MySQL rushed out the door, it&#x27;s also buggy and unpredictable. Did you know UPSERTing into a MySQL table with multiple unique indexes can result in duplicate records? Did you know MySQL&#x27;s ON CONFLICT IGNORE will insert records that violate other not-NULL constraints? [1]<p>I&#x27;ve used both MySQL and PostgreSQL for over a decade, and working around the many MANY misbehaviors and surprises in MySQL requires continuous dev effort. PostgreSQL on the other hand is correct, unsurprising, and just as performant these days.<p>MySQL is what happens when you build a database out of pure WAT [2].<p>[1] <a href="https:&#x2F;&#x2F;wiki.postgresql.org&#x2F;wiki&#x2F;UPSERT#MySQL.27s_INSERT_..._ON_DUPLICATE_KEY_UPDATE" rel="nofollow">https:&#x2F;&#x2F;wiki.postgresql.org&#x2F;wiki&#x2F;UPSERT#MySQL.27s_INSERT_......</a><p>[2] <a href="https:&#x2F;&#x2F;www.destroyallsoftware.com&#x2F;talks&#x2F;wat" rel="nofollow">https:&#x2F;&#x2F;www.destroyallsoftware.com&#x2F;talks&#x2F;wat</a>