How can I prevent connection leaks in Go SQL driver?

What are connection leaks in the Go SQL driver?

Connection leaks occur when database connections are not properly closed, leading to resource exhaustion.

How can I identify if my application has connection leaks?

You can monitor the number of open connections and check for any that remain open longer than expected.

What are some best practices to prevent these leaks?

Always defer closing connections, use connection pooling, and ensure error handling is in place.

Can you give an example of using defer to close a connection?

Sure! You can use defer db.Close() right after opening the connection to ensure it closes when the function exits.