May 2023

Use the host SSH key in Docker build to access private repos. Combine `DOCKER_BUILDKIT=1` and `--mount=type=ssh` with `StrictHostKeyChecking=no`.

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.

Build a Chromium kiosk for web signage on an OrangePi Zero 2W — OS install, Wayland setup, and auto-start configuration.

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.

Run a web signage kiosk on a Raspberry Pi with Playwright + Chromium — Python script and systemd unit example.