Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
- API
  
  Reference documentation for the pkg.go.dev API
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

database

package

Go to main page

Versions in this module

v1

v1.1.1

Dec 6, 2025

v1.0.3

Dec 6, 2025

v1.0.2

Dec 6, 2025

v1.0.1

Dec 5, 2025

v1.0.0

Dec 5, 2025

Changes in this version

+ type DB interface

+ BeginTx func(ctx context.Context) (Tx, error)

+ Close func() error

+ Exec func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ Migrate func(ctx context.Context) error

+ Ping func(ctx context.Context) error

+ Query func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ QueryRow func(ctx context.Context, query string, args ...interface{}) *sql.Row

+ func New(ctx context.Context, cfg *config.DatabaseConfig, logger *slog.Logger) (DB, error)

+ type Migration struct

+ Name string

+ SQL string

+ Version int

+ type PostgresDB struct

+ func NewPostgres(ctx context.Context, cfg *config.PostgresConfig, logger *slog.Logger) (*PostgresDB, error)

+ func (p *PostgresDB) BeginTx(ctx context.Context) (Tx, error)

+ func (p *PostgresDB) Close() error

+ func (p *PostgresDB) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (p *PostgresDB) Migrate(ctx context.Context) error

+ func (p *PostgresDB) Ping(ctx context.Context) error

+ func (p *PostgresDB) Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (p *PostgresDB) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row

+ type PostgresTx struct

+ func (t *PostgresTx) Commit() error

+ func (t *PostgresTx) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (t *PostgresTx) Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (t *PostgresTx) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row

+ func (t *PostgresTx) Rollback() error

+ type SQLiteDB struct

+ func NewSQLite(ctx context.Context, cfg *config.SQLiteConfig, logger *slog.Logger) (*SQLiteDB, error)

+ func (s *SQLiteDB) BeginTx(ctx context.Context) (Tx, error)

+ func (s *SQLiteDB) Close() error

+ func (s *SQLiteDB) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (s *SQLiteDB) Migrate(ctx context.Context) error

+ func (s *SQLiteDB) Ping(ctx context.Context) error

+ func (s *SQLiteDB) Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (s *SQLiteDB) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row

+ type SQLiteTx struct

+ func (t *SQLiteTx) Commit() error

+ func (t *SQLiteTx) Exec(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (t *SQLiteTx) Query(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (t *SQLiteTx) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row

+ func (t *SQLiteTx) Rollback() error

+ type Tx interface

+ Commit func() error

+ Exec func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ Query func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ QueryRow func(ctx context.Context, query string, args ...interface{}) *sql.Row

+ Rollback func() error