Sangmin's Engineering Blog – Everyday Engineering Challenges

How “Waiting for table metadata lock” on DDL Causes Complete Table Lock For MySQL

Sangmin Lee7 months ago7 months ago017 mins

Explanation of how DDL in Waiting for table metadata lock status caused the table to be locked.

Secure Media Contents with CloudFront Signed URL

Sangmin Lee9 months ago9 months ago013 mins

Table of Contents CloudFront CloudFront is AWS’s Content Delivery Network (CDN). A CDN is a special system designed to deliver static content more efficiently. If all content is served from a specific server, the physical distance between the client and that server would increase the latency involved in delivering the content. However, a CDN like…

Inheritance in OOP is Evil

Sangmin Lee4 months ago4 months ago08 mins

Inheritance is a fundamental concept in object-oriented programming (OOP). It allows creations of a new class based on an existing class, promoting polymorphism and code reuse. However, while inheritance can be powerful, it is also almost always wrong. Let’s discuss the pitfalls of inheritance with some simple example. What is Inheritance? Inheritance allows a class…

300% Boost! How Gradle Build Scan Improved My Build Time

Sangmin Lee9 months ago9 months ago010 mins

In my project, I encountered a significant issue where it would take roughly 20 minutes to test, build, and publish the project. Since every engineer does this at least a couple of times a day, it quickly became a substantial pain point and a waste of time. Determined to resolve this, I embarked on a…

XZ Backdoor : Perpetual Curse From Perspective of A Developer

Sangmin Lee8 months ago8 months ago010 mins

The recent backdoor issue with XZ Utils has caused quite a turmoil through out the software community. However, I don’t think this will change anything. Here’s why.

Migrate From Bootstrap 5 to Pico CSS Right Now

Sangmin Lee10 months ago9 months ago014 mins

TLDR; Bootstrap seems to incorporate the least favorable aspects of both Pico CSS and Tailwind CSS. So I’ll be using Pico CSS for quick prototypes and Tailwind CSS for more complex systems.