oltp-schema-design
CommunityOLTP schema design for high-concurrency apps.
Software Engineering#postgresql#indexes#normalization#data-integrity#schema-design#transactional#oltp
Authorguygrigsby
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Design PostgreSQL OLTP schemas that ensure data integrity and high write throughput for concurrent transactional workloads.
Core Features & Use Cases
- Normalization up to 5NF where appropriate to minimize redundancy and update anomalies.
- Enforcement of ACID guarantees, foreign key constraints, and row-level locking for safe high-concurrency operations.
- Practical patterns and guidance for mapping DDD aggregates and designing index strategies for OLTP workloads.
Quick Start
Design an OLTP schema for a high-concurrency orders system.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: oltp-schema-design Download link: https://github.com/guygrigsby/dotfiles/archive/main.zip#oltp-schema-design Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.