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

go-sqlite3

module

Go to main page

Versions in this module

v1

v1.14.39

Dec 17, 2025

v1.14.38

Dec 17, 2025

v1.14.37

Dec 17, 2025

v1.14.36

Dec 17, 2025

v1.14.35

Dec 17, 2025

v1.14.34

Dec 16, 2025

v1.14.33

Dec 16, 2025

v1.14.32

Dec 16, 2025

Changes in this version

+ const ErrNoMask

+ const SQLITE_ALTER_TABLE

+ const SQLITE_ANALYZE

+ const SQLITE_ATTACH

+ const SQLITE_BLOB

+ const SQLITE_BOOL

+ 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_DENY

+ 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_FCNTL_BEGIN_ATOMIC_WRITE

+ const SQLITE_FCNTL_BUSYHANDLER

+ const SQLITE_FCNTL_CHUNK_SIZE

+ const SQLITE_FCNTL_CKPT_DONE

+ const SQLITE_FCNTL_CKPT_START

+ const SQLITE_FCNTL_CKSM_FILE

+ const SQLITE_FCNTL_COMMIT_ATOMIC_WRITE

+ const SQLITE_FCNTL_COMMIT_PHASETWO

+ const SQLITE_FCNTL_DATA_VERSION

+ const SQLITE_FCNTL_EXTERNAL_READER

+ const SQLITE_FCNTL_FILE_POINTER

+ const SQLITE_FCNTL_GET_LOCKPROXYFILE

+ const SQLITE_FCNTL_HAS_MOVED

+ const SQLITE_FCNTL_JOURNAL_POINTER

+ const SQLITE_FCNTL_LAST_ERRNO

+ const SQLITE_FCNTL_LOCKSTATE

+ const SQLITE_FCNTL_LOCK_TIMEOUT

+ const SQLITE_FCNTL_MMAP_SIZE

+ const SQLITE_FCNTL_OVERWRITE

+ const SQLITE_FCNTL_PDB

+ const SQLITE_FCNTL_PERSIST_WAL

+ const SQLITE_FCNTL_POWERSAFE_OVERWRITE

+ const SQLITE_FCNTL_PRAGMA

+ const SQLITE_FCNTL_RBU

+ const SQLITE_FCNTL_RESERVE_BYTES

+ const SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE

+ const SQLITE_FCNTL_SET_LOCKPROXYFILE

+ const SQLITE_FCNTL_SIZE_HINT

+ const SQLITE_FCNTL_SIZE_LIMIT

+ const SQLITE_FCNTL_SYNC

+ const SQLITE_FCNTL_SYNC_OMITTED

+ const SQLITE_FCNTL_TEMPFILENAME

+ const SQLITE_FCNTL_TRACE

+ const SQLITE_FCNTL_VFSNAME

+ const SQLITE_FCNTL_VFS_POINTER

+ const SQLITE_FCNTL_WAL_BLOCK

+ const SQLITE_FCNTL_WIN32_AV_RETRY

+ const SQLITE_FCNTL_WIN32_GET_HANDLE

+ const SQLITE_FCNTL_WIN32_SET_HANDLE

+ const SQLITE_FCNTL_ZIPVFS

+ const SQLITE_FUNCTION

+ const SQLITE_IGNORE

+ const SQLITE_INSERT

+ const SQLITE_INTEGER

+ 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_NULL

+ const SQLITE_NUMERIC

+ const SQLITE_OK

+ const SQLITE_PRAGMA

+ const SQLITE_READ

+ const SQLITE_REAL

+ const SQLITE_REINDEX

+ const SQLITE_SAVEPOINT

+ const SQLITE_SELECT

+ const SQLITE_TEXT

+ const SQLITE_TIME

+ const SQLITE_TRANSACTION

+ const SQLITE_UPDATE

+ var ErrAbort = ErrNo(4)

+ var ErrAbortRollback = ErrAbort.Extend(2)

+ var ErrAuth = ErrNo(23)

+ var ErrBusy = ErrNo(5)

+ var ErrBusyRecovery = ErrBusy.Extend(1)

+ var ErrBusySnapshot = ErrBusy.Extend(2)

+ var ErrCantOpen = ErrNo(14)

+ var ErrCantOpenConvPath = ErrCantOpen.Extend(4)

+ var ErrCantOpenFullPath = ErrCantOpen.Extend(3)

+ var ErrCantOpenIsDir = ErrCantOpen.Extend(2)

+ var ErrCantOpenNoTempDir = ErrCantOpen.Extend(1)

+ var ErrConstraint = ErrNo(19)

+ var ErrConstraintCheck = ErrConstraint.Extend(1)

+ var ErrConstraintCommitHook = ErrConstraint.Extend(2)

+ var ErrConstraintForeignKey = ErrConstraint.Extend(3)

+ var ErrConstraintFunction = ErrConstraint.Extend(4)

+ var ErrConstraintNotNull = ErrConstraint.Extend(5)

+ var ErrConstraintPrimaryKey = ErrConstraint.Extend(6)

+ var ErrConstraintRowID = ErrConstraint.Extend(10)

+ var ErrConstraintTrigger = ErrConstraint.Extend(7)

+ var ErrConstraintUnique = ErrConstraint.Extend(8)

+ var ErrConstraintVTab = ErrConstraint.Extend(9)

+ var ErrCorrupt = ErrNo(11)

+ var ErrCorruptVTab = ErrCorrupt.Extend(1)

+ var ErrEmpty = ErrNo(16)

+ var ErrError = ErrNo(1)

+ var ErrFormat = ErrNo(24)

+ var ErrFull = ErrNo(13)

+ var ErrInternal = ErrNo(2)

+ var ErrInterrupt = ErrNo(9)

+ var ErrIoErr = ErrNo(10)

+ var ErrIoErrAccess = ErrIoErr.Extend(13)

+ var ErrIoErrBlocked = ErrIoErr.Extend(11)

+ var ErrIoErrCheckReservedLock = ErrIoErr.Extend(14)

+ var ErrIoErrClose = ErrIoErr.Extend(16)

+ var ErrIoErrConvPath = ErrIoErr.Extend(26)

+ var ErrIoErrDelete = ErrIoErr.Extend(10)

+ var ErrIoErrDeleteNoent = ErrIoErr.Extend(23)

+ var ErrIoErrDirClose = ErrIoErr.Extend(17)

+ var ErrIoErrDirFsync = ErrIoErr.Extend(5)

+ var ErrIoErrFstat = ErrIoErr.Extend(7)

+ var ErrIoErrFsync = ErrIoErr.Extend(4)

+ var ErrIoErrGetTempPath = ErrIoErr.Extend(25)

+ var ErrIoErrLock = ErrIoErr.Extend(15)

+ var ErrIoErrMMap = ErrIoErr.Extend(24)

+ var ErrIoErrNoMem = ErrIoErr.Extend(12)

+ var ErrIoErrRDlock = ErrIoErr.Extend(9)

+ var ErrIoErrRead = ErrIoErr.Extend(1)

+ var ErrIoErrSHMLock = ErrIoErr.Extend(20)

+ var ErrIoErrSHMMap = ErrIoErr.Extend(21)

+ var ErrIoErrSHMOpen = ErrIoErr.Extend(18)

+ var ErrIoErrSHMSize = ErrIoErr.Extend(19)

+ var ErrIoErrSeek = ErrIoErr.Extend(22)

+ var ErrIoErrShortRead = ErrIoErr.Extend(2)

+ var ErrIoErrTruncate = ErrIoErr.Extend(6)

+ var ErrIoErrUnlock = ErrIoErr.Extend(8)

+ var ErrIoErrWrite = ErrIoErr.Extend(3)

+ var ErrLocked = ErrNo(6)

+ var ErrLockedSharedCache = ErrLocked.Extend(1)

+ var ErrMismatch = ErrNo(20)

+ var ErrMisuse = ErrNo(21)

+ var ErrNoLFS = ErrNo(22)

+ var ErrNomem = ErrNo(7)

+ var ErrNotADB = ErrNo(26)

+ var ErrNotFound = ErrNo(12)

+ var ErrNotice = ErrNo(27)

+ var ErrNoticeRecoverRollback = ErrNotice.Extend(2)

+ var ErrNoticeRecoverWAL = ErrNotice.Extend(1)

+ var ErrPerm = ErrNo(3)

+ var ErrProtocol = ErrNo(15)

+ var ErrRange = ErrNo(25)

+ var ErrReadonly = ErrNo(8)

+ var ErrReadonlyCantLock = ErrReadonly.Extend(2)

+ var ErrReadonlyDbMoved = ErrReadonly.Extend(4)

+ var ErrReadonlyRecovery = ErrReadonly.Extend(1)

+ var ErrReadonlyRollback = ErrReadonly.Extend(3)

+ var ErrSchema = ErrNo(17)

+ var ErrTooBig = ErrNo(18)

+ var ErrWarning = ErrNo(28)

+ var ErrWarningAutoIndex = ErrWarning.Extend(1)

+ var SQLiteTimestampFormats = []string

+ func CryptEncoderSHA1(pass []byte, hash any) []byte

+ func CryptEncoderSHA256(pass []byte, hash any) []byte

+ func CryptEncoderSHA384(pass []byte, hash any) []byte

+ func CryptEncoderSHA512(pass []byte, hash any) []byte

+ func CryptEncoderSSHA1(salt string) func(pass []byte, hash any) []byte

+ func CryptEncoderSSHA256(salt string) func(pass []byte, hash any) []byte

+ func CryptEncoderSSHA384(salt string) func(pass []byte, hash any) []byte

+ func CryptEncoderSSHA512(salt string) func(pass []byte, hash any) []byte

+ func Version() (libVersion string, libVersionNumber int, sourceID string)

+ type ErrNo int

+ func (err ErrNo) Error() string

+ func (err ErrNo) Extend(by int) ErrNoExtended

+ type ErrNoExtended int

+ func (err ErrNoExtended) Error() string

+ type Error struct

+ Code ErrNo

+ ExtendedCode ErrNoExtended

+ SystemErrno syscall.Errno

+ func (err Error) Error() string

+ type SQLiteBackup struct

+ func (b *SQLiteBackup) Close() error

+ func (b *SQLiteBackup) Finish() error

+ func (b *SQLiteBackup) PageCount() int

+ func (b *SQLiteBackup) Remaining() int

+ func (b *SQLiteBackup) Step(p int) (bool, error)

+ type SQLiteConn struct

+ func (c *SQLiteConn) AuthEnabled() (exists bool)

+ func (c *SQLiteConn) AuthUserAdd(username, password string, admin bool) error

+ func (c *SQLiteConn) AuthUserChange(username, password string, admin bool) error

+ func (c *SQLiteConn) AuthUserDelete(username string) error

+ func (c *SQLiteConn) Authenticate(username, password string) error

+ func (c *SQLiteConn) AutoCommit() bool

+ func (c *SQLiteConn) Begin() (driver.Tx, error)

+ func (c *SQLiteConn) BeginTx(ctx context.Context, opts driver.TxOptions) (driver.Tx, error)

+ func (c *SQLiteConn) Close() error

+ func (c *SQLiteConn) Deserialize(b []byte, schema string) error

+ func (c *SQLiteConn) Exec(query string, args []driver.Value) (driver.Result, error)

+ func (c *SQLiteConn) ExecContext(ctx context.Context, query string, args []driver.NamedValue) (driver.Result, error)

+ func (c *SQLiteConn) GetFilename(schemaName string) string

+ func (c *SQLiteConn) GetLimit(id int) int

+ func (c *SQLiteConn) LoadExtension(lib string, entry string) error

+ func (c *SQLiteConn) Ping(ctx context.Context) error

+ func (c *SQLiteConn) Prepare(query string) (driver.Stmt, error)

+ func (c *SQLiteConn) PrepareContext(ctx context.Context, query string) (driver.Stmt, error)

+ func (c *SQLiteConn) Query(query string, args []driver.Value) (driver.Rows, error)

+ func (c *SQLiteConn) QueryContext(ctx context.Context, query string, args []driver.NamedValue) (driver.Rows, error)

+ func (c *SQLiteConn) RegisterAggregator(name string, impl any, pure bool) error

+ func (c *SQLiteConn) RegisterAuthorizer(callback func(int, string, string, string) int)

+ func (c *SQLiteConn) RegisterCollation(name string, cmp func(string, string) int) error

+ func (c *SQLiteConn) RegisterCommitHook(callback func() int)

+ func (c *SQLiteConn) RegisterFunc(name string, impl any, pure bool) error

+ func (c *SQLiteConn) RegisterPreUpdateHook(callback func(SQLitePreUpdateData))

+ func (c *SQLiteConn) RegisterRollbackHook(callback func())

+ func (c *SQLiteConn) RegisterUpdateHook(callback func(int, string, string, int64))

+ func (c *SQLiteConn) Serialize(schema string) ([]byte, error)

+ func (c *SQLiteConn) SetFileControlInt(dbName string, op int, arg int) error

+ func (c *SQLiteConn) SetFileControlInt64(dbName string, op int, arg int64) error

+ func (c *SQLiteConn) SetLimit(id int, newVal int) int

+ func (destConn *SQLiteConn) Backup(dest string, srcConn *SQLiteConn, src string) (*SQLiteBackup, error)

+ type SQLiteContext C.sqlite3_context

+ func (c *SQLiteContext) ResultBlob(b []byte)

+ func (c *SQLiteContext) ResultBool(b bool)

+ func (c *SQLiteContext) ResultDouble(d float64)

+ func (c *SQLiteContext) ResultInt(i int)

+ func (c *SQLiteContext) ResultInt64(i int64)

+ func (c *SQLiteContext) ResultNull()

+ func (c *SQLiteContext) ResultText(s string)

+ func (c *SQLiteContext) ResultZeroblob(n int)

+ type SQLiteDriver struct

+ ConnectHook func(*SQLiteConn) error

+ Extensions []string

+ func (d *SQLiteDriver) Open(dsn string) (driver.Conn, error)

+ type SQLitePreUpdateData struct

+ Conn *SQLiteConn

+ DatabaseName string

+ NewRowID int64

+ OldRowID int64

+ Op int

+ TableName string

+ type SQLiteResult struct

+ func (r *SQLiteResult) LastInsertId() (int64, error)

+ func (r *SQLiteResult) RowsAffected() (int64, error)

+ type SQLiteRows struct

+ func (rc *SQLiteRows) Close() error

+ func (rc *SQLiteRows) ColumnTypeDatabaseTypeName(i int) string

+ func (rc *SQLiteRows) ColumnTypeNullable(i int) (nullable, ok bool)

+ func (rc *SQLiteRows) ColumnTypeScanType(i int) reflect.Type

+ func (rc *SQLiteRows) Columns() []string

+ func (rc *SQLiteRows) DeclTypes() []string

+ func (rc *SQLiteRows) Next(dest []driver.Value) error

+ type SQLiteStmt struct

+ func (s *SQLiteStmt) Close() error

+ func (s *SQLiteStmt) Exec(args []driver.Value) (driver.Result, error)

+ func (s *SQLiteStmt) ExecContext(ctx context.Context, args []driver.NamedValue) (driver.Result, error)

+ func (s *SQLiteStmt) NumInput() int

+ func (s *SQLiteStmt) Query(args []driver.Value) (driver.Rows, error)

+ func (s *SQLiteStmt) QueryContext(ctx context.Context, args []driver.NamedValue) (driver.Rows, error)

+ func (s *SQLiteStmt) Readonly() bool

+ type SQLiteTx struct

+ func (tx *SQLiteTx) Commit() error

+ func (tx *SQLiteTx) Rollback() error