How do I manage transactions in SQL using Go?

How do I manage transactions in SQL using Go?

To manage transactions in SQL with Go, you can use the database/sql package. Start by opening a database connection.

Can you show me a code example?

Sure! Here's a simple example:

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/lib/pq"
)

func main() {
    db, err := sql.Open("postgres", "user=username dbname=mydb sslmode=disable")
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()

    tx, err := db.Begin()
    if err != nil {
        log.Fatal(err)
    }

    // Your SQL operations here

    if err := tx.Commit(); err != nil {
        tx.Rollback()
        log.Fatal(err)
    }
}

What happens if I encounter an error during the transaction?

If an error occurs, you should call tx.Rollback() to undo any changes made during the transaction.

Are there any best practices for transaction management?

Yes, always ensure to handle errors properly, keep transactions short, and avoid locking resources for long periods.