A public account focused on workplace, career growth, team management, and self-improvement. The author is the writer of books including 'SpringBoot Technology Insider' and 'Drools 8 Rule Engine: Core Technology and Practice'.
This guide explains why MySQL cannot index JSON columns directly and demonstrates two practical work‑arounds—using generated columns in MySQL 5.7 and functional indexes in MySQL 8.0.13—to efficiently index a nested request.email field for fast queries.
Drawing on interviews with hundreds of technical candidates, this article outlines practical resume‑screening criteria, the three key interview dimensions—problem‑solving, fundamentals, and soft skills—and compares the strengths of Go developers from Java, PHP, and native Go backgrounds.
This article explains the performance differences among MySQL's COUNT(*), COUNT(1), and COUNT(column) forms, showing that COUNT(*) and COUNT(1) are equivalent and generally faster than counting specific columns, and provides practical recommendations for accurate row counting.
This article explains the fundamental differences between MySQL VARCHAR and CHAR types, covering their definitions, length limits, storage overhead, character‑set effects, practical examples, and guidelines for choosing the appropriate column type in database design.
This article examines common misconceptions about MySQL VARCHAR—why 255 was historically used, the real maximum length, performance differences between short and long definitions, character‑set impacts on storage, and why aligning sizes to powers of two offers no real benefit.
The article compares traditional rule‑engine architectures with AI‑driven models, explains their differing characteristics, outlines when deterministic rule matching is preferable over flexible AI inference, and recommends practical technologies such as Drools for rule‑based solutions and LLM‑based RAG/Agent frameworks for AI‑centric scenarios.
An in‑depth tutorial walks through the five core SQL language families—DDL, DML, DQL, DCL, and TCL—explaining their purposes, key commands, and practical examples, while highlighting differences and usage tips for database schema definition, data manipulation, querying, permission control, and transaction management.
This tutorial walks through preparing a CentOS 8 server, uninstalling any existing Docker packages, adding a Tencent Cloud mirror, installing and starting Docker, configuring a non‑root Docker user group, and finally pulling, configuring, and running an Nginx container with essential HTTPS settings.
This article explains the Server‑Sent Events (SSE) technology behind ChatGPT's streaming responses, compares SSE with WebSocket, outlines its core implementation steps, and provides a complete Spring Boot example for pushing live stock prices to browsers.
A seasoned Java engineer shares his journey transitioning to Rust, highlighting Rust’s advantages for CLI tools, superior resource utilization, easier concurrency and async programming, while also acknowledging Java’s strengths in rapid feature delivery, mature ecosystem, and ease of learning, and discussing practical migration considerations.
