postgresql-data-layer

What problem does it solve?

Provides production-focused guidance to design, operate, and evolve PostgreSQL schemas for Node.js/TypeScript backends, reducing data integrity issues, downtime during migrations, and query performance bottlenecks.

Core Features & Use Cases

• Schema Design & Naming Conventions: Recommended table, column, key, and index naming to keep schema consistent and maintainable.
• Migrations & Backward Compatibility: Patterns for forward-only, idempotent, and rolling-deploy-safe migrations to enable zero-downtime schema changes.
• Connection Pooling & Monitoring: Pool sizing guidance, timeouts, and monitoring hooks to avoid exhausting database connections.
• Query Patterns & Safety: Repository pattern, parameterized queries, and transaction handling examples to prevent injection and ensure atomic updates.
• Indexing & JSONB Guidance: When to add indexes, partial and concurrent index strategies, and appropriate uses of JSONB versus relational columns.
• Dual-store Planning: Decision framework for what belongs in PostgreSQL versus Redis (durability vs ephemeral state).

Quick Start

Design a normalized games and game_actions schema, produce migration steps that are backward-compatible, and recommend connection pool and indexing settings for a Node.js/TypeScript backend.