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.

Articles

Likes

Views

Comments

Latest from Xiaolin Talks Programming

67 recent articles

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

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.

EpollGatewayHeartbeat

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

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.

KeycloakLDAPMulti-tenancy

0 likes · 19 min read

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

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 licensingAcroFormAsync Processing

0 likes · 20 min read

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

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 PaginationLIMIT OFFSET

0 likes · 22 min read

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

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.

Circuit BreakerHigh AvailabilityOpenFeign

0 likes · 20 min read

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

Xiaolin Talks Programming

Aug 25, 2026 · Backend Development

Spring Boot + Neo4j: Building Social Graphs with Modeling, Queries & Performance Optimization

This article demonstrates how to integrate Spring Boot with Neo4j to build a social relationship graph, covering graph data modeling, Cypher query patterns for friend recommendations and shortest paths, performance optimization techniques including indexing and query profiling, and a complete demo implementation for a social feed.

CypherData ModelingGraph Database

0 likes · 25 min read

Spring Boot + Neo4j: Building Social Graphs with Modeling, Queries & Performance Optimization

Xiaolin Talks Programming

Aug 24, 2026 · Backend Development

Spring Boot MongoDB: Document Modeling, Aggregation Pipelines & High-Performance Practices

This article covers MongoDB document modeling vs relational, embedding vs referencing strategies, Spring Data MongoDB Repository and MongoTemplate usage, aggregation pipelines for analytics, multi-document transactions with avoidance patterns, composite indexing principles, and connection pooling with cursor-based pagination for high-concurrency Spring Boot applications.

Aggregation PipelineCursor PaginationDocument Modeling

0 likes · 21 min read

Spring Boot MongoDB: Document Modeling, Aggregation Pipelines & High-Performance Practices

Xiaolin Talks Programming

Aug 21, 2026 · Backend Development

Arthas in Production: Diagnosing Spring Boot CPU Spikes, Memory Leaks & Latency Spikes

This article demonstrates using Arthas to diagnose a Spring Boot service with 100% CPU, memory leaks, and latency spikes, showing step-by-step commands like dashboard, thread, heapdump, trace, and watch to pinpoint dead loops, unbounded caches, and missing SQL indexes, plus emergency hot-patching with redefine.

ArthasCPU profilingJVM troubleshooting

0 likes · 17 min read

Arthas in Production: Diagnosing Spring Boot CPU Spikes, Memory Leaks & Latency Spikes

Xiaolin Talks Programming

Aug 19, 2026 · Backend Development

Building Distributed Rate Limiting with Spring Boot, Redis & Lua: Sliding Window, Token Bucket & Flash Sale Defense

This article details a production-ready distributed rate limiting system using Spring Boot AOP, Redis Sorted Sets, and atomic Lua scripts, covering sliding window and token bucket algorithms, multi-dimensional flash sale protection, and benchmark results showing 100% accuracy with minimal latency overhead.

AOPDistributed SystemsFlash Sale

0 likes · 18 min read

Building Distributed Rate Limiting with Spring Boot, Redis & Lua: Sliding Window, Token Bucket & Flash Sale Defense