· 1 min read

Impressions (Leaving MySQL)

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

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

  1. https://blog.kalan.dev/2021-12-07-postgre-sql-note-index/

Related Posts

Explore Other Topics