golang-database

To prevent SQL injection in Golang database access, use parameterized queries instead of string concatenation. This Skill guides you through implementing parameterized queries with Go's `database/sql` package and libraries like `sqlx` and `pgx` to ensure secure database interactions.

Optimizing Golang database performance involves proper connection pooling, indexing strategies, and query optimization. This Skill provides actionable guidance on configuring connection pools and leveraging context propagation to maintain efficient and responsive database access.

Yes, this Skill covers using third-party libraries like `sqlx` and `pgx` alongside Go's native `database/sql` package. It offers best practices for safely interacting with SQL databases using these tools to ensure secure and maintainable code.

To manage database migrations in a Golang application, this Skill recommends using external migration tools rather than application-level logic. This approach ensures database schema changes are handled safely and consistently across different environments.

Using context propagation with Go database queries allows you to manage timeouts and cancellations effectively. This Skill emphasizes context propagation as a best practice to prevent long-running queries from blocking your application and degrading performance.

Yes, you can use this Skill to audit and debug existing Golang database code. It is designed for Go developers who need to review their codebases against security and performance best practices, ensuring secure and efficient database operations.