Latest Articles
Summary of the Japanese blog article: Cases of MacBook Pro (Intel) suddenly slowing down. This often occurs when recovering from standby. Keyboard input becomes extremely sluggish, making it impractical to use. Previously, the cause of this issue was unknown, but it has now been determined that the CPU frequency of the Mac is clocking down.
Here is an overview in English of a blog post discussing a web application: The code for a web application that takes a URL included as a parameter in a request URL, makes a request to that URL using headless Chrome, captures a screenshot, and returns it in the response. The service is implemented in Python using Bottle and gevent.
I upgraded Ubuntu from version 18 to 20, and after the upgrade, I noticed that when retrieving data from MySQL 5.7 RDS using Django, all Japanese characters were displayed as ????????. Running `mysql> show variables like "%chara%";` revealed that character_set_client and other character sets were set to latin1. Ideally, these character sets should be set to utf8mb4.
When specifying a CharField in Django Admin's list_filter, if the CharField does not have choices specified, it will fetch all distinct values from the records, which can be quite slow if there's no index. In such cases, if choices can be specified for the CharField, doing so will eliminate the need for an SQL query, significantly speeding up the process.
When installing Visual Studio Code, you will be asked whether to add it to the PATH. By turning this option ON, you will be able to start VSCode using the `code` command. However, the `code` command is actually `code.cmd`, and just using `code` will not allow it to be started from Flutter's `Process.run`. Therefore, you need to include the `.cmd` extension.
The dio library for Dart (Flutter) (https://pub.dev/packages/dio) is user-friendly compared to commonly used HTTP libraries, as it allows for easy handling of cancellations, GET parameters, timeouts, JSON, and more. However, in version 3.x, there is an issue where all HTTP headers are sent in lowercase.
Here's the overview of the Japanese blog article translated into English: "RUN apk --no-cache add tzdata \ && cp /usr/share/zoneinfo/Asia/Tokyo /etc/localtime \ && apk del tzdata or ENV TZ=Asia/Tokyo RUN apk --no-cache add tzdata Which one to choose? Using the former along with ENV TZ= does not work properly."