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

sqlite

package

Go to main page

Versions in this module

v0

v0.19.0

Oct 15, 2026

Changes in this version

+ var ErrNoAccounts = errors.New(...)

+ var ErrNoFile = errors.New("sqlite: the database file does not exist")

+ func Migrate(ctx context.Context, db *sql.DB, opts MigrateOptions) error

+ func Open(address string, s Settings) (*sql.DB, error)

+ type MediaStore struct

+ func NewMediaStore(handle *sql.DB) *MediaStore

+ func (s *MediaStore) ByID(ctx context.Context, id int64) (media.Media, error)

+ func (s *MediaStore) ByIDs(ctx context.Context, ids []int64) ([]media.Media, error)

+ func (s *MediaStore) Create(ctx context.Context, m media.Media) (media.Media, error)

+ func (s *MediaStore) Delete(ctx context.Context, id int64) (media.Media, error)

+ func (s *MediaStore) List(ctx context.Context, f media.Filter) ([]media.Listed, int, error)

+ func (s *MediaStore) Saved(ctx context.Context, files []string) (map[string]bool, error)

+ func (s *MediaStore) Update(ctx context.Context, m media.Media, expectedUpdatedAt time.Time) (media.Media, error)

+ type MigrateOptions struct

+ LockPoll time.Duration

+ LockWait time.Duration

+ func MigrateOptionsFrom(env gonsole.Env) (MigrateOptions, error)

+ type SettingStore struct

+ func NewSettingStore(handle *sql.DB) *SettingStore

+ func (s *SettingStore) Lookup(ctx context.Context, key string) (string, bool, error)

+ func (s *SettingStore) Save(ctx context.Context, values map[string]string) error

+ type Settings struct

+ BusyTimeout time.Duration

+ CacheSize int

+ JournalSizeLimit *int64

+ MaxConns int

+ Synchronous dbsqlite.Synchronous

+ func SettingsFrom(env gonsole.Env) (Settings, error)

+ func (s Settings) Options() dbsqlite.Options

+ type UserSettingStore struct

+ func NewUserSettingStore(handle *sql.DB) *UserSettingStore

+ func (s *UserSettingStore) Lookup(ctx context.Context, userID uuid.UUID, key string) (string, bool, error)

+ func (s *UserSettingStore) Save(ctx context.Context, userID uuid.UUID, key, value string) error