数据库事务管理指南：ACID合规、并发控制与死锁解决方案

transaction-management by aj-geddes/useful-ai-prompts

153 周安装量

161 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill transaction-management

开发数据库性能优化

🇨🇳中文介绍

事务管理

概述

实现具备 ACID 合规性、并发控制和错误处理的健壮事务管理。涵盖隔离级别、锁定策略和死锁解决方案。

使用场景

ACID 事务实现
并发数据修改处理
隔离级别选择
死锁预防与解决
事务超时配置
分布式事务协调
金融交易安全性

快速开始

简单事务：

-- 开始事务
BEGIN;

-- 多个语句
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;

-- 提交更改
COMMIT;

-- 或回滚
ROLLBACK;

参考指南

references/ 目录下的详细实现：

指南	内容
PostgreSQL 事务

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

🇺🇸English

Transaction Management

Overview
When to Use
Quick Start
Reference Guides
Best Practices

Overview

Implement robust transaction management with ACID compliance, concurrency control, and error handling. Covers isolation levels, locking strategies, and deadlock resolution.

When to Use

ACID transaction implementation
Concurrent data modification handling
Isolation level selection
Deadlock prevention and resolution
Transaction timeout configuration
Distributed transaction coordination
Financial transaction safety

Quick Start

Simple Transaction:

-- Start transaction
BEGIN;

-- Multiple statements
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;

-- Commit changes
COMMIT;

-- Or rollback
ROLLBACK;

Reference Guides

Detailed implementations in the references/ directory:

Guide	Contents
PostgreSQL Transactions	PostgreSQL Transactions
MySQL Transactions	MySQL Transactions
PostgreSQL Isolation Levels	PostgreSQL Isolation Levels
MySQL Isolation Levels	MySQL Isolation Levels
PostgreSQL Explicit Locking	PostgreSQL Explicit Locking
MySQL Locking	MySQL Locking
Deadlock Prevention	PostgreSQL - Deadlock Detection:

Best Practices

✅ DO

Follow established patterns and conventions
Write clean, maintainable code
Add appropriate documentation
Test thoroughly before deploying

❌ DON'T

Skip testing or validation
Ignore error handling
Hard-code configuration values

Weekly Installs

110

Repository

aj-geddes/usefu…-prompts

GitHub Stars

121

First Seen

Jan 21, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

opencode93

gemini-cli92

codex89

cursor85

claude-code80

github-copilot77