May 2023

# The Method I Used Until Now

When setting or retrieving the auto_increment value for a table in MySQL, starting from MySQL 8, information_schema is cached. As a result, retrieving AUTO_INCREMENT consecutively may yield outdated values. This article discusses countermeasures for such situations.

When encrypting Windows storage with BitLocker, the key file can be saved as a file. However, when trying to grep for a matching file, it doesn't work because the file encoding is UTF-16. Therefore, I wrote a script in Python to handle this issue.

When you encounter the error "library not found for -lzlib" while trying to run `pip install mysqlclient` on an M2 Mac, setting the environment variables `MYSQLCLIENT_LDFLAGS` and `MYSQLCLIENT_CFLAGS` can help resolve the issue.

Here is an overview of a blog article written in Japanese: "This code uses the SpeechSynthesisUtterance's speech method with await. It performs the speech synthesis process synchronously in a web browser."