BestHub
Sign in
Architecture & Thinking
Author

Architecture & Thinking

🍭 Frontline tech director and chief architect at top-tier companies 🥝 Years of deep experience in internet, e‑commerce, social, and finance sectors 🌾 Committed to publishing high‑quality articles covering core technologies of leading internet firms, application architecture, and AI breakthroughs.

179
Articles
0
Likes
1.1k
Views
0
Comments
Recent Articles

Latest from Architecture & Thinking

100 recent articles max
Architecture & Thinking
Architecture & Thinking
Apr 29, 2026 · Backend Development

Must‑Know CompletableFuture: Usage, Best Practices, and Real‑World Scenarios

This article explains why CompletableFuture replaces traditional Future in high‑concurrency Java applications, demonstrates core APIs such as runAsync, supplyAsync, thenApply, allOf, anyOf, thenCombine, and exception handling, and provides detailed code examples—including serial, parallel, aggregation, and an e‑commerce order‑processing case—to guide robust asynchronous programming.

Asynchronous ProgrammingCompletableFutureJava
0 likes · 26 min read
Must‑Know CompletableFuture: Usage, Best Practices, and Real‑World Scenarios
Architecture & Thinking
Architecture & Thinking
Apr 27, 2026 · Artificial Intelligence

50+ High-Value AI Skills for 2026: A Guide to Boosting Developer Efficiency

The article presents a data‑driven review of more than 50 AI Skills, grouped into five core scenarios, detailing their installation counts, key functions, and practical impact, to help senior developers choose the most effective plugins for accelerating development, design, documentation, and product growth.

AIAI SkillsAutomation
0 likes · 27 min read
50+ High-Value AI Skills for 2026: A Guide to Boosting Developer Efficiency
Architecture & Thinking
Architecture & Thinking
Apr 26, 2026 · Artificial Intelligence

DeepSeek V4: How Million‑Token Context and Open‑Source Design Redefine AI Ecosystems

DeepSeek V4, released on April 24, 2026, introduces a 1‑million‑token context via DSA sparse attention, offers Pro and Flash variants, adapts to domestic AI chips, cuts compute costs dramatically, and leverages open‑source weights to challenge the dominance of closed‑source LLMs, reshaping the global AI landscape.

AI hardware adaptationAgentic AIDeepSeek-V4
0 likes · 9 min read
DeepSeek V4: How Million‑Token Context and Open‑Source Design Redefine AI Ecosystems
Architecture & Thinking
Architecture & Thinking
Apr 24, 2026 · Databases

SQL Index Failure Scenarios: Essential Pitfalls and Fixes Every Developer Must Know

This article systematically examines why MySQL indexes can become ineffective—covering function calls, implicit casts, LIKE patterns, OR conditions, composite‑index left‑most rules, data distribution, and ORDER/GROUP mismatches—while providing concrete code examples, production case studies, and actionable optimization techniques.

B+ treeMySQLQuery Planning
0 likes · 26 min read
SQL Index Failure Scenarios: Essential Pitfalls and Fixes Every Developer Must Know
Architecture & Thinking
Architecture & Thinking
Apr 22, 2026 · Backend Development

Why Traditional Limit‑Offset Fails on Billion‑Row Tables and How to Fix It

This article dissects the performance collapse of classic LIMIT‑OFFSET pagination on tables with hundreds of millions of rows, explains the underlying execution steps, presents benchmark data, and walks through a progressive set of solutions—including index tuning, Seek pagination, Cursor pagination, and sharding—complete with Go code examples and practical trade‑offs.

Cursor PaginationMySQLgolang
0 likes · 30 min read
Why Traditional Limit‑Offset Fails on Billion‑Row Tables and How to Fix It
Architecture & Thinking
Architecture & Thinking
Apr 16, 2026 · Databases

Mastering Database Performance: From Slow Queries to Deadlock Resolution

This guide presents a systematic, end-to-end diagnostic workflow for high-concurrency database environments, covering slow-SQL detection, execution-plan analysis, lock-conflict monitoring, deadlock investigation, and practical optimization techniques, illustrated with real-world cases, commands, and tool integrations to swiftly resolve performance bottlenecks.

Database DiagnosticsDeadlockLock Monitoring
0 likes · 18 min read
Mastering Database Performance: From Slow Queries to Deadlock Resolution
Architecture & Thinking
Architecture & Thinking
Mar 20, 2026 · Backend Development

Why Redis’s Single‑Threaded Design Beats Multithreading in Real‑World Performance

This article explains how Redis achieves lightning‑fast performance with a single‑threaded architecture by leveraging in‑memory operations, IO multiplexing, and event‑driven design, and it details the four key advantages of this approach as well as the evolution introduced in Redis 6.0.

IO MultiplexingRedisepoll
0 likes · 12 min read
Why Redis’s Single‑Threaded Design Beats Multithreading in Real‑World Performance