go-db

What problem does it solve?

This Skill provides expert guidance on integrating Go applications with PostgreSQL, ClickHouse, and Redis, focusing on robust database patterns and efficient data management.

Core Features & Use Cases

• Repository Pattern Implementation: Design clear, maintainable data access layers.
• Query Optimization: Utilize tools like Squirrel for complex and efficient SQL queries.
• Database Migrations: Manage schema changes effectively with Goose.
• Caching Strategies: Implement Redis for performance improvements using patterns like cache-aside.
• Use Case: Develop a high-performance user service in Go, ensuring data integrity through proper transaction management, efficient querying, and effective caching.

Quick Start

Provide guidance on implementing a user repository with CRUD operations in Go using PostgreSQL.