db.v2: A productive data access layer for Go

Get started

If you're new you can start here to read an intro and learn the basics.

Play

Learn common patterns and practise with live examples.

Contribute

Get your hands dirty and contribute with code, examples and documentation.

Key features

Maps query results into Go structs
Lets you use plain SQL when you need to
Provides an (optional) set-oriented syntax that works the same on SQL and NoSQL databases
Easy syntax for transactions
That's all!

Try it!

The box below is a live demo, you can modify and run read-only queries directly from your browser! Give it a try.

package main

import (
	"log"

"upper.io/db.v2"
	"upper.io/db.v2/postgresql"
)

var settings = postgresql.ConnectionURL{
	Database: `booktown`,
	Host:     `demo.upper.io`,
	User:     `demouser`,
	Password: `demop4ss`,
}

// Book represents an element from the "books" table, column names are mapped
// to Go values.
type Book struct {
	ID        uint   `db:"id"`
	Title     string `db:"title"`
	AuthorID  uint   `db:"author_id"`
	SubjectID uint   `db:"subject_id"`
}

func main() {
	sess, err := postgresql.Open(settings)
	if err != nil {
		log.Fatal(err)
	}
	defer sess.Close()

// Set this to true to enable the query logger which will print all SQL
	// statements to stdout.
	db.Conf.SetLogging(false)

// Define a result set without passing a condition to Find(), this means we
	// want to match all the elements on the books table.
	res := sess.Collection("books").Find()

// We can use this res object later in different queries, here we'll use it
	// to fetch all the books on our catalog in descending order.
	var books []Book
	if err := res.OrderBy("title DESC").All(&books); err != nil {
		log.Fatal(err)
	}

// The books slice has been populated!
	log.Println("Books:")
	for _, book := range books {
		log.Printf("%q (ID: %d)\n", book.Title, book.ID)
	}
}