golang-database-patterns

What problem does it solve?

This Skill provides comprehensive guidance and code examples for effectively interacting with SQL databases in Go, covering everything from basic queries to advanced patterns like the repository pattern and transaction management.

Core Features & Use Cases

• Database Libraries: Explores database/sql, sqlx, and pgx for different needs.
• Repository Pattern: Demonstrates building testable, interface-based data access layers.
• Migrations: Covers schema versioning using golang-migrate.
• Transaction Handling: Details safe and robust transaction management, including retry logic.
• Use Case: When building a new Go web service that requires robust user authentication and data storage, this Skill will guide you in setting up the database connection, defining user models, implementing CRUD operations, and managing schema changes.

Quick Start

Use the golang-database-patterns skill to set up a connection pool using pgx for a PostgreSQL database.