dbx

Iterator-based database/sql helpers based on sqlx

Run

docker compose up -d
GOEXPERIMENT=rangefunc SQLX_MYSQL_DSN=root:@tcp(localhost:33066)/dbx go test ./...
GOEXPERIMENT=rangefunc SQLX_MYSQL_DSN=root:@tcp(localhost:33066)/dbx go test -bench=. -benchmem 

Examples

// loop through iterator directly to populate a map
byName := make(map[string]Person)
for p, err := range dbx.Select[Person](ctx, db, "SELECT * FROM person") {
    if err != nil {
        return
    }
    byName[p.FirstName] = p
}

// collect results into a slice
people, err := dbx.Select[Person](ctx, db, "SELECT * FROM person").Slice()

// collect results into a slice with specified capacity
people, err := dbx.Select[Person](ctx, db, "SELECT * FROM person LIMIT ?", limit).SliceCap(limit)

// filter results in memory and collect into a slice
people, err := dbx.Select[Person](ctx, db, "SELECT * FROM person").
    Filter(func(p Person) bool { return p.Email != "" }).
    SliceCap(10)