db-patterns

What problem does it solve?

A ready-to-use blueprint for building robust PostgreSQL data access layers in Go without an ORM, reducing boilerplate and risk across services.

Core Features & Use Cases

• Repository pattern implementation for Go services using pgx with a zero-ORM approach.
• Migrations organization and conventions (backend/migrations) with standard up/down scripts and versioning.
• Consistent error wrapping, debug-friendly query patterns, and JSONB usage for flexible data modeling.
• Connection pooling with pgxpool and patterns for Redis-backed session storage and caching.
• Use cases include building scalable data access layers for microservices, audit trails, and high-traffic apps.

Quick Start

Apply this pattern by wiring a pgxpool connection, implementing repository methods, and running migrations to bootstrap your database layer.