Should I increment the entity version in my application code?

No, this skill follows the best practice of letting the database handle the increment within the SQL UPDATE statement to ensure atomicity.

What is optimistic locking?

Optimistic locking is a strategy where you check the version of a record before updating it to ensure no other process has modified it since it was read, preventing 'lost updates'.

How does this skill handle update conflicts?

The skill generates patterns that check the number of affected rows in a SQL update; if zero rows are updated due to a version mismatch, it throws a specific OptimisticLockingException.

When is it appropriate to use optimistic locking?

It is best used for entities that experience moderate to high concurrent modifications where data integrity is critical, though it should be avoided for rarely modified entities to keep code simple.

Optimistic Locking Patterns

Name: Optimistic Locking Patterns
Author: allousas

byallousas

•

Database Management

Implements robust concurrency control in database repositories using version-based optimistic locking to prevent lost updates.

The Optimistic Locking Patterns skill provides Claude with the specialized knowledge required to implement and refactor database repository methods for safe concurrent access. By guiding the addition of version fields and the construction of conditional SQL update statements, it ensures that entities are only updated if their state has not changed since being read. This approach is essential for maintaining data integrity in high-traffic applications, offering clear patterns for exception handling and retry logic across various persistence layers while keeping the complexity within the database layer rather than application code.

Key Features

01Automatic integration of version fields in domain entities

02Guidance on retry strategies for controllers and consumers

031 GitHub stars

04SQL generation for atomic updates with version checks

05Prevention of lost update scenarios in multi-process environments

06Standardized OptimisticLockingException implementation

Use Cases

01Implementing safe update logic for transaction-heavy backend systems

02Designing high-concurrency microservices that access shared state

03Refactoring legacy repository code to resolve race conditions

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add allousas/claude-code-plugins applying-optimistic-locking

For use in Claude.ai and ChatGPT

Download Skill