Help us shape the future of Go! Take the 2026 Go Developer Survey

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

v0

v0.9.0

Oct 15, 2026

Changes in this version

+ const DB_PRAGMAS

+ const DB_PRAGMAS_READONLY

+ func DSN(path string, readOnly bool) string

+ func EnsureExists(path string) error

+ func InTx(ctx context.Context, db *sql.DB, fn func(tx *sql.Tx) error) error

+ func IsForeignKeyConstraint(err error) bool

+ func IsTriggerConstraint(err error) bool

+ func IsUniqueConstraint(err error) bool

+ func SchemaVersion(ctx context.Context, p *goose.Provider) (int64, error)

+ func Setup(path string) (*sql.DB, error)

+ func SetupReadOnly(path string) (*sql.DB, error)

+ func WithTx(ctx context.Context, db *sql.DB, fn func(q *dbq.Queries) error) error

+ type Schema struct

+ func NewSchema(root fs.FS) *Schema

+ func (s *Schema) CurrentVersion(ctx context.Context, db *sql.DB) (int64, error)

+ func (s *Schema) LatestVersion() (int64, error)

+ func (s *Schema) Migrate(ctx context.Context, db *sql.DB) error

+ func (s *Schema) Open(ctx context.Context, path string) (*sql.DB, error)

+ func (s *Schema) Provider(db *sql.DB) (*goose.Provider, error)

+ type SqliteStore struct

+ func (s *SqliteStore) CreateVersionTable(ctx context.Context, db goosedb.DBTxConn) error