Kalan's Blog

Kalan 頭像照片,在淡水拍攝,淺藍背景

四零二曜日電子報上線啦!訂閱訂起來

Software Engineer / Taiwanese / Life in Fukuoka
This blog supports RSS feed (all content), you can click RSS icon or setup through third-party service. If there are special styles such as code syntax in the technical article, it is still recommended to browse to the original website for the best experience.

Current Theme light

我會把一些不成文的筆記或是最近的生活雜感放在短筆記,如果有興趣的話可以來看看唷!

Please notice that currenly most of posts are translated by AI automatically and might contain lots of confusion. I'll gradually translate the post ASAP

Impressions (Leaving MySQL)

This morning I came across this Leaving MySQL article. If there's one main point in this article, it would be what the author wrote:

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

In a footnote, the author specifically mentioned that using MariaDB wouldn't be any better.

I first learned about PostgreSQL because of Ruby on Rails. At that time, I encountered some issues with setting up MySQL, so I used PostgreSQL as the database. Since then, whenever I deal with databases, I always choose PostgreSQL.

Later on, I discovered some attractive features of PostgreSQL, such as support for JSON type (which I remember MySQL didn't have at that time), and its rich indexing options1. I even tried using PostGIS for practicing geospatial applications. Overall, PostgreSQL has always provided me with a great experience, so please continue to choose PostgreSQL.

Footnotes

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

Prev

Amazon Polly - Text-to-Speech, the effect is very remarkable.

Next

From a Frontend Perspective: SwiftUI

If you found this article helpful, please consider buy me a drink ☕️ It'll make my ordinary day shine✨

Buy me a coffee