BestHub
Sign in
Architecture Digest
Author

Architecture Digest

Focusing on Java backend development, covering application architecture from top-tier internet companies (high availability, high performance, high stability), big data, machine learning, Java architecture, and other popular fields.

2.3k
Articles
0
Likes
5.0k
Views
0
Comments
Recent Articles

Latest from Architecture Digest

100 recent articles max
Architecture Digest
Architecture Digest
Sep 19, 2025 · Backend Development

Mastering Message Idempotency: From Simple Checks to State‑Machine Solutions

This article explores the challenges of duplicate message consumption in distributed systems, explains why naive de‑duplication fails under high concurrency, and presents four progressively robust idempotency strategies—from database pessimistic locks and local message tables to a state‑machine approach with Redis or MySQL, highlighting their trade‑offs.

Message QueueRedisbackend development
0 likes · 11 min read
Mastering Message Idempotency: From Simple Checks to State‑Machine Solutions
Architecture Digest
Architecture Digest
Sep 18, 2025 · Information Security

How to Harden Login APIs: From Brute‑Force to MITM Protection

This article examines common login security risks such as brute‑force attacks, captcha bypass, IP blocking, and man‑in‑the‑middle threats, and proposes layered defenses including password‑retry limits, captcha, phone verification, HTTPS, and encrypted payloads to significantly raise the attack cost.

Brute-force protectionCaptchaHTTPS
0 likes · 10 min read
How to Harden Login APIs: From Brute‑Force to MITM Protection
Architecture Digest
Architecture Digest
Sep 16, 2025 · Databases

How to Insert 300,000 Records Efficiently with MyBatis and JDBC

This article demonstrates how to insert 300,000 rows into a MySQL table using MyBatis and JDBC, compares naïve single‑batch and per‑row approaches, presents optimized batch‑processing code with configurable batch sizes and wait times, and shares practical performance‑tuning tips such as index handling and connection‑pool configuration.

Batch InsertJDBCMyBatis
0 likes · 14 min read
How to Insert 300,000 Records Efficiently with MyBatis and JDBC
Architecture Digest
Architecture Digest
Sep 15, 2025 · Databases

When to Choose SQLite Over MySQL? Pros, Cons, and Ideal Use Cases

This article examines SQLite's lightweight nature, cross‑platform support, and easy backup, while discussing its limitations in high‑concurrency scenarios, and provides guidance on when SQLite is appropriate for prototyping or low‑resource environments versus when to avoid it.

Cross‑platformPerformanceSQLite
0 likes · 4 min read
When to Choose SQLite Over MySQL? Pros, Cons, and Ideal Use Cases
Architecture Digest
Architecture Digest
Sep 14, 2025 · Databases

Should You Replace MySQL with SQLite? Pros, Cons, and When to Use It

This article examines SQLite’s tiny footprint and embedded nature, compares it with MySQL, outlines its advantages such as cross‑platform support and easy backup, discusses its drawbacks like poor high‑concurrency handling and lack of remote access, and advises when SQLite is a suitable choice.

SQLiteUse Casesdatabase
0 likes · 4 min read
Should You Replace MySQL with SQLite? Pros, Cons, and When to Use It
Architecture Digest
Architecture Digest
Sep 11, 2025 · Databases

Master RedisInsight: Install, Configure, and Deploy Redis GUI on Kubernetes

This guide explains how Redis, a high‑performance in‑memory database, works with the RedisInsight visual tool, covering its key features, step‑by‑step installation on Linux, environment‑variable configuration, service startup, Kubernetes deployment via YAML, and basic usage for monitoring, data manipulation, and memory analysis.

Database ManagementInstallationKubernetes
0 likes · 8 min read
Master RedisInsight: Install, Configure, and Deploy Redis GUI on Kubernetes
Architecture Digest
Architecture Digest
Sep 9, 2025 · Databases

How to Safely Add a Column to a Billion‑Row Order Table Without Downtime

When a core order table with tens of millions of rows needs a new column, naïve ALTER TABLE can lock the table and cause outages, so this article explores master‑slave switching, online schema‑change tools, JSON or redundant fields, and practical tips for low‑risk, production‑grade schema evolution.

DDLDatabase MigrationMySQL
0 likes · 7 min read
How to Safely Add a Column to a Billion‑Row Order Table Without Downtime
Architecture Digest
Architecture Digest
Sep 5, 2025 · Backend Development

Migrate SpringBoot MySQL to PostgreSQL: Step‑by‑Step Guide & Common Pitfalls

This tutorial walks through converting a SpringBoot + MybatisPlus application from MySQL to PostgreSQL, covering driver addition, JDBC configuration, schema differences, numerous SQL incompatibilities, transaction quirks, and provides helper scripts for bulk type changes and default timestamp settings, while highlighting practical solutions.

MigrationPostgreSQL
0 likes · 11 min read
Migrate SpringBoot MySQL to PostgreSQL: Step‑by‑Step Guide & Common Pitfalls