go-data-persistence

What problem does it solve?

This Skill provides comprehensive guidance and best practices for handling data persistence in Go applications, ensuring robust, efficient, and maintainable database interactions.

Core Features & Use Cases

• Database Access Patterns: Covers raw SQL with sqlx/pgx, ORMs like Ent/GORM, and connection pooling.
• Schema Management: Details migrations using golang-migrate.
• Transaction Handling: Explains service-layer transactions and isolation levels.
• Use Case: When building a new Go web service that requires a PostgreSQL database, use this Skill to understand how to set up connection pooling, implement the repository pattern, manage schema migrations, and handle complex transactions reliably.

Quick Start

Use the go-data-persistence skill to set up a PostgreSQL connection pool with optimal settings for a production web application.