Impressions (Leaving MySQL)
# Random TalkThis 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
-
/devnote/2021-12-07-postgre-sql-note-index/ ↩
Related Posts
- A Sentence That Changed My Outlook on LifeFeynman, Chaplin, and the film *100 Meters*—from an insecure teenager to someone who can help others, this is a sharing of the thoughts and attitudes that have influenced me the most.
- The N Benefits of Having Your Own WebsiteWhy bother maintaining your own blog in this era of short-form video and social media? Here are my thoughts after writing a blog for nearly ten years.
- Fitness (Weight Training) ReflectionsSharing my recent weight-training reflections
- Rights and Responsibilities: The Root of Workplace InvolutionHow do you make employees work overtime every day? How do you make them work as hard as a boss? Give them the same equity.