Go favors simplicity, and it's pretty common to work with a database via driver directly without any ORM. It provides great control and efficiency in your queries, but here is a problem: you need to manually iterate over database rows and scan data from all columns into a corresponding destination. It can be error-prone verbose and just tedious. scany aims to solve this problem. It allows developers to scan complex data from a database into Go structs and other composite types with just one function call and don't bother with rows iteration.

scany isn't limited to any specific database. It integrates with database/sql, so any database with database/sql driver is supported. It also works with pgx library native interface. Apart from the out-of-the-box support, scany can be easily extended to work with almost any database library.

Note that scany isn't an ORM. First of all, it works only in one direction: it scans data into Go objects from the database, but it can't build database queries based on those objects. Secondly, it doesn't know anything about relations between objects e.g: one to many, many to many.

• Custom database column name via struct tag
• Reusing structs via nesting or embedding
• NULLs and custom types support
• Omitted struct fields
• Apart from structs, support for maps and Go primitive types as the destination
• Override default settings

go get github.com/georgysavva/scany/v2

package main

import (
	"context"
	"database/sql"

	"github.com/georgysavva/scany/v2/sqlscan"
)

type User struct {
	ID    string
	Name  string
	Email string
	Age   int
}

func main() {
	ctx := context.Background()
	db, _ := sql.Open("postgres", "example-connection-url")

	var users []*User
	sqlscan.Select(ctx, db, &users, `SELECT id, name, email, age FROM users`)
	// users variable now contains data from all rows.
}

Use sqlscan package to work with database/sql standard library.

package main

import (
	"context"

	"github.com/jackc/pgx/v5/pgxpool"

	"github.com/georgysavva/scany/v2/pgxscan"
)

type User struct {
	ID    string
	Name  string
	Email string
	Age   int
}

func main() {
	ctx := context.Background()
	db, _ := pgxpool.New(ctx, "example-connection-url")

	var users []*User
	pgxscan.Select(ctx, db, &users, `SELECT id, name, email, age FROM users`)
	// users variable now contains data from all rows.
}

Use pgxscan package to work with pgx library native interface.

Use dbscan package that works with an abstract database, and can be integrated with any library that has a concept of rows. This particular package implements core scany features and contains all the logic. Both sqlscan and pgxscan use dbscan internally.

• sqlx only works with database/sql standard library. scany isn't limited to database/sql. It also supports pgx native interface and can be extended to work with any database library independent of database/sql
• In terms of scanning and mapping abilities, scany provides all features of sqlx
• scany has a simpler API and much fewer concepts, so it's easier to start working with

For detailed project documentation see GitHub Wiki.

• If you have an idea or a question, just post a pull request or an issue. Every feedback is appreciated.
• If you want to help but don't know-how. All issues that you can work on are marked as "help wanted". Discover all "help wanted" issues here.

This project is licensed under the terms of the MIT license.