BestHub
Sign in
Xiaolin Talks Programming
Author

Xiaolin Talks Programming

Focuses on sharing original technical insights. Senior architect at a top tech company with years of experience in technical architecture and management, and extensive interview experience. Offers one-on-one technical coaching, guiding you from beginner to architecture design to technical management. Follow for free learning resources. Free one-on-one interview coaching to help you land offers quickly.

96
Articles
0
Likes
666
Views
0
Comments
Recent Articles

Latest from Xiaolin Talks Programming

96 recent articles
Xiaolin Talks Programming
Xiaolin Talks Programming
Sep 5, 2026 · Backend Development

Migrating Log Platform from Elasticsearch to ClickHouse: Table Design, Materialized Views & Tuning Lessons

The author details migrating a high-volume logging platform from Elasticsearch to ClickHouse, covering schema design with ReplicatedMergeTree, Spring Boot integration via JDBC and MyBatis, materialized views for pre-aggregation, and optimization techniques like skip indexes, batch inserts, and capacity planning.

ClickHouseElasticsearchKafka
0 likes · 21 min read
Migrating Log Platform from Elasticsearch to ClickHouse: Table Design, Materialized Views & Tuning Lessons
Xiaolin Talks Programming
Xiaolin Talks Programming
Sep 4, 2026 · Backend Development

Spring Boot High-Concurrency Distributed ID Generation: Snowflake Algorithm, Clock Drift Handling & Performance Optimization

This article walks through implementing Twitter's Snowflake algorithm in Spring Boot for distributed ID generation, covering 64-bit structure, clock drift mitigation strategies (wait, error, historical compensation), pre-generated ID pools with double buffering for 120k QPS, MyBatis-Plus integration, and Meituan Leaf design insights.

MyBatis-Plusclock-driftdistributed-id-generation
0 likes · 17 min read
Spring Boot High-Concurrency Distributed ID Generation: Snowflake Algorithm, Clock Drift Handling & Performance Optimization
Xiaolin Talks Programming
Xiaolin Talks Programming
Sep 2, 2026 · Backend Development

Spring Boot Redis Geo: Nearby Stores & Geofencing – Pitfalls, Optimizations & Production Patterns

A hands-on guide to replacing MySQL spatial queries with Redis Geo for nearby-store search and geofencing, covering Spring Boot integration, GeoHash internals, coordinate-system pitfalls, pagination strategies, cluster key design, and real-world performance numbers from a 5,000-store convenience-chain deployment.

Coordinate SystemsGeoHashGeofencing
0 likes · 20 min read
Spring Boot Redis Geo: Nearby Stores & Geofencing – Pitfalls, Optimizations & Production Patterns
Xiaolin Talks Programming
Xiaolin Talks Programming
Aug 31, 2026 · Backend Development

Building a High-Performance TCP Long-Connection Gateway with Spring Boot and Netty: Protocol, Heartbeat & Cluster Broadcast

This article details integrating Netty with Spring Boot to build a scalable TCP long-connection gateway, covering binary protocol design with length-field framing, heartbeat detection using IdleStateHandler, session management with Redis and local maps, single-node and Redis Pub/Sub cluster push mechanisms, and performance tuning tips including Epoll transport and thread pool isolation.

ClusterEpollGateway
0 likes · 25 min read
Building a High-Performance TCP Long-Connection Gateway with Spring Boot and Netty: Protocol, Heartbeat & Cluster Broadcast
Xiaolin Talks Programming
Xiaolin Talks Programming
Aug 30, 2026 · Backend Development

Spring Boot Keycloak Integration: OIDC SSO, Role Mapping & Method Security

This article provides a practical guide to integrating Spring Boot with Keycloak for unified authentication and single sign-on using OIDC authorization code flow, covering Keycloak deployment, realm and client configuration, Spring Security setup with role mapping for both browser login and resource server tokens, method-level authorization with @PreAuthorize, and extensions for multi-tenancy, LDAP federation, and Admin API.

LDAPOIDCRBAC
0 likes · 19 min read
Spring Boot Keycloak Integration: OIDC SSO, Role Mapping & Method Security
Xiaolin Talks Programming
Xiaolin Talks Programming
Aug 29, 2026 · Backend Development

Spring Boot + iText 7: Dynamic PDFs & Electronic Signatures for Contracts/Reports

This guide covers integrating iText 7 with Spring Boot to generate dynamic PDFs via AcroForm templates or code, add PAdES-compliant digital signatures with visible seals, and implement async processing with RabbitMQ, MinIO storage, and expiring download links, plus font handling, memory optimization, and AGPL licensing advice.

AGPL licensingAcroFormPAdES
0 likes · 20 min read
Spring Boot + iText 7: Dynamic PDFs & Electronic Signatures for Contracts/Reports
Xiaolin Talks Programming
Xiaolin Talks Programming
Aug 27, 2026 · Backend Development

Why Your Deep Pagination Is Slow: LIMIT OFFSET vs Keyset Pagination in Spring Boot

This article analyzes the performance bottleneck of LIMIT OFFSET deep pagination in MySQL with millions of rows, demonstrates EXPLAIN plan analysis, compares traditional pagination, subquery, covering index, and keyset pagination approaches, provides Spring Boot implementation examples for MyBatis-Plus and JPA, and benchmarks showing keyset pagination maintains constant response time regardless of page depth.

Cursor PaginationDeep PaginationKeyset Pagination
0 likes · 22 min read
Why Your Deep Pagination Is Slow: LIMIT OFFSET vs Keyset Pagination in Spring Boot
Xiaolin Talks Programming
Xiaolin Talks Programming
Aug 26, 2026 · Backend Development

Spring Boot High Availability: Nacos Service Discovery, OpenFeign & Sentinel Resilience

This article details how to build highly available Spring Boot microservices using Nacos for service discovery and configuration, OpenFeign for declarative REST calls with load balancing, timeouts, and retries, and Sentinel for circuit breaking and fallback handling, including multi-environment isolation via namespaces and groups.

NacosOpenFeignSentinel
0 likes · 20 min read
Spring Boot High Availability: Nacos Service Discovery, OpenFeign & Sentinel Resilience