اتصال به دیتابیس SQLite در برنامه‌های Go

{
    "disks": [
        {
            "name": "database",
            "mountTo": "database"
        }
    ]
}

{
  "go" : {
    "cgoEnabled": "true",
   }
}

go get github.com/mattn/go-sqlite3

package main

import (
	"database/sql"
	"fmt"
	"log"
	"net/http"
	"os"

	_ "github.com/mattn/go-sqlite3"
)

var db *sql.DB

func main() {

	// Ensure the database directory exists
	if err := os.MkdirAll("./database", os.ModePerm); err != nil {
		log.Fatalf("Failed to create database directory: %v", err)
	}

	// Open the database connection with SQLite URI
	var err error
	db, err = sql.Open("sqlite3", "sqlite3:./database/mydb.db")
	if err != nil {
		log.Fatalf("Failed to open database connection: %v", err)
	}

	// Set connection pool parameters (SQLite generally uses a single connection, but we can still configure)
	db.SetMaxOpenConns(1)     // SQLite is usually a single-threaded database
	db.SetMaxIdleConns(1)     // Only one idle connection
	db.SetConnMaxIdleTime(0)  // No timeout for idle connections

	// Verify connection
	if err := db.Ping(); err != nil {
		log.Fatalf("Failed to ping database: %v", err)
	}
	log.Println("Connected to database successfully!")

	// Set up HTTP server
	http.HandleFunc("/", func(w http.ResponseWriter, r *http.Request) {
		if err := db.Ping(); err != nil {
			fmt.Fprintf(w, "Database connection failed: %v", err)
		} else {
			fmt.Fprintln(w, "Database connection successful!")
		}
	})

	log.Println("Server is running on http://localhost:8080")
	if err := http.ListenAndServe(":8080", nil); err != nil {
		log.Fatalf("HTTP server failed: %v", err)
	}
}