BestHub
Sign in
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 29, 2026 · Artificial Intelligence

What Makes DeepSeek V4 Different? A Deep Technical Dive into Its Innovations

DeepSeek V4 introduces a suite of architectural breakthroughs—including mixed‑expert MoE, manifold‑constrained hyper‑connections, CSA/HCA hybrid attention, and FP4 quantization—that slash inference cost by up to tenfold while delivering million‑token context, competitive benchmarks, dual model variants, and a disruptive pricing strategy.

AI model benchmarkAgentic AIDeepSeek-V4
0 likes · 41 min read
What Makes DeepSeek V4 Different? A Deep Technical Dive into Its Innovations
Architect's Guide
Architect's Guide
May 28, 2026 · Artificial Intelligence

How Claude Code Prompt Caching Cuts AI Costs by Up to 90% and Boosts Efficiency

Prompt Caching in Anthropic's Claude Code replaces repeated processing of identical prompt prefixes with a prefix‑hash cache, slashing input‑token costs by up to 90%, reducing first‑token latency by 79%, and improving throughput, while preserving model output exactly as if no cache were used.

AI engineeringCache MetricsCache invalidation
0 likes · 30 min read
How Claude Code Prompt Caching Cuts AI Costs by Up to 90% and Boosts Efficiency
Architect's Guide
Architect's Guide
May 27, 2026 · Backend Development

Comprehensive Collection of Java Backend Architecture Diagrams

This article compiles over thirty detailed architecture diagrams covering Java class loaders, JVM, Spring, Hibernate, Android, Linux kernel, cloud computing, and various enterprise technologies, offering developers a visual reference library for understanding and designing Java backend systems.

HibernateJVMJava
0 likes · 5 min read
Comprehensive Collection of Java Backend Architecture Diagrams
Architect's Guide
Architect's Guide
May 25, 2026 · Frontend Development

Is WebSocket Still the Best Choice for Real‑Time Push? A Comparison with SSE and Polling

The article compares three server‑to‑client push techniques—polling, WebSocket, and Server‑Sent Events (SSE)—detailing their mechanisms, advantages, drawbacks, browser compatibility, and suitable use cases, and provides step‑by‑step Node/Express demos showing how to implement SSE in a simple web page.

ExpressJavaScriptNode.js
0 likes · 12 min read
Is WebSocket Still the Best Choice for Real‑Time Push? A Comparison with SSE and Polling
Architect's Guide
Architect's Guide
May 23, 2026 · Databases

SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s

This article walks through a MySQL 5.6 case study where a sub‑query that originally took over eight hours is accelerated to a few milliseconds by analyzing the execution plan, adding single‑column and composite indexes, rewriting the query as EXISTS or JOIN, and applying best‑practice indexing techniques.

JOINMySQLSQL optimization
0 likes · 13 min read
SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s
Architect's Guide
Architect's Guide
May 22, 2026 · Databases

How Indexes Speed Up Database Queries: A Clear Explanation

The article explains how database indexes work by comparing them to a book’s table of contents, describes underlying storage mechanisms, demonstrates binary search on sorted records, and discusses the benefits, trade‑offs, and common pitfalls of using clustered and non‑clustered indexes.

Database IndexesSQL optimizationbinary search
0 likes · 12 min read
How Indexes Speed Up Database Queries: A Clear Explanation
Architect's Guide
Architect's Guide
May 21, 2026 · Operations

Still Using Xshell? Discover Tabby’s Modern SSH and SFTP Features

This guide introduces Tabby, a cross‑platform open‑source terminal emulator with built‑in SSH and SFTP support, walks through installing the appropriate package, configuring remote connections, using the SFTP panel, and customizing themes and shortcuts for a smoother workflow.

Cross-platformSFTPSSH
0 likes · 3 min read
Still Using Xshell? Discover Tabby’s Modern SSH and SFTP Features
Architect's Guide
Architect's Guide
May 20, 2026 · Databases

30 Essential SQL Query Optimization Techniques

This article presents thirty practical SQL optimization tips, covering index usage, avoiding full‑table scans caused by operators like !=, NULL checks, OR, LIKE, IN, functions, and expressions, as well as best practices for temporary tables, cursors, and transaction size to improve database performance.

SQLdatabaseindexes
0 likes · 10 min read
30 Essential SQL Query Optimization Techniques
Architect's Guide
Architect's Guide
May 15, 2026 · Backend Development

One‑Line HTTP Requests with OKHttpUtil: A Minimal Java Wrapper

The article introduces OKHttpUtil, a lightweight wrapper around Square’s OkHttp library that enables Java developers to perform HTTP GET, POST, file upload, and download operations with a single line of code, includes Maven setup, Spring Boot integration, fluent API usage, and examples of wrapping external services such as eBay.

API wrapperHTTP ClientHTTP request
0 likes · 10 min read
One‑Line HTTP Requests with OKHttpUtil: A Minimal Java Wrapper