Dedicated to sharing programmer-architect skills—Java backend, system, microservice, and distributed architectures—to help you become a senior architect.
This article explains the fundamentals of database indexing, covering what indexes are, their advantages and drawbacks, underlying structures such as hash tables, B‑tree and B+‑tree, different index types (clustered, non‑clustered, primary, secondary) in MySQL, and practical examples with code snippets.
The article examines the need for Multi‑Agent Communication Protocols (MCP), outlines the limitations of single‑agent and centralized systems, compares MCP with other interaction methods, reviews current research and industrial applications, and highlights future directions such as hardware integration, bio‑inspired mechanisms, and blockchain convergence.
Learn how to restrict API calls per user within a specific time window by creating a custom @RequestLimit annotation, an interceptor that checks Redis counters, and configuring Spring Boot's WebMvc to enforce rate limiting, with complete code examples and usage instructions.
This article presents a comprehensive set of SQL performance guidelines, covering index creation, avoiding costly operators, rewriting predicates, using proper joins, limiting temporary objects, and best practices for query design to prevent full table scans and improve overall database efficiency.
Explore Redis cache eviction policies, understand how strategies like allkeys‑lru, volatile‑ttl, and noeviction work, and learn practical solutions for cache penetration, breakdown, and avalanche—including Bloom filters, mutex locks, and staggered expirations—to keep your backend resilient under high load.
Learn step‑by‑step how to create various graphical captchas—including line, circle, shear, GIF, and custom numeric or arithmetic types—in a Spring Boot application, using both a hand‑written utility class and the Hutool‑captcha library, with full code examples and controller integration.
This article demonstrates how to use Java Agent and the java.lang.instrument API to non‑intrusively measure method execution time, dynamically modify bytecode with ASM, leverage Attach for runtime instrumentation, and explore related tools like Arthas and Bytekit for tracing and debugging Java applications.
Learn how to integrate EasyExcel into a Java Spring Boot project, covering dependency setup, entity definition, utility class creation, basic and advanced export features such as multi-level headers, merged cells, custom formatting, and large data streaming, plus common pitfalls and solutions.
Jeandle, an open‑source JVM JIT compiler from Ant Group, leverages LLVM's modular optimization and code‑generation capabilities to bring unprecedented performance to Java applications, outlining its architecture, core concepts, and ambitious roadmap for future enhancements.
This article explains how a single image and the CSS -webkit-mask-image property can be used to prevent subtitles from covering on‑screen characters, replicating Bilibili's non‑obstructive bullet subtitles with a lightweight, experimental technique demonstrated through a complete HTML demo.
