sqlxdb

package

v1.0.1 Latest Latest Go to latest Published: Apr 20, 2026 License: MIT Imports: 5 Imported by: 0

Details

Package sqlxdb provides sqlx + PostgreSQL (pgx stdlib driver) helpers:

Migrations are not handled here; use goose, atlas, or your tool of choice.

Usage:

db, err := sqlxdb.Connect(sqlxdb.Config{URL: os.Getenv("DATABASE_URL")})
if err != nil { ... }
defer db.Close()

This section is empty.

This section is empty.

func Connect(cfg Config) (*sqlx.DB, error)

Connect opens a *sqlx.DB using driver name "pgx".

func WithTx(ctx context.Context, db *sqlx.DB, fn func(*sqlx.Tx) error) error

WithTx runs fn inside a transaction. Commits on nil error, rolls back otherwise.

type Config struct {
	URL string

	MaxOpenConns    int
	MaxIdleConns    int
	ConnMaxLifetime time.Duration
	ConnMaxIdleTime time.Duration
}

Config holds database connection settings for PostgreSQL via pgx stdlib driver.