jyjeanne/database-locking-strategies
skills/database-locking-strategies/SKILL.md
To manage concurrent access to database records, preventing race conditions and data inconsistencies (e.g., double spending, overbooking). Use when: Financial transactions; Inventory management; "Check-and-Set" operations.
$ install --global
skillsauthnpx skillsauth add jyjeanne/ai-setup-forge database-locking-strategiesInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 6, 2026, 11:31 AM27.5s1 file scanned
SKILL.md
- name:
- database-locking-strategies
- description:
- To manage concurrent access to database records, preventing race conditions and data inconsistencies (e.g., double spending, overbooking). Use when: Financial transactions; Inventory management; "Check-and-Set" operations.
Purpose
To manage concurrent access to database records, preventing race conditions and data inconsistencies (e.g., double spending, overbooking).
When to Use
- Financial transactions.
- Inventory management.
- "Check-and-Set" operations.
Procedure
1. Optimistic Locking (Versioning)
Assume conflict is rare. Use a version column.
- Read record:
SELECT * FROM products WHERE id=1;(Returns version: 5) - Update with check:
UPDATE products SET stock = stock - 1, version = 6 WHERE id = 1 AND version = 5; - Check result: If "0 rows affected", someone else modified it. Retry or throw error.
Implementation (TypeORM/Prisma):
Often supported natively (@VersionColumn in TypeORM).
2. Pessimistic Locking
Assume conflict is likely. Lock the row for the transaction duration.
- Start Transaction.
- Select for Update:
(This blocks other transactions trying to lock this row).SELECT * FROM products WHERE id = 1 FOR UPDATE; - Perform Logic.
- Commit (Release Lock).
3. Advisory Locks (App Level)
Lock an arbitrary abstract name/ID, not a specific row.
-- PostgreSQL
SELECT pg_advisory_xact_lock(12345);
-- Do work...
-- Lock released automatically at end of transaction
Constraints
- Deadlocks: Pessimistic locking can lead to deadlocks if two transactions lock resources in reverse order. Always acquire locks in a consistent order (e.g., sort by ID).
- Performance:
FOR UPDATEreduces concurrency. Use Optimistic locking for high-traffic, low-conflict scenarios.
Expected Output
Data integrity guarantees under high concurrency, ensuring atomic transitions of state.
Related Skills
jyjeanne/legacy-circuit-mockups
development
VerifiedTrustedCommunity
Generate breadboard circuit mockups and visual diagrams using HTML5 Canvas drawing techniques. Use when asked to create circuit layouts, visualize electronic component placements, draw breadboard diagrams, mockup 6502 builds, generate retro computer schematics, or design vintage electronics projects. Supports 555 timers, W65C02S microprocessors, 28C256 EEPROMs, W65C22 VIA chips, 7400-series logic gates, LEDs, resistors, capacitors, switches, buttons, crystals, and wires.
1SKILL.mdUpdated Apr 6, 2026
jyjeanne/lean-ux
development
VerifiedTrustedCommunity
Apply lean thinking to UX: hypothesis-driven design, collaborative sketching, and rapid experiments instead of heavy deliverables. Use when the user mentions "Lean UX", "design hypothesis", "UX experiment", "collaborative design", or "outcome over output". Covers hypothesis statements, MVPs for UX, and cross-functional collaboration. For Build-Measure-Learn, see lean-startup. For usability audits, see ux-heuristics.
1SKILL.mdUpdated Apr 6, 2026
jyjeanne/lean-startup
development
VerifiedTrustedCommunity
Design MVPs, validated learning experiments, and pivot-or-persevere decisions using Build-Measure-Learn. Use when the user mentions "MVP scope", "validated learning", "pivot or persevere", "vanity metrics", or "test assumptions". Covers innovation accounting and actionable metrics. For 5-day prototype testing, see design-sprint. For customer motivation analysis, see jobs-to-be-done.
1SKILL.mdUpdated Apr 6, 2026
jyjeanne/langsmith
tools
VerifiedTrustedCommunity
Instrument, trace, evaluate, and monitor LLM applications and AI agents with LangSmith. Use when setting up observability for LLM pipelines, running offline or online evaluations, managing prompts in the Prompt Hub, creating datasets for regression testing, or deploying agent servers. Triggers on: langsmith, langchain tracing, llm tracing, llm observability, llm evaluation, trace llm calls, @traceable, wrap_openai, langsmith evaluate, langsmith dataset, langsmith feedback, langsmith prompt hub, langsmith project, llm monitoring, llm debugging, llm quality, openevals, langsmith cli, langsmith experiment, annotate llm, llm judge.
1SKILL.mdUpdated Apr 6, 2026