Simpler - a simpler database story for Go

A small wrapper around ozzo-dbx

Inspired by HugSQL

• Embrace SQL
• Load queries from files
• Be happy

Usage

Sample users.sql file in data/sql directory of our project.

-- name: all_users
SELECT * FROM users

-- name: delete_user
DELETE FROM users WHERE id = {:id}

Metadata inf sql files follows format -- key: value where value for name key has to be a valid identifier (should match \w+).

package main

import (
    "coderats.dev/simpler"
    _ "github.com/jackc/pgx/stdlib"
)

func main() {
    // Load all *.sql files from a directory
    registry, err := simpler.NewRegistry("data/sql")
    if err != nil {
        panic(err)
    }

    // you can use any adapter that ozzo-dbx support
    // for example with the following import
    // import _ "github.com/go-sql-driver/mysql"
    // you can use "mysql" as an adapter string (first arg to Connect)
    err = registry.Connect("pgx", "postgres://root:root@localhost:5432/mydb_dev")
    if err != nil {
        panic(err)
    }

    // q is just a *dbx.Query from ozzo-dbx package
    // same result as using dbx.NewQuery call
    q := registry.Query("users/all_users")

    var users []User
    err := q.All(&users)

    // Load delete_user query
    q = registry.Query("users/delete_user")
    // Pass named parameters to a query
    q.Bind(dbx.Params{"id": 3})
    // And execute it
    _, err = q.Execute()

    // Or you can access *dbx.DB directly
    user := User{
        Name: "example",
        Email: "test@example.com",
    }
    err = registry.DB().Model(&user).Insert()

    // Example database/sql pool configuration
    registry.DB().DB().SetMaxOpenConns(100)
    registry.DB().DB().SetMaxIdleConns(10)
    registry.DB().DB().SetConnMaxLifetime(0)
}