Skip to content
Tagged articles

database unique index

3 articles · Page 1 of 1
Rain's Path to Java Mastery
Rain's Path to Java Mastery
Aug 12, 2026 · Backend Development

API Idempotency Deep Dive: 5 Patterns, Code & Interview Guide

This comprehensive guide covers five proven idempotency patterns for distributed systems—database unique indexes, token mechanisms, distributed locks, state machines, and deduplication tables—with code implementations, Lua-script atomicity, Spring AOP aspects, optimistic locking, and a simulated interview covering race conditions, clock drift, and hotspot mitigation.

API IdempotencyDistributed LocksDistributed Systems
0 likes · 26 min read
API Idempotency Deep Dive: 5 Patterns, Code & Interview Guide
Rain's Path to Java Mastery
Rain's Path to Java Mastery
Aug 11, 2026 · Backend Development

Prevent Duplicate Orders: 4-Layer Idempotency Defense with Redis Tokens, DB Constraints & AOP

This article details a comprehensive four-layer strategy to prevent duplicate order submissions, covering frontend interception, distributed token mechanisms with Redis atomic operations, database unique constraints as ultimate fallback, scheduled reconciliation, and a reusable AOP-based annotation for zero-intrusion idempotency in Spring Boot applications.

AOPIdempotencyLua script
0 likes · 24 min read
Prevent Duplicate Orders: 4-Layer Idempotency Defense with Redis Tokens, DB Constraints & AOP
Rain's Path to Java Mastery
Rain's Path to Java Mastery
Aug 6, 2026 · Backend Development

MQ Duplicate Consumption: Three Idempotency Patterns with Code & Pitfalls

This article explains why MQ duplicate consumption occurs due to ACK loss, and details three idempotency solutions—database unique index, Redis atomic operations, and business state machines—with code examples, comparison tables, production pitfalls like race conditions and transaction boundaries, best practices, and interview-focused implementation insights.

Distributed SystemsIdempotencyMQ
0 likes · 24 min read
MQ Duplicate Consumption: Three Idempotency Patterns with Code & Pitfalls