If you have any questions or feedback, pleasefill out this form
Table of Contents
This post is translated by ChatGPT and originally written in Mandarin, so there may be some inaccuracies or mistakes.
This morning I came across this article Leaving MySQL. If there’s one key takeaway from the article, it’s what the author writes:
MySQL is a pretty poor database, and you should strongly consider using Postgres instead.
The footnote even points out that using MariaDB isn’t any better.
I first learned about PostgreSQL through Ruby on Rails. At that time, I encountered some issues while setting up MySQL, so I used PostgreSQL as the database. Ever since then, whenever I'm working with databases, PostgreSQL has been my go-to choice.
Later on, I discovered some of the more appealing features of PostgreSQL, such as support for JSON types (if I recall correctly, MySQL didn’t support this at the time) and its rich INDEX configurations1. At that time, I even tried out PostGIS for practicing geographical applications. In short, my experience with PostgreSQL has always been excellent, and I encourage you to continue choosing PostgreSQL.
Footnotes
If you found this article helpful, please consider buying me a coffee ☕ It'll make my ordinary day shine ✨
☕Buy me a coffee