This post was actually written on March 25, 2023, but completely forgot to publish. During that period, I wrote Takahē articles and translated psycopg3 documentation into Japanese at the same time.

I continue translating psycopg3 into Japanese one by one. It’s fun to learn unknown PostgreSQL features and how psycopg3 is handling connections and queries under the hood for database libraries in Python!

It was already a half year ago, but I had an opportunity to write two long articles about Takahē in Japanese on the website gihyo.jp, managed by Gijutsu-Hyoron Co., Ltd. (技術評論社), one of the famous technical book publishers in Japan:

The empty Gitpod environment does not have gcloud command to interact with Google Cloud. So we need to install it by ourselves.

I searched Django nice project templates I can use to make a simple personal project. There are two Django project templates I’m interested in: Cookiecutter Django and DjangoX. This is my first impression of those project templates.

In the previous article Temporarily activate gcloud configurations with CLOUDSDK_ACTIVE_CONFIG_NAME, I explained how we can temporarily activate the gcloud configurations. In this post, I will enhance this with fzf for the interactive search.

Note that I’m using 🐟 fish shell.

There have been a lot of events, information, and data since the beginning of COVID-19. But I haven’t recorded almost any records on my perspective on COVID-19. I’d like to record at least the current status, especially how I’m checking the latest information and brief summary of the current status in Japan.

When I was checking the electricity production data in Taiwan from Taipower (台湾電力公司) website for this issue, I encountered a character encoding issue.

Flask supports the SocketIO connection via flask-socketio library. It’s written by Miguel Grinberg (@miguelgrinberg) as well as its underlining python-engineio and python-socketio.

I tracked down the path to set the custom engineio logger.

You can use CLOUDSDK_ACTIVE_CONFIG_NAME to switch between multiple configurations temporarily.