Latest

Reducing PostgreSQL Storage on TencentDB by Cleaning pg_log

A walkthrough of investigating a false PostgreSQL disk usage alert on TencentDB and reducing storage by cleaning pg_log retention.

Caching Terraform Modules in a Kubernetes CI Pipeline

Building a manual module cache on a shared PVC to avoid terraform init git-cloning every module from scratch in ephemeral Jenkins agents.

Caching Terraform Providers in a Kubernetes CI Pipeline

Adding a PVC-based provider cache to speed up terraform init in ephemeral Jenkins CI agents.

Migrating SonarQube from AWS to Tencent Cloud

A practical walkthrough of migrating SonarQube from AWS to Tencent Cloud, covering database migration, persistent storage, custom plugins, GitOps deployment, and the lessons learned along the way.

Upgrading Ghost and hitting MariaDB's charset trap

Ghost forces `DEFAULT CHARACTER SET utf8mb4` on every CREATE TABLE, which makes MariaDB use `utf8mb4_general_ci` instead of `utf8mb4_unicode_ci`, breaking foreign keys on collation-mismatched columns.

Cleaning Up My Instagram Following List with Python

A walkthrough on exporting Instagram data, parsing followers and following JSON files, and finding accounts that do not follow you back.

Expanding EC2 Root EBS Volume Without Downtime

Expanded an EC2 root EBS system volume on Ubuntu 24.04.4 LTS (ARM) without downtime using Terraform.

Cleaning Up a 600k+ Object Versioned S3 Bucket Using Lifecycle Policies

Deleting a versioned S3 bucket with 600k+ objects using aws s3 rm --recursive can become painfully slow, especially when delete markers and old versions remain behind. This write-up documents using S3 lifecycle policies instead to let AWS handle the cleanup internally.

Rundeck on Kubernetes with RDS and S3 Backend

Rundeck deployed on EKS as a stateless job runner, using RDS for state and S3 for node inventory. Solves node loss from spot instances, uses a bastion for execution, and keeps setup minimal without introducing full CI/CD.

WebSocket-Based Jenkins Agents in a Reverse Proxy Environment

Switching Jenkins Kubernetes agents from JNLP TCP (port 50000) to WebSocket fixed connectivity issues behind CLB + Nginx L7. WebSocket fits HTTP(S) routing and stabilizes agent-to-controller communication in a proxy-restricted environment.

Misreading Terraform Plan Led to Instance Destruction

I made a small Terraform change and assumed it would be safe. The plan already showed that the instance would be replaced, but I did not fully process it. Within minutes, my server was gone. This write-up explains what happened and what I changed afterward.

Remove “et al.” in IEEE Zotero Style (Show All Authors)

This guide shows a simple configuration tweak in the CSL style editor to disable “et al.” and force full author display, without needing any programming knowledge.

Understanding Non-Suicidal Self-Injury and Informal Support Approaches

A practical overview of non-suicidal self-injury (NSSI) and how to support someone from a non-clinical perspective, based on personal motivation to better understand and respond to a close friend’s experience.

Jenkins on Docker (VM) with Kubernetes Agents

In this write-up, I’ll walk through how I set up Jenkins running on Docker on a VM and integrated it with Kubernetes, until it’s able to provision pods directly into the cluster.