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.
This article explains AVL balanced binary trees, covering the balance factor, four rotation types (LL, RR, LR, RL), a complete Python implementation with height updates, real-world use cases, and a comparison showing AVL's guaranteed O(log n) query performance versus BST's degradation to O(n).
This comprehensive guide covers MySQL read-write separation from fundamentals to production implementation, including master-slave replication principles, replication lag causes and three enterprise-grade solutions, one-master-multi-slave architecture patterns, MHA automatic failover, Sharding-JDBC middleware configuration, and five critical production pitfalls to avoid.
This article explains binary search trees (BST), detailing their left‑small right‑large ordering rule, core properties, and why they outperform ordinary binary trees with O(log n) search, while covering insertion, search, deletion, in‑order traversal code in Python, common pitfalls, and real‑world use cases.
This guide explains why video recordings that upload correctly on a real device can fail after TestFlight or cloud packaging, detailing the mismatched file‑system paths between plus.io, iOS Documents/Library, and Android Movies directories, and provides step‑by‑step fixes to ensure reliable uploads to Alibaba Cloud VOD.
This article introduces binary trees, explains key terminology and four common tree shapes, details four traversal methods, provides a complete Python implementation with sample output, and highlights real‑world uses and beginner pitfalls.
Many developers write messy SQL or generate slow reports because they don’t know built‑in functions; this guide compiles the most frequently used string, date, math, and conversion functions—complete with ready‑to‑copy examples—to handle 99% of everyday data‑processing scenarios.
This article explains what MySQL sharding and partitioning are, when they are necessary, outlines four splitting patterns, details four sharding key strategies, shows a production‑ready Sharding-JDBC configuration, and discusses five common distributed challenges with practical solutions.
This article explains how hash tables achieve near‑constant‑time lookups by hashing keys to direct storage slots, compares their speed to arrays, linked lists, stacks, and queues, shows real‑world uses, demonstrates a full Python implementation, and warns about common pitfalls.
This tutorial explains the FIFO principle of queues with everyday analogies, compares stacks and queues, lists core operations, provides a full Python implementation, demonstrates real‑world scenarios like server requests and printer jobs, and highlights common beginner pitfalls.
This guide explains what the MySQL slow query log records, why it is essential for production, when and how to enable it temporarily or permanently, key parameters to tune, how to simulate slow queries, interpret log fields, use mysqldumpslow for aggregation, follow a step‑by‑step optimization pipeline, and avoid common pitfalls.
