搜索技能.../

Persistence And Indexing | Skills Pool

技能档案

Persistence And Indexing

Use when designing database schema and repository access patterns aligned with real query use cases.

rivkode0 星标2026年4月2日

职业: 数据库架构师
分类: SQL 数据库

技能内容

Goal

Design database structure and access patterns for both correctness and performance.

Use When

defining schema from use cases rather than from entities alone
deciding repository methods and storage boundaries
choosing indexes based on concrete access patterns

Inputs

domain-modeling output
query-and-performance output
requirement brief
current schema or seed data if present

Deliverables

table structure aligned to core use cases
repository method candidates tied to actual queries
key relationships and ownership decisions
major index candidates with rationale
notes on tradeoffs or intentionally deferred optimizations

Instructions

相关技能

快速安装

Persistence And Indexing

npx skills add rivkode/teamsky

下载 Skill 打开源码仓库

作者: rivkode
星标: 0
更新时间: 2026年4月2日
职业

本页内容

Define table structure for:
- chapter
- question
- solve_attempt
- solve_answer
Map relationships clearly
Design repository methods based on real queries

Index Strategy

Consider indexes on:

user_id
chapter_id
created_at
(user_id, created_at)
(user_id, chapter_id)

Rules

Design for access patterns, not just object relationships
Avoid generic findAll usage
Prefer targeted query methods

Non-Goals

deciding business rule ownership in the domain model
defining public API request/response contracts
optimizing every table/index before concrete query needs exist

Practical Tip

Even if DB is small, document index decisions in README.

Exit Criteria

schema choices can be explained from write/read use cases, not only from object structure
repository methods map directly to concrete query needs
key indexes are documented with query-based reasoning
the implementer does not need to decide table shape or first-order index direction during coding

Handoff

query-and-performance can validate that repositories support the intended read paths
submission-readme-and-review can document schema and index rationale
implementation can proceed without reopening storage design questions

Use When

06Index Strategy

09Practical Tip

10Exit Criteria

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

数据库架构师