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

sqlite

package module

Go to main page

Versions in this module

v0

v0.5.8

Apr 19, 2024

v0.5.7

Mar 26, 2024

v0.5.6

Mar 5, 2024

Changes in this version

type Connections

+ func (c *Connections) FreeCount() int

v0.5.5

Feb 29, 2024

v0.5.4

Jan 18, 2024

v0.5.3

Nov 28, 2023

v0.5.2

Nov 24, 2023

v0.5.1

Nov 20, 2023

v0.5.0

Nov 19, 2023

Changes in this version

+ const MemoryPath

+ const NoMoreRow

+ var BusyTransaction = errText[C.SQLITE_BUSY]

+ var DBName = "main"

+ var DuplicateRecords = errors.New("duplicate records in scanone")

+ var ErrNull = errors.New("null SQL value")

+ var HashSeed = maphash.MakeSeed()

+ var NumThreads = 32

+ var ObsLastQueries = RegisterTable("obs_lastqueries", queryRecord{})

+ func BackupDB(pool *Connections, dest string) error

+ func GetBuffer() *bytes.Buffer

+ func HashString(s string) int64

+ func IsComplete(st string) bool

+ func LoadExtensions(db SQLITE3)

+ func Register(f ...func(SQLITE3))

+ func RegisterConstant(name string, value any) func(SQLITE3)

+ func RegisterFunc(name string, t any) func(SQLITE3)

+ func RegisterTable[T Filtrer[T]](name string, vt T, opts ...VirtualTableOption) func(SQLITE3)

+ func RememberQuery(q string)

+ func ReturnBuffer(b *bytes.Buffer)

+ type ColStrings map[string]*string

+ type Conn struct

+ func Open(name string, exts ...func(SQLITE3)) (*Conn, error)

+ func (c *Conn) Close() error

+ func (c *Conn) Exec(ctx context.Context, cmd string, args ...any) *Rows

+ func (cn *Conn) CreateBLOB(database, table, column string, size int) (*DirectBLOB, error)

+ func (cn *Conn) OpenBLOB(database, table, column string, rownum int) (*DirectBLOB, error)

+ func (ctn *Conn) Release(ctx context.Context) error

+ func (ctn *Conn) Rollback(ctx context.Context) error

+ func (ctn *Conn) Savepoint(ctx context.Context) (context.Context, error)

+ type Connections struct

+ func OpenPool(name string, exts ...func(SQLITE3)) (*Connections, error)

+ func (p *Connections) Close() error

+ func (p *Connections) Exec(ctx context.Context, cmd string, args ...any) *Rows

+ func (p *Connections) Release(ctx context.Context) error

+ func (p *Connections) Rollback(ctx context.Context) error

+ func (p *Connections) Savepoint(ctx context.Context) (context.Context, error)

+ type Constraint struct

+ Column string

+ Operation Op

+ Value any

+ func (v Constraint) ValueBool() bool

+ func (v Constraint) ValueBytes() []byte

+ func (v Constraint) ValueInt() int

+ func (v Constraint) ValueString() string

+ type Constraints []Constraint

+ type DirectBLOB struct

+ RowNumber int

+ func (r *DirectBLOB) Close() error

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

+ func (r *DirectBLOB) Size() int

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

+ type Filtrer interface

+ Filter func(int, Constraints) Iter[T]

+ type Hasher interface

+ Hash64 func() int64

+ type IndexState interface

+ SelectIndex func(int)

+ Use func(constraint int)

+ type Indexer interface

+ BestIndex func(IndexState, Constraints) (estimatedCost, estimatedRows int64)

+ type Iter interface

+ Err func() error

+ Next func() bool

+ Value func() T

+ func FromArray[T any](values []T) Iter[T]

+ func FromError[T any](err error) Iter[T]

+ func FromOne[T any](v T) Iter[T]

+ func None[T any]() Iter[T]

+ func TransformArray[T, U any](values []T, trans func(T) U) Iter[U]

+ type MultiString []string

+ type NullString string

+ type Op uint8

+ const ConstraintEQ

+ const ConstraintFUNCTION

+ const ConstraintGE

+ const ConstraintGLOB

+ const ConstraintGT

+ const ConstraintIS

+ const ConstraintISNOT

+ const ConstraintISNOTNULL

+ const ConstraintISNULL

+ const ConstraintLE

+ const ConstraintLIKE

+ const ConstraintLIMIT

+ const ConstraintLT

+ const ConstraintMATCH

+ const ConstraintNE

+ const ConstraintOFFSET

+ const ConstraintREGEXP

+ func (op *Op) Scan(st fmt.ScanState, verb rune) error

+ func (op Op) String() string

+ type PointerValue struct

+ func AsPointer(v any) PointerValue

+ type Rows struct

+ func (r *Rows) Bytecode() string

+ func (r *Rows) Err() error

+ func (r *Rows) ExplainQueryPlan() string

+ func (r *Rows) IsExplain() bool

+ func (r *Rows) ScanOne(dst ...any) error

+ func (rows *Rows) ColumnName(i int) string

+ func (rows *Rows) Next() bool

+ func (rows *Rows) NumColumn() int

+ func (rows *Rows) Scan(dst ...any)

+ type SQLITE3 *C.sqlite3

+ type Updater interface

+ Update func(_ context.Context, index int64, value T) error

+ type VirtualTableOption func(*rVM)

+ func OverloadFunc(name string, fn any) VirtualTableOption