Author

liandk

Seasoned Java and mobile developer with years of experience, specializing in mini‑programs, public accounts, and full‑stack front‑end development. In the AI era, I continuously learn to broaden my knowledge and evolve. I revived a public account I started a decade ago during a dessert‑startup venture, using code as a vessel and knowledge as a companion. I share personal projects, technical articles, programming tips, and growth insights—let’s improve together and set sail.

129

Articles

Likes

698

Views

Comments

Latest from liandk

100 recent articles max

liandk

Aug 10, 2026 · Backend Development

Microservice Resilience: Rate Limiting, Circuit Breaker, Degradation & Debounce

To keep microservice systems stable, the article explains why fault‑tolerance is essential, defines service avalanches, and details four core safeguards—rate limiting, circuit breaking, degradation, and debounce—covering their principles, typical use cases, deployment layers, and how they work together to prevent cascading failures.

Circuit BreakerFault ToleranceMicroservices

0 likes · 8 min read

Microservice Resilience: Rate Limiting, Circuit Breaker, Degradation & Debounce

liandk

Aug 10, 2026 · Databases

INSERT Basics: A Beginner’s Hands‑On Guide to Adding Data

This tutorial explains the purpose of the SQL INSERT statement, compares column‑specified and full‑field syntax, shows single‑row and batch‑row examples using a UserInfo table, and highlights common pitfalls such as column‑value ordering, quoting rules, and auto‑increment IDs.

Data InsertionINSERTSQL

0 likes · 2 min read

INSERT Basics: A Beginner’s Hands‑On Guide to Adding Data

liandk

Aug 9, 2026 · Databases

Beginner’s Guide: Essential Table Operations – Create, View, and Delete Tables

This tutorial walks beginners through the fundamentals of database tables—explaining fields, data types, and constraints—while demonstrating how to create a standard user table, view its structure, and safely delete it using SQL Server commands.

Data TypesDatabase TablesSQL Basics

0 likes · 3 min read

Beginner’s Guide: Essential Table Operations – Create, View, and Delete Tables

liandk

Aug 8, 2026 · Databases

SQL for Absolute Beginners: Core Database Operations (Create, View, Delete)

This tutorial walks SQL newcomers through the three essential database commands—creating a database, listing all databases, switching to a specific one, and safely dropping a database—providing copy‑paste code, practical scenarios, and beginner‑focused pitfalls.

Database BasicsDatabase OperationsSQL

0 likes · 3 min read

SQL for Absolute Beginners: Core Database Operations (Create, View, Delete)

liandk

Aug 8, 2026 · Backend Development

Fixing MQ’s Four Major Issues: Loss, Duplication, Backlog, and Out‑of‑Order Messages

The article explains how to build a production‑grade MQ architecture by addressing the four critical pitfalls—message loss, duplicate consumption, backlog, and out‑of‑order delivery—through producer ACK retries, persistent storage, manual ACKs, idempotent business logic, dead‑letter queues, consumer scaling, and partitioned ordering.

Dead Letter QueueMQMessage Queue

0 likes · 7 min read

Fixing MQ’s Four Major Issues: Loss, Duplication, Backlog, and Out‑of‑Order Messages

liandk

Aug 5, 2026 · Databases

Mastering Redis High Availability: Replication, Sentinel, and Cluster Explained

The article explains why Redis must be highly available and walks through three progressive architectures—master‑slave replication, Sentinel automatic failover, and Redis Cluster—detailing their mechanisms, advantages, drawbacks, and when to choose each for small, medium, or large‑scale production systems.

ClusterHigh AvailabilityOperations

0 likes · 7 min read

Mastering Redis High Availability: Replication, Sentinel, and Cluster Explained

liandk

Aug 2, 2026 · Databases

Why Transaction Timeouts and Deadlocks Occur: Master MySQL Row, Table, Gap Locks

This article breaks down MySQL’s locking mechanisms—table, row, and gap locks—explaining their principles, performance trade‑offs, when they are triggered, how they relate to index usage, and provides practical deadlock avoidance techniques and a concise cheat‑sheet for common concurrency problems.

Gap LockLocksRow Lock

0 likes · 7 min read

Why Transaction Timeouts and Deadlocks Occur: Master MySQL Row, Table, Gap Locks

liandk

Jul 31, 2026 · Databases

Why Transactions Are Essential: Master ACID, Isolation Levels, and Prevent Dirty/Phantom Reads

This article explains why database transactions are a core backend skill, breaks down the four ACID properties, clarifies dirty read, non‑repeatable read and phantom read, compares the four isolation levels, and offers practical guidelines for choosing the right level in production.

ACIDDirty ReadPhantom Read

0 likes · 7 min read

Why Transactions Are Essential: Master ACID, Isolation Levels, and Prevent Dirty/Phantom Reads

liandk

Jul 31, 2026 · Backend Development

Run a Complete MCP 2026 Stateless Demo – Beginner‑Friendly Guide

This guide walks through the new MCP 2026 update—showing how to build a stateless FastAPI server and a TypeScript client, run curl calls, and highlights benefits such as session‑free requests, cacheable tool lists, easy load‑balancing, and optional OAuth2 protection.

FastAPIMCPREST

0 likes · 7 min read

Run a Complete MCP 2026 Stateless Demo – Beginner‑Friendly Guide

liandk

Jul 25, 2026 · Fundamentals

Why 90% of Developers Misunderstand Sync vs Async vs Blocking vs Non‑Blocking (And How to Fix It)

The article clarifies the often‑confused concepts of synchronous, asynchronous, blocking, and non‑blocking operations by introducing two independent dimensions, illustrating each with real‑world analogies, mapping them to BIO/NIO/AIO models, and offering practical guidance for choosing the right approach in different scenarios.

AIONIOSynchronization

0 likes · 5 min read

Why 90% of Developers Misunderstand Sync vs Async vs Blocking vs Non‑Blocking (And How to Fix It)