How do I set up a web server with a database in Go?

How do I set up a web server with a database in Go?

To set up a web server with a database in Go, you can use the net/http package for the server and a database driver like sqlx or GORM for database interactions.

What database should I use with Go?

You can use various databases with Go, such as PostgreSQL, MySQL, or SQLite. PostgreSQL is a popular choice for its features and performance.

Can you show me a simple code example?

Sure! Here's a basic example using net/http and GORM with a PostgreSQL database:

package main

import (
    "github.com/gin-gonic/gin"
    "gorm.io/driver/postgres"
    "gorm.io/gorm"
)

func main() {
    r := gin.Default()
    db, err := gorm.Open(postgres.Open("user=gorm dbname=gorm password=gorm sslmode=disable"), &gorm.Config{})
    if err != nil {
        panic("failed to connect to database")
    }

    r.GET("/users", func(c *gin.Context) {
        var users []User
        db.Find(&users)
        c.JSON(200, users)
    })

    r.Run() // listen and serve on 0.0.0.0:8080
}

What are some common issues I might face?

Common issues include database connection errors, handling CORS, and managing migrations. Make sure to check your connection strings and error logs.