sqlite3

package module

Go to main page

Versions in this module

v1

v1.14.46

Apr 29, 2026

v1.14.45

Apr 16, 2026

v1.14.44

Apr 16, 2026

Changes in this version

+ const OpEQ

+ const OpFUNCTION

+ const OpGE

+ const OpGLOB

+ const OpGT

+ const OpIS

+ const OpISNOT

+ const OpISNOTNULL

+ const OpISNULL

+ const OpLE

+ const OpLIKE

+ const OpLIMIT

+ const OpLT

+ const OpMATCH

+ const OpNE

+ const OpOFFSET

+ const OpREGEXP

+ const OpScanUnique

+ type EponymousOnlyModule interface

+ EponymousOnlyModule func()

+ type IndexResult struct

+ AlreadyOrdered bool

+ EstimatedCost float64

+ EstimatedRows float64

+ IdxNum int

+ IdxStr string

+ Used []bool

+ type InfoConstraint struct

+ Column int

+ Op Op

+ Usable bool

+ type InfoOrderBy struct

+ Column int

+ Desc bool

+ type Module interface

+ Connect func(c *SQLiteConn, args []string) (VTab, error)

+ Create func(c *SQLiteConn, args []string) (VTab, error)

+ DestroyModule func()

+ type Op uint8

type SQLiteConn

+ func (c *SQLiteConn) CreateModule(moduleName string, module Module) error

+ func (c *SQLiteConn) DeclareVTab(sql string) error

+ type VTab interface

+ BestIndex func([]InfoConstraint, []InfoOrderBy) (*IndexResult, error)

+ Destroy func() error

+ Disconnect func() error

+ Open func() (VTabCursor, error)

+ type VTabCursor interface

+ Close func() error

+ Column func(c *SQLiteContext, col int) error

+ EOF func() bool

+ Filter func(idxNum int, idxStr string, vals []any) error

+ Next func() error

+ Rowid func() (int64, error)

+ type VTabUpdater interface

+ Delete func(any) error

+ Insert func(any, []any) (int64, error)

+ Update func(any, []any) error

v1.14.43

Apr 15, 2026

v1.14.38

Mar 21, 2026

v1.14.36

Jan 19, 2026

v1.14.35

Jan 3, 2026

v1.14.34

Oct 8, 2025

Changes in this version

+ const SQLITE_BLOB

+ const SQLITE_BOOL

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

+ const SQLITE_NULL

+ const SQLITE_NUMERIC

+ const SQLITE_REAL

+ const SQLITE_TEXT

+ const SQLITE_TIME

type Error

+ SystemErrno syscall.Errno

type SQLiteConn

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

+ 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

type SQLitePreUpdateData

+ func (d *SQLitePreUpdateData) Count() int

+ func (d *SQLitePreUpdateData) Depth() int

+ func (d *SQLitePreUpdateData) New(dest ...any) error

+ func (d *SQLitePreUpdateData) Old(dest ...any) error

type SQLiteStmt

+ func (s *SQLiteStmt) Readonly() bool

v1.13.0

Nov 18, 2019

v1.12.0

Oct 8, 2019

Changes in this version

type SQLiteConn

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

+ type SQLitePreUpdateData struct

+ Conn *SQLiteConn

+ DatabaseName string

+ NewRowID int64

+ OldRowID int64

+ Op int

+ TableName string

v1.11.0

Jul 16, 2019

v1.10.0

Oct 24, 2018

Changes in this version

+ 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_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_FUNCTION

+ const SQLITE_IGNORE

+ const SQLITE_OK

+ const SQLITE_PRAGMA

+ const SQLITE_READ

+ const SQLITE_REINDEX

+ const SQLITE_SAVEPOINT

+ const SQLITE_SELECT

+ const SQLITE_TRANSACTION

type SQLiteConn

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

v1.9.0

Jun 13, 2018

v1.8.0

Jun 12, 2018

Changes in this version

+ func CryptEncoderSHA1(pass []byte, hash interface{}) []byte

+ func CryptEncoderSHA256(pass []byte, hash interface{}) []byte

+ func CryptEncoderSHA384(pass []byte, hash interface{}) []byte

+ func CryptEncoderSHA512(pass []byte, hash interface{}) []byte

+ func CryptEncoderSSHA1(salt string) func(pass []byte, hash interface{}) []byte

+ func CryptEncoderSSHA256(salt string) func(pass []byte, hash interface{}) []byte

+ func CryptEncoderSSHA384(salt string) func(pass []byte, hash interface{}) []byte

+ func CryptEncoderSSHA512(salt string) func(pass []byte, hash interface{}) []byte

type SQLiteConn

+ 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) GetFilename(schemaName string) string

v1.7.0

May 24, 2018

v1.6.0

Jan 12, 2018

v1.5.0

Nov 22, 2017

v1.4.0

Nov 14, 2017

Changes in this version

+ 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

type SQLiteConn

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

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

v1.3.0

Sep 28, 2017

Changes in this version

+ const SQLITE_DELETE

+ const SQLITE_INSERT

+ const SQLITE_UPDATE

type SQLiteConn

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

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

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

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

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

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

v1.2.0

Nov 11, 2016

Changes in this version

+ var ErrConstraintRowID = ErrConstraint.Extend(10)

type SQLiteConn

+ func (c *SQLiteConn) BeginContext(ctx context.Context) (driver.Tx, error)

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

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

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

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

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

+ func (c *SQLiteConn) RegisterAggregator(name string, impl interface{}, pure bool) error

+ func (c *SQLiteConn) RegisterFunc(name string, impl interface{}, pure bool) error

type SQLiteRows

+ 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) DeclTypes() []string

type SQLiteStmt

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

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

v1.1.0

Sep 5, 2015

v1.0.0

Jun 29, 2015

Changes in this version

+ const ErrNoMask

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

+ 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) AutoCommit() bool

+ func (c *SQLiteConn) Backup(dest string, conn *SQLiteConn, src string) (*SQLiteBackup, error)

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

+ func (c *SQLiteConn) Close() error

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

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

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

+ type SQLiteDriver struct

+ ConnectHook func(*SQLiteConn) error

+ Extensions []string

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

+ 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) Columns() []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) NumInput() int

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

+ type SQLiteTx struct

+ func (tx *SQLiteTx) Commit() error

+ func (tx *SQLiteTx) Rollback() error

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL