Blog

Optimizing a Slow MySQL …

A wave planning list in a WMS application took about six seconds to return one page of results. This note records the investigation path and the evidence behind the final optimization direction.

Identifiers and environment details have been anonymized. The SQL shape, measurements, and decisions are …

Recent Bug Fixes from My …

Recently I spent a lot of time fixing small but important bugs in logistics systems. Most of them were not difficult because of one single line of code. They were difficult because the same page, status, interface, and database field were used by several business steps.

This post records several …

Fixing VPS Connection …

This case records how I restored fichil.com from a basic server reachability failure to a working Hugo site served by Nginx.

Problem

The browser returned ERR_CONNECTION_REFUSED. This usually means the domain resolved to the server, but nothing was accepting traffic on the expected port.

For this …

Maintaining a Hugo …

Background

I built fichil.com for a simple reason: I wanted my own technical blog to record development work, deployment notes, troubleshooting steps, and open-source progress.

As the site grew, keeping it only as files on a server was not enough. I needed the source code, content, deployment steps, …