Packages/db/DB

Node: knexgithub.com/sahilkhaire/gox/db

DB

Overview

DB wraps *sqlx.DB with a chainable query API.

Part of the db package — Node.js analog: knex.

DB is a type exported by gox. Methods on this type are documented separately.

Signature

type DB struct {
	SQL *sqlx.DB
}

Compare: Node.js · Standard Go · gox

Node.js

// Typical knex pattern in Node.js

Standard Go

db, err := sqlx.Connect("postgres", dsn)
db.GetContext(ctx, &row, query, args...)

gox

import "github.com/sahilkhaire/gox/db"

db, err := db.Open(ctx, "postgres", dsn)
if err != nil {
    return err
}

Example

import "github.com/sahilkhaire/gox/db"

db, err := db.Open(ctx, "postgres", dsn)
if err != nil {
    return err
}

Tips

Pass context.Context as the first argument so cancellation and deadlines propagate correctly.

Standard library alternative

Use the standard library directly:

db, err := sqlx.Connect("postgres", dsn)
db.GetContext(ctx, &row, query, args...)

← Back to db package overview