DEV Community

Discussion on: The Ultimate Postgres vs MySQL Blog Post

Collapse
 
rhymes profile image
rhymes

@dmfay : I guess you'll need to release a new comparison soon :P

MySQL has window functions and CTEs now: modern-sql.com/blog/2018-04/mysql-8.0

Still ignores check constraints though :(

MariaDB also introduced versioned tables which I would like to see in PostgreSQL

Collapse
 
dmfay profile image
Dian Fay

I'm not in the position of needing to convert a Postgres data layer to run on MySQL anymore so I'll leave that for someone else 😂

Collapse
 
rhymes profile image
rhymes

I'll need to convince some client to hire you to convert a perfectly sound db made with Postgres 10 to MySQL 8 :D