go-repository-pattern

Implement the repository pattern in Go with sqlc by defining domain port interfaces and generating PostgreSQL database adapters. This Skill provides the wiring mechanism to seamlessly switch between Postgres and in-memory backends for your data access layer.

Test Go data access layers without PostgreSQL by using an in-memory repository implementation. This Skill provides a memory backend that fulfills your domain interfaces, enabling fast local unit tests without a live database connection.

The best way to switch between in-memory and PostgreSQL backends is an environment-aware wiring mechanism. This Skill provides a configuration that swaps storage repositories without requiring changes to your domain logic.

Manage PostgreSQL migrations within a Go repository architecture by applying consistent migration conventions. This Skill includes migration practices that keep your database schema aligned with your sqlc adapters and domain interfaces.

Yes, the template requires sqlc to generate the PostgreSQL database adapters for the repository pattern. The Skill combines sqlc-generated code with domain ports and an in-memory implementation to enable backend switching.

Define domain ports when building a Go persistence layer to decouple core business logic from sqlc database adapters. This Skill uses these interfaces to ensure your domain remains cloud-agnostic and compatible with the in-memory backend.