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