Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  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

sqlite3

package module

Go to main page

Versions in this module

v1

v1.0.3

Sep 1, 2023

Changes in this version

type SQLiteConn

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

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

v1.0.2

Jul 6, 2023

v1.0.1

Jun 16, 2023

v1.0.0

Jun 16, 2023

retracted

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

+ func IsEncrypted(filename string) (bool, error)

+ 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) 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 interface{}, 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 interface{}, 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) SetFileControlInt(dbName string, op int, arg int) 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