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
Related Posts
- Sunwide ViewSunwide View and Vigilante Justice
- ShuraSpring and Shura
- Tang PoetryTang poetry is pretty suitable for working people to read, right? The more miserable someone’s life is, the better their poetry seems to be written. Looking at how pitiful they were can help us reflect on ourselves.
- AttemptWrite on manuscript paper, scan it, and turn it into an image