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 14, 2026 · Databases

8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them

The article enumerates eight common MySQL query patterns—such as large‑offset LIMIT, implicit type conversion, sub‑query updates, mixed ordering, unnecessary EXISTS, poor condition push‑down, early range reduction, and inefficient intermediate result handling—and shows rewritten SQL that reduces execution time from seconds to milliseconds.

JOINMySQLSQL
0 likes · 15 min read
8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them
Architect's Guide
Architect's Guide
May 13, 2026 · Big Data

Next‑Gen Visual Drag‑Drop Data Flow Platform: Features, Architecture, and Performance

The article introduces a visual drag‑and‑drop data flow platform that unifies stream and batch processing, offers version control, automatic fault tolerance, configurable data permissions, comprehensive monitoring, data alignment, and query templates, and presents single‑instance performance benchmarks of over 30k and 60k ops/s.

Data AlignmentDrag-and-DropFault Tolerance
0 likes · 7 min read
Next‑Gen Visual Drag‑Drop Data Flow Platform: Features, Architecture, and Performance
Architect's Guide
Architect's Guide
May 12, 2026 · Fundamentals

Mastering TCP, HTTP, Sockets, and Socket Connection Pools

This article walks developers through the OSI model, explains TCP's three‑way handshake and four‑way termination, contrasts TCP with UDP, addresses common networking questions, and details how to implement long‑lived socket connections and a reusable socket connection pool in Node.js.

Node.jsSocketTCP
0 likes · 15 min read
Mastering TCP, HTTP, Sockets, and Socket Connection Pools
Architect's Guide
Architect's Guide
May 11, 2026 · Backend Development

Why UUID Falls Short and How Snowflake Solves Distributed ID Generation

The article examines the limitations of UUIDs for distributed systems, outlines the strict requirements for global unique IDs, compares common approaches such as database auto‑increment and Redis, and provides a detailed analysis of Twitter's Snowflake algorithm with its structure, Java implementation, advantages, drawbacks, and mitigation strategies.

BackendJavaMySQL
0 likes · 14 min read
Why UUID Falls Short and How Snowflake Solves Distributed ID Generation
Architect's Guide
Architect's Guide
May 9, 2026 · Databases

Alibaba’s Open‑Source DataX: Fast, Easy Offline Data Synchronization

This article introduces Alibaba’s open‑source DataX tool, explains its framework‑plugin architecture for heterogeneous database sync, walks through Linux installation, job configuration, full‑ and incremental MySQL synchronization, and shares performance results and practical tips.

DataXDatabase MigrationETL
0 likes · 15 min read
Alibaba’s Open‑Source DataX: Fast, Easy Offline Data Synchronization
Architect's Guide
Architect's Guide
May 7, 2026 · Artificial Intelligence

Spring AI 2.0 vs LangChain4j: Which Should You Choose?

The article provides a side‑by‑side analysis of Spring AI 2.0 and LangChain4j, comparing their goals, version alignment, programming models, RAG and agent capabilities, ecosystem integration, learning curve, and operational considerations to help Java teams decide which library best fits their project constraints.

AI AgentsJavaLLM Integration
0 likes · 11 min read
Spring AI 2.0 vs LangChain4j: Which Should You Choose?
Architect's Guide
Architect's Guide
May 6, 2026 · Backend Development

Quickly Implement API Encryption in Spring Boot with a Single Library

This article walks through using RSA to encrypt Spring Boot API responses, covering the theory behind RSA, two security scenarios, Maven dependency setup, configuration, controller annotations, encryption/decryption code, a front‑end JavaScript example, common pitfalls, and a final security summary.

API EncryptionBackendJava
0 likes · 11 min read
Quickly Implement API Encryption in Spring Boot with a Single Library
Architect's Guide
Architect's Guide
May 5, 2026 · Backend Development

Why This Lightweight Rule Engine Lets You Ditch If‑Else Statements

The article introduces the liteflow rule‑engine framework, explains its architecture, component types, EL rule files, data‑context handling, configuration options, and demonstrates a real‑world e‑commerce workflow that replaces verbose if‑else code with concise rule definitions.

JavaLiteFlowSpring Boot
0 likes · 9 min read
Why This Lightweight Rule Engine Lets You Ditch If‑Else Statements
Architect's Guide
Architect's Guide
May 4, 2026 · Industry Insights

Would You Accept a Salary Made of Base Pay Plus Tokens?

The article explains how "Token"—the smallest unit of AI processing—has become a measurable, priceable, and allocatable resource that companies are treating as a fourth form of compensation, shifting focus from time to AI‑amplified ability and productivity.

AITokencompensation
0 likes · 5 min read
Would You Accept a Salary Made of Base Pay Plus Tokens?