Latest Articles

Python script to copy AWS RDS MySQL data from production to a dev environment fast — table-level `mysqldump` + `mysql` piping.

Here's an overview of the blog post in English: --- This blog post introduces a function to obtain a datetime N months ago, without using the `dateutil` library. The function was created because `dateutil` was not available in the Python Data Source for Re:dash. ---

During an IT audit, it was necessary to represent the scale of the application. To achieve this, I decided to consider the total number of URLs in Django as an indicator of the application's scale.

I wrote a script to download the version of chromedriver that matches the currently installed version of Chrome.

Shell script to launch Chrome on macOS with a fixed window size from the command line — combine `--window-size` and `--window-position`.

Build a macOS Service (Quick Action) that sends `find` results to the clipboard via `pbcopy` — works back to Big Sur.

Here is a template code for creating a simple HTML application using Bottle.

Build an OpenVPN server that routes all clients in a segment through the VPN — from CA cert issuance to distributing `client.ovpn`.

Convert a Slack web URL into the slack:// scheme to open a specific channel directly from the command line, Raycast Quicklink, or Alfred.

Debug and work around `multipart/form-data` boundary issues during file upload in macOS WebKit (WKWebView / Safari).

Use `mkdir -p ... && cd $_` on macOS to chain create-and-enter reliably without race conditions.

Summary of the blog post in English: "Django Logging Configuration: Output to Console Instead of File"

Return a common post-login redirect target in Django Allauth without specifying a SocialAccount — how `LOGIN_REDIRECT_URL` behaves and how to override it.

Things to try when a Mac HDMI display occasionally freezes — change the refresh rate with `displayplacer`, reseat the cable, etc.

Why Google Japanese Input asks for 'Full Disk Access' on macOS Big Sur, and what happens if you decline the permission.

Workaround when PyCharm Python 3.6 Run/Debug Configurations fail to load native extensions like `fibers`.

Fix `pipenv install` failing with `RuntimeError: location not created nor specified` — remove the venv with `pipenv --rm` and let pipenv recreate it.

Why switch a Django Docker image from Alpine + uWSGI to Debian + Daphne (ASGI), with example Dockerfile and Kubernetes manifest changes.

Checklist of timeout settings (Ingress, uWSGI, Django, nginx) to verify so slow responses don't get cut off in a Kubernetes + uWSGI stack.

Packages required (`apk add ...`) to `pip install cryptography` in an Alpine Linux Docker image, and how to handle common build errors.