This is where I record my technical thoughts and insights. These are reflections on programming, system design, databases, infrastructure, and the deeper understanding that comes from building and working with complex systems.

2026 Q1

Multi-Third-Party Integration: Factory + Strategy in Practice

When integrating multiple external systems, treat each integration as an independent strategy and use a factory to select the implementation at runtime. Differences stay isolated in their own implementations; the main flow only cares about ‘who to call’ and ‘how to orchestrate’.

Distributed Lock vs Row Lock vs Transaction

These three mechanisms solve different problems at different layers: distributed locks protect business execution, row locks protect data mutation, and transactions define lock scope and atomicity.

2025 Q4

Using Redis Sorted Sets for Recent User Search History

Treat recent search history as ephemeral user behavior, not core business data. Redis Sorted Sets provide a natural fit: O(log N) writes, automatic ordering, de-duplication, and bounded size—all without turning a lightweight behavior signal into a database concern.

2025 Q3

How Node.js Achieves High Concurrency on a Single CPU Core

Node.js achieves high concurrency not by multi-threading, but through its event-driven, non-blocking I/O model. It efficiently overlaps I/O waiting time across requests, allowing a single thread to handle thousands of connections.

2025 Q2

SQL in the AI Era

SQL has evolved from a query language into the data control layer of intelligent systems. Modern AI pipelines depend on reliable, interpretable, and governable access to structured data.