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
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 module

Go to main page

Versions in this module

v0

v0.8.1

Jan 4, 2026

v0.8.0

Nov 20, 2025

v0.7.1

Nov 10, 2025

v0.7.0

Nov 10, 2025

Changes in this version

+ const BindIndexStart

+ const ColumnIndexStart

+ const ResultError

+ const ResultOK

+ const ResultRange

+ const SQLITE_ABORT

+ const SQLITE_ABORT_ROLLBACK

+ const SQLITE_AUTH

+ const SQLITE_AUTH_USER

+ const SQLITE_BLOB

+ const SQLITE_BUSY

+ const SQLITE_BUSY_RECOVERY

+ const SQLITE_BUSY_SNAPSHOT

+ const SQLITE_CANTOPEN

+ const SQLITE_CANTOPEN_CONVPATH

+ const SQLITE_CANTOPEN_FULLPATH

+ const SQLITE_CANTOPEN_ISDIR

+ const SQLITE_CANTOPEN_NOTEMPDIR

+ const SQLITE_CHANGESET_ABORT

+ const SQLITE_CHANGESET_CONFLICT

+ const SQLITE_CHANGESET_CONSTRAINT

+ const SQLITE_CHANGESET_DATA

+ const SQLITE_CHANGESET_FOREIGN_KEY

+ const SQLITE_CHANGESET_NOTFOUND

+ const SQLITE_CHANGESET_OMIT

+ const SQLITE_CHANGESET_REPLACE

+ const SQLITE_CONSTRAINT

+ const SQLITE_CONSTRAINT_CHECK

+ const SQLITE_CONSTRAINT_COMMITHOOK

+ const SQLITE_CONSTRAINT_FOREIGNKEY

+ const SQLITE_CONSTRAINT_FUNCTION

+ const SQLITE_CONSTRAINT_NOTNULL

+ const SQLITE_CONSTRAINT_PRIMARYKEY

+ const SQLITE_CONSTRAINT_ROWID

+ const SQLITE_CONSTRAINT_TRIGGER

+ const SQLITE_CONSTRAINT_UNIQUE

+ const SQLITE_CONSTRAINT_VTAB

+ const SQLITE_CORRUPT

+ const SQLITE_CORRUPT_VTAB

+ const SQLITE_DBCONFIG_DQS_DDL

+ const SQLITE_DBCONFIG_DQS_DML

+ const SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION

+ const SQLITE_DENY

+ const SQLITE_DONE

+ const SQLITE_EMPTY

+ const SQLITE_ERROR

+ const SQLITE_ERROR_MISSING_COLLSEQ

+ const SQLITE_ERROR_RETRY

+ const SQLITE_ERROR_SNAPSHOT

+ const SQLITE_FLOAT

+ const SQLITE_FORMAT

+ const SQLITE_FULL

+ const SQLITE_IGNORE

+ const SQLITE_INTEGER

+ const SQLITE_INTERNAL

+ const SQLITE_INTERRUPT

+ const SQLITE_IOERR

+ const SQLITE_IOERR_ACCESS

+ const SQLITE_IOERR_AUTH

+ const SQLITE_IOERR_BEGIN_ATOMIC

+ const SQLITE_IOERR_BLOCKED

+ const SQLITE_IOERR_CHECKRESERVEDLOCK

+ const SQLITE_IOERR_CLOSE

+ const SQLITE_IOERR_COMMIT_ATOMIC

+ const SQLITE_IOERR_CONVPATH

+ const SQLITE_IOERR_DELETE

+ const SQLITE_IOERR_DELETE_NOENT

+ const SQLITE_IOERR_DIR_CLOSE

+ const SQLITE_IOERR_DIR_FSYNC

+ const SQLITE_IOERR_FSTAT

+ const SQLITE_IOERR_FSYNC

+ const SQLITE_IOERR_GETTEMPPATH

+ const SQLITE_IOERR_LOCK

+ const SQLITE_IOERR_MMAP

+ const SQLITE_IOERR_NOMEM

+ const SQLITE_IOERR_RDLOCK

+ const SQLITE_IOERR_READ

+ const SQLITE_IOERR_ROLLBACK_ATOMIC

+ const SQLITE_IOERR_SEEK

+ const SQLITE_IOERR_SHMLOCK

+ const SQLITE_IOERR_SHMMAP

+ const SQLITE_IOERR_SHMOPEN

+ const SQLITE_IOERR_SHMSIZE

+ const SQLITE_IOERR_SHORT_READ

+ const SQLITE_IOERR_TRUNCATE

+ const SQLITE_IOERR_UNLOCK

+ const SQLITE_IOERR_VNODE

+ const SQLITE_IOERR_WRITE

+ const SQLITE_LIMIT_ATTACHED

+ const SQLITE_LIMIT_COLUMN

+ const SQLITE_LIMIT_COMPOUND_SELECT

+ const SQLITE_LIMIT_EXPR_DEPTH

+ const SQLITE_LIMIT_FUNCTION_ARG

+ const SQLITE_LIMIT_LENGTH

+ const SQLITE_LIMIT_LIKE_PATTERN_LENGTH

+ const SQLITE_LIMIT_SQL_LENGTH

+ const SQLITE_LIMIT_TRIGGER_DEPTH

+ const SQLITE_LIMIT_VARIABLE_NUMBER

+ const SQLITE_LIMIT_VDBE_OP

+ const SQLITE_LIMIT_WORKER_THREADS

+ const SQLITE_LOCKED

+ const SQLITE_LOCKED_SHAREDCACHE

+ const SQLITE_MISMATCH

+ const SQLITE_MISUSE

+ const SQLITE_NOLFS

+ const SQLITE_NOMEM

+ const SQLITE_NOTADB

+ const SQLITE_NOTFOUND

+ const SQLITE_NOTICE

+ const SQLITE_NOTICE_RECOVER_ROLLBACK

+ const SQLITE_NOTICE_RECOVER_WAL

+ const SQLITE_NULL

+ const SQLITE_OK

+ const SQLITE_PERM

+ const SQLITE_PROTOCOL

+ const SQLITE_RANGE

+ const SQLITE_READONLY

+ const SQLITE_READONLY_CANTINIT

+ const SQLITE_READONLY_CANTLOCK

+ const SQLITE_READONLY_DBMOVED

+ const SQLITE_READONLY_DIRECTORY

+ const SQLITE_READONLY_RECOVERY

+ const SQLITE_READONLY_ROLLBACK

+ const SQLITE_ROW

+ const SQLITE_SCHEMA

+ const SQLITE_TEXT

+ const SQLITE_TOOBIG

+ const SQLITE_WARNING

+ const SQLITE_WARNING_AUTOINDEX

+ var ErrBlobClosed = errors.New("blob closed")

+ var Logger func(code ErrorCode, msg []byte)

+ func ChangesetConcat(w io.Writer, r1, r2 io.Reader) error

+ func ChangesetInvert(w io.Writer, r io.Reader) error

+ type ActionInfo struct

+ Action OpType

+ Column string

+ Database string

+ Filename string

+ Function string

+ Index string

+ InnerMostTrigger string

+ Module string

+ Operation string

+ Pragma string

+ PragmaArg string

+ Savepoint string

+ Table string

+ Trigger string

+ View string

+ func (a ActionInfo) String() string

+ type AuthResult int

+ func (result AuthResult) String() string

+ type AuthorizeFunc func(info ActionInfo) AuthResult

+ func (f AuthorizeFunc) Authorize(info ActionInfo) AuthResult

+ type Authorizer interface

+ Authorize func(info ActionInfo) AuthResult

+ type Backup struct

+ func (b *Backup) Finish() error

+ func (b *Backup) PageCount() int

+ func (b *Backup) Remaining() int

+ func (b *Backup) Step(nPage int) error

+ type Blob struct

+ func (blob *Blob) Close() error

+ func (blob *Blob) ReadAt(p []byte, off int64) (n int, err error)

+ func (blob *Blob) Reopen(rowid int64) (err error)

+ func (blob *Blob) Size() int64

+ func (blob *Blob) WriteAt(p []byte, off int64) (n int, err error)

+ type Changegroup struct

+ func NewChangegroup() (*Changegroup, error)

+ func (cg Changegroup) Add(r io.Reader) error

+ func (cg Changegroup) Delete()

+ func (cg Changegroup) Output(w io.Writer) (n int, err error)

+ type ChangesetIter struct

+ func ChangesetIterStart(r io.Reader) (ChangesetIter, error)

+ func (iter ChangesetIter) Conflict(col int) (v Value, err error)

+ func (iter ChangesetIter) FKConflicts() (int, error)

+ func (iter ChangesetIter) Finalize() error

+ func (iter ChangesetIter) New(col int) (v Value, err error)

+ func (iter ChangesetIter) Next() (rowReturned bool, err error)

+ func (iter ChangesetIter) Old(col int) (v Value, err error)

+ func (iter ChangesetIter) Op() (table string, numCols int, opType OpType, indirect bool, err error)

+ func (iter ChangesetIter) PK() ([]bool, error)

+ type ColumnType int

+ func (t ColumnType) String() string

+ type ConflictAction int

+ func (code ConflictAction) String() string

+ type ConflictType int

+ func (code ConflictType) String() string

+ type Conn struct

+ BlockedOnBusy chansync.Flag

+ func OpenConn(path string, flags ...OpenFlags) (*Conn, error)

+ func (c *Conn) SetBlockOnBusy()

+ func (conn *Conn) Changes() int

+ func (conn *Conn) ChangesetApply(r io.Reader, filterFn func(tableName string) bool, ...) error

+ func (conn *Conn) ChangesetApplyInverse(r io.Reader, filterFn func(tableName string) bool, ...) error

+ func (conn *Conn) CheckReset() string

+ func (conn *Conn) Close() error

+ func (conn *Conn) CreateFunction(name string, deterministic bool, numArgs int, ...) error

+ func (conn *Conn) CreateSession(db string) (*Session, error)

+ func (conn *Conn) EnableDoubleQuotedStringLiterals(dml, ddl bool) error

+ func (conn *Conn) EnableLoadExtension(on bool) error

+ func (conn *Conn) GetAutocommit() bool

+ func (conn *Conn) GetSnapshot(schema string) (*Snapshot, func(), error)

+ func (conn *Conn) LastInsertRowID() int64

+ func (conn *Conn) Limit(id Limit, value int) int

+ func (conn *Conn) LoadExtension(ext, entry string) error

+ func (conn *Conn) OpenBlob(dbn, table, column string, row int64, write bool) (*Blob, error)

+ func (conn *Conn) Prep(query string) *Stmt

+ func (conn *Conn) Prepare(query string) (*Stmt, error)

+ func (conn *Conn) PrepareTransient(query string) (stmt *Stmt, trailingBytes int, err error)

+ func (conn *Conn) SetAuthorizer(auth Authorizer) error

+ func (conn *Conn) SetBusyTimeout(d time.Duration)

+ func (conn *Conn) SetInterrupt(doneCh <-chan struct{}) (oldDoneCh <-chan struct{})

+ func (conn *Conn) SetTracer(tracer Tracer)

+ func (conn *Conn) StartSnapshotRead(s *Snapshot) (endRead func(), err error)

+ func (conn *Conn) Tracer() Tracer

+ func (me *Conn) CSqliteObject() *C.sqlite3

+ func (src *Conn) BackupInit(srcDB, dstDB string, dst *Conn) (*Backup, error)

+ func (src *Conn) BackupToDB(srcDB, dstPath string) (dst *Conn, err error)

+ type Context struct

+ func (ctx Context) ResultBlob(v []byte)

+ func (ctx Context) ResultError(err error)

+ func (ctx Context) ResultFloat(v float64)

+ func (ctx Context) ResultInt(v int)

+ func (ctx Context) ResultInt64(v int64)

+ func (ctx Context) ResultNull()

+ func (ctx Context) ResultText(v string)

+ func (ctx Context) ResultValue(v Value)

+ func (ctx Context) ResultZeroBlob(n int64)

+ func (ctx Context) SetUserData(data interface{})

+ func (ctx Context) UserData() interface{}

+ type ErrorCode int

+ func ErrCode(err error) ErrorCode

+ func (code ErrorCode) String() string

+ func (code ErrorCode) ToError() error

+ type Incrementor func() int

+ func BindIncrementor() Incrementor

+ func ColumnIncrementor() Incrementor

+ func NewIncrementor(start int) Incrementor

+ type Limit int

+ func (limit Limit) String() string

+ type OpType int

+ const SQLITE_ALTER_TABLE

+ const SQLITE_ANALYZE

+ const SQLITE_ATTACH

+ const SQLITE_COPY

+ const SQLITE_CREATE_INDEX

+ const SQLITE_CREATE_TABLE

+ const SQLITE_CREATE_TEMP_INDEX

+ const SQLITE_CREATE_TEMP_TABLE

+ const SQLITE_CREATE_TEMP_TRIGGER

+ const SQLITE_CREATE_TEMP_VIEW

+ const SQLITE_CREATE_TRIGGER

+ const SQLITE_CREATE_VIEW

+ const SQLITE_CREATE_VTABLE

+ const SQLITE_DELETE

+ const SQLITE_DETACH

+ const SQLITE_DROP_INDEX

+ const SQLITE_DROP_TABLE

+ const SQLITE_DROP_TEMP_INDEX

+ const SQLITE_DROP_TEMP_TABLE

+ const SQLITE_DROP_TEMP_TRIGGER

+ const SQLITE_DROP_TEMP_VIEW

+ const SQLITE_DROP_TRIGGER

+ const SQLITE_DROP_VIEW

+ const SQLITE_DROP_VTABLE

+ const SQLITE_FUNCTION

+ const SQLITE_INSERT

+ const SQLITE_PRAGMA

+ const SQLITE_READ

+ const SQLITE_RECURSIVE

+ const SQLITE_REINDEX

+ const SQLITE_SAVEPOINT

+ const SQLITE_SELECT

+ const SQLITE_TRANSACTION

+ const SQLITE_UPDATE

+ func (opType OpType) String() string

+ type OpenFlags int

+ const OpenFlagsDefault

+ const SQLITE_OPEN_AUTOPROXY

+ const SQLITE_OPEN_CREATE

+ const SQLITE_OPEN_DELETEONCLOSE

+ const SQLITE_OPEN_EXCLUSIVE

+ const SQLITE_OPEN_FULLMUTEX

+ const SQLITE_OPEN_MAIN_DB

+ const SQLITE_OPEN_MAIN_JOURNAL

+ const SQLITE_OPEN_MASTER_JOURNAL

+ const SQLITE_OPEN_MEMORY

+ const SQLITE_OPEN_NOFOLLOW

+ const SQLITE_OPEN_NOMUTEX

+ const SQLITE_OPEN_PRIVATECACHE

+ const SQLITE_OPEN_READONLY

+ const SQLITE_OPEN_READWRITE

+ const SQLITE_OPEN_SHAREDCACHE

+ const SQLITE_OPEN_SUBJOURNAL

+ const SQLITE_OPEN_TEMP_DB

+ const SQLITE_OPEN_TEMP_JOURNAL

+ const SQLITE_OPEN_TRANSIENT_DB

+ const SQLITE_OPEN_URI

+ const SQLITE_OPEN_WAL

+ func (o OpenFlags) String() string

+ type Session struct

+ func (s *Session) Attach(tableName string) error

+ func (s *Session) Changeset(w io.Writer) error

+ func (s *Session) Delete()

+ func (s *Session) Diff(srcDB, tableName string) error

+ func (s *Session) Disable()

+ func (s *Session) Enable()

+ func (s *Session) Patchset(w io.Writer) error

+ type Snapshot struct

+ func (s *Snapshot) CompareAges(s2 *Snapshot) int

+ func (s *Snapshot) Free()

+ type Stmt struct

+ func (stmt *Stmt) BindBool(param int, value bool)

+ func (stmt *Stmt) BindBytes(param int, value []byte)

+ func (stmt *Stmt) BindFloat(param int, value float64)

+ func (stmt *Stmt) BindInt64(param int, value int64)

+ func (stmt *Stmt) BindNull(param int)

+ func (stmt *Stmt) BindParamCount() int

+ func (stmt *Stmt) BindParamName(param int) string

+ func (stmt *Stmt) BindText(param int, value string)

+ func (stmt *Stmt) BindZeroBlob(param int, len int64)

+ func (stmt *Stmt) ClearBindings() error

+ func (stmt *Stmt) ColumnBytes(col int, buf []byte) int

+ func (stmt *Stmt) ColumnCount() int

+ func (stmt *Stmt) ColumnDatabaseName(col int) string

+ func (stmt *Stmt) ColumnFloat(col int) float64

+ func (stmt *Stmt) ColumnIndex(colName string) int

+ func (stmt *Stmt) ColumnInt(col int) int

+ func (stmt *Stmt) ColumnInt32(col int) int32

+ func (stmt *Stmt) ColumnInt64(col int) int64

+ func (stmt *Stmt) ColumnLen(col int) int

+ func (stmt *Stmt) ColumnName(col int) string

+ func (stmt *Stmt) ColumnReader(col int) *bytes.Reader

+ func (stmt *Stmt) ColumnTableName(col int) string

+ func (stmt *Stmt) ColumnText(col int) string

+ func (stmt *Stmt) ColumnType(col int) ColumnType

+ func (stmt *Stmt) ColumnViewBytes(col int) []byte

+ func (stmt *Stmt) DataCount() int

+ func (stmt *Stmt) Finalize() error

+ func (stmt *Stmt) GetBytes(colName string, buf []byte) int

+ func (stmt *Stmt) GetFloat(colName string) float64

+ func (stmt *Stmt) GetInt64(colName string) int64

+ func (stmt *Stmt) GetLen(colName string) int

+ func (stmt *Stmt) GetReader(colName string) *bytes.Reader

+ func (stmt *Stmt) GetText(colName string) string

+ func (stmt *Stmt) GetType(colName string) ColumnType

+ func (stmt *Stmt) Reset() error

+ func (stmt *Stmt) SetBool(param string, value bool)

+ func (stmt *Stmt) SetBytes(param string, value []byte)

+ func (stmt *Stmt) SetFloat(param string, value float64)

+ func (stmt *Stmt) SetInt64(param string, value int64)

+ func (stmt *Stmt) SetNull(param string)

+ func (stmt *Stmt) SetText(param string, value string)

+ func (stmt *Stmt) SetZeroBlob(param string, len int64)

+ func (stmt *Stmt) Step() (rowReturned bool, err error)

+ type Tracer interface

+ NewTask func(name string) TracerTask

+ Pop func()

+ Push func(name string)

+ type TracerTask interface

+ End func()

+ EndRegion func()

+ StartRegion func(regionType string)

+ type Value struct

+ func (v Value) Blob() []byte

+ func (v Value) Float() float64

+ func (v Value) Int() int

+ func (v Value) Int64() int64

+ func (v Value) IsNil() bool

+ func (v Value) Len() int

+ func (v Value) Text() string

+ func (v Value) Type() ColumnType

v0.1.3

Nov 20, 2025

v0.1.2

Nov 13, 2025

v0.1.1

Nov 12, 2025

v0.1.0

Nov 12, 2025

Changes in this version

+ const TimeFormat

+ var ErrClosed = errors.New("sqlite3: already closed")

+ var Open sqliteh.OpenFunc = func(string, sqliteh.OpenFlags, string) (sqliteh.DB, error)

+ var UsesAfterClose expvar.Map

+ func BusyTimeout(sqlconn SQLConn, d time.Duration) error

+ func Checkpoint(sqlconn SQLConn, dbName string, mode sqliteh.Checkpoint) (numFrames, numFramesCheckpointed int, err error)

+ func Connector(sqliteURI string, connInitFunc ConnInitFunc, tracer sqliteh.Tracer) driver.Connector

+ func ConnectorWithLogger(sqliteURI string, connInitFunc ConnInitFunc, tracer sqliteh.Tracer, ...) driver.Connector

+ func CopyAll(ctx context.Context, conn *sql.Conn, dstSchemaName, srcSchemaName string) (err error)

+ func DisableFunction(sqlconn SQLConn, name string, numArgs int) error

+ func DropAll(ctx context.Context, conn *sql.Conn, schemaName string) (err error)

+ func ExecScript(sqlconn SQLConn, queries string) error

+ func IsReadOnly(ctx context.Context) bool

+ func ReadOnly(ctx context.Context) context.Context

+ func SetLogCallback(callback LogCallback) error

+ func SetWALHook(sqlconn SQLConn, hook func(dbName string, pages int)) error

+ func TxnState(sqlconn SQLConn, schema string) (state sqliteh.TxnState, err error)

+ func WithPersist(ctx context.Context) context.Context

+ func WithQueryCancel(ctx context.Context) context.Context

+ type ConnInitFunc func(ctx context.Context, conn driver.ConnPrepareContext) error

+ type ConnLogger interface

+ Begin func()

+ Commit func(error)

+ Rollback func()

+ Statement func(sql string)

+ type Error struct

+ Code sqliteh.Code

+ Loc string

+ Msg string

+ Query string

+ func (err Error) Error() string

+ type LogCallback func(code sqliteh.Code, msg string)

+ type SQLConn interface

+ Raw func(func(driverConn any) error) error