database-sqlc-patterns

What problem does it solve?

This Skill provides a comprehensive guide to managing Chronicle's PostgreSQL database, ensuring efficient and maintainable data operations through the use of sqlc.

Core Features & Use Cases

• Query Writing Conventions: Learn standardized patterns for creating SQL queries.
• Migration Workflow: Understand how to create and manage database schema changes.
• Custom Type Handling: Discover how to map PostgreSQL types to Go types effectively.
• Testing Strategies: Implement robust database testing with provided utilities.
• Use Case: When adding a new feature that requires storing user preferences, you would use this Skill to define the new table schema in a migration, write the corresponding Go functions using sqlc, and ensure it's tested thoroughly.

Quick Start

Use the database-sqlc-patterns skill to add a new user role column to the users table.