How do I handle database transactions in Go?

How do I handle database transactions in Go?

In Go, you can handle database transactions using the database/sql package. You start a transaction with db.Begin(), then execute your queries, and finally commit or rollback the transaction.

Can you show me a code example?

Sure! Here's a simple example:

package main

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

func main() {
    db, err := sql.Open("postgres", "user=username dbname=mydb sslmode=disable")
    if err != nil {
        log.Fatal(err)
    }
    
    tx, err := db.Begin()
    if err != nil {
        log.Fatal(err)
    }
    
    _, err = tx.Exec("INSERT INTO users(name) VALUES($1)", "John")
    if err != nil {
        tx.Rollback()
        log.Fatal(err)
    }
    
    err = tx.Commit()
    if err != nil {
        log.Fatal(err)
    }
}

What happens if I encounter an error during the transaction?

If an error occurs during the transaction, you should call tx.Rollback() to revert any changes made during the transaction. This ensures data integrity.

Are there any best practices for transaction handling?

Yes, some best practices include keeping transactions short, handling errors properly, and using appropriate isolation levels to avoid deadlocks.