package main

import (
    "database/sql"
    "fmt"
    "log"

    pglite "github.com/elliots/go-pglite"
)

func main() {
    pg, err := pglite.New(pglite.Config{})
    if err != nil {
        log.Fatal(err)
    }
    defer pg.Close()

    db := pg.DB()

    var greeting string
    err = db.QueryRow("SELECT 'hello from pglite'").Scan(&greeting)
    if err != nil {
        log.Fatal(err)
    }
    fmt.Println(greeting)
}

pglite.Config{
    DataDir:    "/path/to/data",  // empty = temporary directory (removed on close)
    Database:   "mydb",           // default: "postgres"
    User:       "myuser",         // default: "postgres"
    StdoutFile: "/tmp/pg.log",    // empty = /dev/null
    StderrFile: "/tmp/pg.err",    // empty = /dev/null
}