· 1 min read

Thoughts (Leaving MySQL)

This article was auto-translated from Chinese. Some nuances may be lost in translation.

This morning, I came across the article Leaving MySQL. If there’s one key takeaway from this post, it’s probably what the author wrote:

MySQL is a pretty poor database, and you should strongly consider using Postgres instead.

In the footnotes, he even specifically noted that using MariaDB won’t be any better.

The first time I learned about PostgreSQL was through Ruby on Rails. I ran into some issues setting up MySQL back then, so I switched to PostgreSQL as my database. Ever since, whenever I need to work with a database, PostgreSQL has always been my go-to choice.

Later on, I discovered some of PostgreSQL’s more appealing features, such as native JSON type support (which I recall MySQL didn’t support at the time) and rich INDEX configuration options1. I also tried out PostGIS back then to practice building geospatial applications. In short, my experience with PostgreSQL has always been great. Keep choosing PostgreSQL.

Footnotes

  1. /devnote/2021-12-07-postgre-sql-note-index/ ↩

Related Posts

Explore Other Topics