
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL
I like MySQL. I have used it for a long time, and I have also operated it in on-premises environments. However, since joining my current company, I have had more opportunities to use PostgreSQL. At first, I honestly felt a lot of resistance to it. I had used MySQL for so long, so part of it was just habit, and I think I was also more wary of PostgreSQL than I needed to be. But as I actually used it, I gradually started to see what was good about PostgreSQL. These days, if someone asks me which one I would choose for a new project, I have come to feel that I would want to choose PostgreSQL. Because I have used MySQL for a long time, I also know the rough edges that older MySQL had. At the same time, I think it is inaccurate to talk about MySQL today based only on old impressions. If you configure sql_mode properly, you can avoid many dangerous behaviors, and MySQL 8 added a large number of features. Also, this time I want to compare current MySQL and PostgreSQL on the assumption that th
Continue reading on Dev.to
Opens in a new tab


