Architect's Guide
Author

Architect's Guide

Dedicated to sharing programmer-architect skills—Java backend, system, microservice, and distributed architectures—to help you become a senior architect.

701
Articles
0
Likes
4.3k
Views
0
Comments
Recent Articles

Latest from Architect's Guide

100 recent articles max
Architect's Guide
Architect's Guide
May 1, 2026 · Backend Development

Senior Architects Reveal a Comprehensive Learning Roadmap for Aspiring System Designers

The article outlines a step‑by‑step learning system compiled by senior architects, covering skill foundations, source‑code analysis, distributed and microservice architectures, concurrency, performance tuning, essential Java tools, and a hands‑on e‑commerce project to help developers become well‑rounded architects.

Distributed SystemsJavaSoftware Architecture
0 likes · 7 min read
Senior Architects Reveal a Comprehensive Learning Roadmap for Aspiring System Designers
Architect's Guide
Architect's Guide
Apr 29, 2026 · Backend Development

How to Use Spring Boot, Netty, and WebSocket for Server‑to‑Client Push

This article walks through building a Netty‑based WebSocket server integrated with Spring Boot, configuring the channel pipeline, implementing custom handlers, exposing a push‑message service, and testing the end‑to‑end flow that enables the backend to push real‑time messages to web clients.

BackendJavaNetty
0 likes · 8 min read
How to Use Spring Boot, Netty, and WebSocket for Server‑to‑Client Push
Architect's Guide
Architect's Guide
Apr 28, 2026 · Backend Development

Tired of Endless if‑else? Try a Rule Engine for Cleaner Logic

The article shows how a growing list of if‑else checks for user eligibility becomes hard to maintain, then walks through designing and implementing a Java rule engine—defining rule abstractions, building an AND/OR executor, and demonstrating usage with concrete examples, while discussing its advantages and drawbacks.

BackendCode ExampleDesign Pattern
0 likes · 7 min read
Tired of Endless if‑else? Try a Rule Engine for Cleaner Logic
Architect's Guide
Architect's Guide
Apr 27, 2026 · Backend Development

How to Optimize Large Transactions in API Endpoints

The article examines why large database transactions inside API endpoints degrade performance, outlines issues such as data inconsistency, lock contention, undo‑log overhead, and DB pressure, and presents practical optimizations including removing remote RPC calls, using programmatic transactions, batch processing, splitting into smaller transactions, and asynchronous parallel execution with code examples.

Asynchronous ProcessingProgrammatic TransactionTransactions
0 likes · 9 min read
How to Optimize Large Transactions in API Endpoints
Architect's Guide
Architect's Guide
Apr 26, 2026 · Backend Development

Building a Distributed Captcha Login with SpringBoot and Redis

This article walks through the design and implementation of a distributed image‑captcha login system using SpringBoot, Kaptcha, and Redis, comparing traditional session‑based approaches with a front‑back‑end separated architecture and providing complete code examples for each component.

BackendCAPTCHARedis
0 likes · 14 min read
Building a Distributed Captcha Login with SpringBoot and Redis
Architect's Guide
Architect's Guide
Apr 25, 2026 · Databases

Three Free Tools That Can Replace Navicat for MySQL

The article reviews three free MySQL client alternatives—DBeaver, MySQL Workbench, and HeidiSQL—detailing their installation steps, supported databases, key features such as monitoring and ER diagrams, and why they can serve as practical replacements for the paid Navicat tool.

DBeaverDatabase clientHeidiSQL
0 likes · 5 min read
Three Free Tools That Can Replace Navicat for MySQL
Architect's Guide
Architect's Guide
Apr 24, 2026 · Backend Development

A Powerful Open‑Source Nginx Visual Management Platform with One‑Click Docker Deployment

This article introduces an out‑of‑the‑box Nginx visual management platform that can be deployed with a single Docker‑Compose command, offering a web UI for configuring reverse proxies, SSL termination, advanced settings, and includes step‑by‑step setup, Docker network tips, health‑check configuration, and a link to the GitHub repository.

DockerDocker ComposeNginx
0 likes · 5 min read
A Powerful Open‑Source Nginx Visual Management Platform with One‑Click Docker Deployment
Architect's Guide
Architect's Guide
Apr 23, 2026 · Databases

Is JOIN Faster Than IN in MySQL Queries? A Practical Performance Test

The article experimentally compares MySQL JOIN and IN queries across small, medium, and large data sets, showing that JOIN is generally faster for modest volumes while IN can become impractically long and error‑prone with massive lists, leaving neither approach ideal for all scenarios.

JOINMySQLPHP
0 likes · 8 min read
Is JOIN Faster Than IN in MySQL Queries? A Practical Performance Test
Architect's Guide
Architect's Guide
Apr 18, 2026 · Databases

How to Import 1 Billion Records into MySQL at Lightning Speed

This article analyzes the constraints of loading a billion 1‑KB log records from HDFS/S3 into MySQL, evaluates single‑table limits, proposes batch inserts, sharding, file‑reading techniques, task coordination with Redis, Redisson, and Zookeeper, and offers practical performance‑tuning recommendations.

Bulk InsertMySQLRedis
0 likes · 21 min read
How to Import 1 Billion Records into MySQL at Lightning Speed