How do I manage transactions using the Go SQL driver?

How do I manage transactions using the Go SQL driver?

You can manage transactions in Go using the database/sql package. Start a transaction with db.Begin().

What methods do I use to commit or rollback a transaction?

Use tx.Commit() to commit the transaction and tx.Rollback() to rollback if something goes wrong.

Can you show me a code example?

Sure! Here's a simple example:

func performTransaction(db *sql.DB) error {
    tx, err := db.Begin()
    if err != nil {
        return err
    }
    // Perform your database operations here
    if err := tx.Commit(); err != nil {
        return err
    }
    return nil
}

What happens if I forget to commit or rollback?

If you forget to commit or rollback, the transaction will remain open, potentially leading to locks and resource leaks.