Thoughts (Leaving MySQL)
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
-
/devnote/2021-12-07-postgre-sql-note-index/ ↩
Related Posts
- How to Prepare for Software Engineering Interviews Preparing for tech interviews has always been challenging. One of the most frustrating parts is the heavily one-sided power dynamic. As a candidate, it's hard to gauge their actual standards, and it's easy to spiral into self-doubt afterward. Let's talk about it.
- Words That Changed My Outlook on Life Feynman, Chaplin, and the movie Hyakumeter: from an insecure boy to someone capable of helping others, sharing the reflections and life philosophies that shaped me most.
- N Benefits of an Independent Website Why spend time running your own blog in an era dominated by short-form video and social media? Here are my thoughts after nearly a decade of blogging.
- Reflections on Fitness and Weight Training Sharing my thoughts and journey with weight training over the past period.