Versions in this module Expand all Collapse all v0 v0.3.0 Jun 8, 2026 Changes in this version + const OverflowPageHeaderSize + var ErrBadMagic = errors.New("sqlite: bad magic header") + var ErrBadPageSize = errors.New("sqlite: invalid page size") + var ErrBadPageType = errors.New("sqlite: invalid page type") + var ErrBadPayloadFrac = errors.New("sqlite: invalid payload fraction") + var ErrBadSerialType = errors.New("sqlite: invalid serial type") + var ErrCellTooSmall = errors.New("sqlite: cell data too small") + var ErrHeaderTooSmall = errors.New("sqlite: header data too small") + var ErrNoColumns = errors.New("sqlite: record has no columns") + var ErrPageHeaderTooSmall = errors.New("sqlite: page header data too small") + var ErrRecordTooSmall = errors.New("sqlite: record data too small") + var ErrTruncatedRecord = errors.New("sqlite: truncated record body") + var KeywordMap = map[string]TokenType + var NullValue = Value + func CloseDB(db *sql.DB) + func ComputePayloadSizes(payloadLen, usableSize int, isLeaf bool) (localSize, overflowSize int) + func DecodeVarint(data []byte) (int64, int, error) + func DecodeVarintRaw(data []byte) (uint64, int, error) + func EncodeVarint(v int64) []byte + func EncodeVarintInto(v uint64, buf []byte, off int) int + func EncodeVarintRaw(v uint64) []byte + func ExprString(expr Expr) string + func MaxOverflowPayload(usableSize int) int + func Open() (*sql.DB, error) + func OpenFile(path string) (*sql.DB, error) + func OpenWithData(data []byte) (*sql.DB, error) + func PutRecord(r *Record) + func ReadCellPointers(data []byte, offset int, count int) []uint16 + func ReadOverflowPage(data []byte, usableSize int) (nextPage uint32, payload []byte, err error) + func ReadRecordIntoRecord(data []byte, rec *Record, buf []Value) error + func VarintSize(v uint64) int + func WriteCell(c *Cell) []byte + func WriteCellPointers(ptrs []uint16) []byte + func WriteFreelistTrunk(trunk *FreelistTrunk, usableSize int) []byte + func WriteHeader(h *DatabaseHeader) []byte + func WriteInteriorTableCell(c *Cell) []byte + func WriteLeafTableCell(c *Cell) []byte + func WriteOverflowPage(nextPage uint32, payload []byte, usableSize int) []byte + func WritePageHeader(h *PageHeader) []byte + func WritePageHeaderTo(data []byte, h PageHeader) + func WriteRecord(r *Record) []byte + type AlterAddColumnStmt struct + Column ColumnDefAST + Table string + type AlterRenameColumnStmt struct + NewName string + OldName string + Table string + type AlterRenameTableStmt struct + NewName string + OldName string + type BTree struct + func NewBTree(pager *Pager) *BTree + func (b *BTree) CreateBTree() (int, error) + func (b *BTree) Delete(rootPage int, rowid int64) error + func (b *BTree) Insert(rootPage int, rowid int64, record *Record) error + func (b *BTree) Scan(rootPage int) (CursorInterface, error) + func (b *BTree) Search(rootPage int, rowid int64) (*Record, error) + type BTreeCursor struct + func (c *BTreeCursor) Close() error + func (c *BTreeCursor) Get() (int64, *Record, error) + func (c *BTreeCursor) Next() bool + func (c *BTreeCursor) RawRecordData() []byte + func (c *BTreeCursor) SeekToRowid(target int64) error + type BTreeInterface interface + CreateBTree func() (int, error) + Delete func(rootPage int, rowid int64) error + Insert func(rootPage int, rowid int64, record *Record) error + Scan func(rootPage int) (CursorInterface, error) + Search func(rootPage int, rowid int64) (*Record, error) + type BeginStmt struct + type BetweenExpr struct + Expr Expr + High Expr + Low Expr + Negate bool + func (e BetweenExpr) String() string + type BinaryExpr struct + Left Expr + Op BinaryOp + Right Expr + func (e BinaryExpr) String() string + type BinaryOp int + const OpAdd + const OpAnd + const OpBitAnd + const OpBitOr + const OpConcat + const OpDiv + const OpEq + const OpGe + const OpGt + const OpLe + const OpLt + const OpMod + const OpMul + const OpNe + const OpOr + const OpShiftLeft + const OpShiftRight + const OpSub + type CaseExpr struct + Else Expr + Operand Expr + Whens []CaseWhen + func (e CaseExpr) String() string + type CaseWhen struct + Condition Expr + Result Expr + type CastExpr struct + Expr Expr + Type string + func (e CastExpr) String() string + type Cell struct + IsLeaf bool + Key uint64 + LeftChildPage uint32 + OverflowPage uint32 + Payload []byte + PayloadSize uint64 + RowID uint64 + func ReadCell(data []byte, pageType byte) (*Cell, int, error) + type ColumnAffinity int + const AffinityBlob + const AffinityInteger + const AffinityNumeric + const AffinityReal + const AffinityText + func ResolveColumnAffinity(typeStr string) ColumnAffinity + type ColumnConstraint struct + Collate string + Name string + RefCols []string + RefTable string + Type ConstraintType + Value Expr + type ColumnDef struct + Affinity ColumnAffinity + Default *Value + IsPrimaryKey bool + IsRowID bool + Name string + NotNull bool + Type string + type ColumnDefAST struct + Constraints []ColumnConstraint + Name string + Type string + type ColumnRef struct + Column string + Table string + func CollectColumnRefs(expr Expr) []ColumnRef + func (e ColumnRef) String() string + type CommitStmt struct + type CompareResult int + const CompareEqual + const CompareGreater + const CompareLess + func CompareValues(a, b Value) CompareResult + type CompoundSelect struct + Left Statement + Limit Expr + Offset Expr + Op SetOp + OrderBy []OrderItem + Right Statement + type ConstraintType int + const ConstraintCheck + const ConstraintDefault + const ConstraintForeignKey + const ConstraintNotNull + const ConstraintPrimaryKey + const ConstraintUnique + type CreateIndexStmt struct + Columns []IndexedColumn + IfNotExists bool + Name string + Table string + Unique bool + Where Expr + type CreateTableStmt struct + Columns []ColumnDefAST + IfNotExists bool + Name string + type CreateViewStmt struct + As Statement + Name string + SQL string + type CursorInterface interface + Close func() error + Get func() (int64, *Record, error) + Next func() bool + RawRecordData func() []byte + type DataType int + const DataTypeBlob + const DataTypeFloat + const DataTypeInteger + const DataTypeNull + const DataTypeText + type DatabaseHeader struct + ApplicationID uint32 + DatabaseSizePages uint32 + DefaultPageCacheSize uint32 + FileChangeCounter uint32 + FileFormatReadVersion uint8 + FileFormatWriteVersion uint8 + FirstFreelistTrunkPage uint32 + IncrementalVacuum uint32 + LargestRootBTreePage uint32 + LeafPayloadFrac uint8 + Magic [16]byte + MaxEmbeddedPayloadFrac uint8 + MinEmbeddedPayloadFrac uint8 + PageSize int + ReservedExpansion [20]byte + ReservedSpace uint8 + SQLiteVersionNumber uint32 + SchemaCookie uint32 + SchemaFormatNumber uint32 + TextEncoding uint32 + TotalFreelistPages uint32 + UserVersion uint32 + VersionValidFor uint32 + func ReadHeader(data []byte) (*DatabaseHeader, error) + type DeleteStmt struct + Table TableRef + Where Expr + type DiskFile struct + func OpenDiskFile(path string) (*DiskFile, error) + func (d *DiskFile) Close() error + func (d *DiskFile) Len() int64 + func (d *DiskFile) ReadAt(p []byte, off int64) (int, error) + func (d *DiskFile) Sync() error + func (d *DiskFile) Truncate(size int64) error + func (d *DiskFile) WriteAt(p []byte, off int64) (int, error) + type DropIndexStmt struct + IfExists bool + Name string + type DropTableStmt struct + IfExists bool + Name string + type DropViewStmt struct + IfExists bool + Name string + type Engine struct + func NewEngine(pager PagerInterface, btree BTreeInterface) *Engine + func RawEngine() (*Engine, error) + func (e *Engine) Close() error + func (e *Engine) Execute(sql string, params ...Value) (*Result, error) + func (e *Engine) ExecuteAll(sql string, params ...Value) ([]*Result, error) + func (e *Engine) ExecuteStatement(stmt Statement, params ...Value) (*Result, error) + func (e *Engine) ExecuteWithCache(sql string, params ...Value) (*Result, error) + func (e *Engine) LoadSchema() error + func (e *Engine) SaveSchema() error + func (e *Engine) Schema() *Schema + type Expr interface + type ExprEval struct + ColumnMap map[string]int + Engine *Engine + Params []Value + Row []Value + TableMap map[string]map[string]int + func NewExprEval(row []Value) *ExprEval + func (e *ExprEval) Eval(expr Expr) (Value, error) + func (e *ExprEval) EvalAggregateAware(expr Expr, outputCols []outCol, aggRow []Value, groupRows [][]Value) (Value, error) + type FileBackend interface + Close func() error + Len func() int64 + ReadAt func(p []byte, off int64) (int, error) + Sync func() error + Truncate func(size int64) error + WriteAt func(p []byte, off int64) (int, error) + type ForeignKeyInfo struct + FromCol int + ToCols []string + ToTable string + type FreelistTrunk struct + LeafPages []uint32 + NextTrunkPage uint32 + func ReadFreelistTrunk(data []byte, usableSize int) (*FreelistTrunk, error) + type FromClause struct + Joins []JoinClause + Table *TableRef + type FunctionCall struct + Args []Expr + Distinct bool + Name string + Star bool + func (e FunctionCall) String() string + type InExpr struct + Expr Expr + Negate bool + Select *SelectStmt + Values []Expr + func (e InExpr) String() string + type IndexInfo struct + Columns []string + Name string + RootPage int + SQL string + TableName string + Unique bool + Where string + type IndexedColumn struct + Collate string + Desc bool + Name string + type InsertStmt struct + Columns []string + Select *SelectStmt + Table TableRef + Values [][]Expr + type IsNullExpr struct + Expr Expr + Negate bool + func (e IsNullExpr) String() string + type JoinClause struct + On Expr + Table TableRef + Type JoinType + Using []string + type JoinType int + const JoinCross + const JoinFull + const JoinInner + const JoinLeft + const JoinRight + type Lexer struct + func NewLexer(input string) *Lexer + func (l *Lexer) Next() Token + func (l *Lexer) Tokenize() ([]Token, error) + type LikeExpr struct + Escape Expr + Expr Expr + Negate bool + Op LikeOp + Pattern Expr + func (e LikeExpr) String() string + type LikeOp int + const LikeGlob + const LikeLike + type LiteralExpr struct + BlobVal []byte + FloatVal float64 + IntVal int64 + TextVal string + Type DataType + func (e LiteralExpr) String() string + type MemFile struct + func NewMemFile() *MemFile + func (m *MemFile) Bytes() []byte + func (m *MemFile) Close() error + func (m *MemFile) Len() int64 + func (m *MemFile) ReadAt(p []byte, off int64) (int, error) + func (m *MemFile) Sync() error + func (m *MemFile) Truncate(size int64) error + func (m *MemFile) WriteAt(p []byte, off int64) (int, error) + type OrderItem struct + Desc bool + Expr Expr + type PageHeader struct + CellCount uint16 + ContentOffset uint16 + FirstFreeblock uint16 + FragmentedBytes uint8 + PageType byte + RightMostPtr uint32 + func ReadPageHeader(data []byte, isFirst bool) (*PageHeader, error) + func ReadPageHeaderFrom(data []byte) PageHeader + func (h *PageHeader) HeaderSize() int + type Pager struct + func NewPager(file FileBackend, pageSize int) (*Pager, error) + func (p *Pager) AllocatePage() (int, error) + func (p *Pager) BeginTxn() + func (p *Pager) Close() error + func (p *Pager) CommitTxn() + func (p *Pager) Flush() error + func (p *Pager) GetHeader() *DatabaseHeader + func (p *Pager) GetPageBuffer() []byte + func (p *Pager) GetPageData(num int) ([]byte, error) + func (p *Pager) GetPageDataMutable(num int) ([]byte, error) + func (p *Pager) GetPageDataReadOnly(num int) ([]byte, error) + func (p *Pager) GetPageSize() int + func (p *Pager) GetSchemaPage() int + func (p *Pager) InitNew() error + func (p *Pager) LoadHeader() error + func (p *Pager) PageCount() int + func (p *Pager) PageHeaderOffset(pageNum int) int + func (p *Pager) PutPageBuffer(b []byte) + func (p *Pager) Restore(data []byte) error + func (p *Pager) RollbackTxn() error + func (p *Pager) SetPageData(num int, data []byte) error + func (p *Pager) SetSchemaPage(page int) + func (p *Pager) Snapshot() []byte + func (p *Pager) UpdateHeader(h *DatabaseHeader) error + type PagerInterface interface + AllocatePage func() (int, error) + BeginTxn func() + Close func() error + CommitTxn func() + Flush func() error + GetPageData func(num int) ([]byte, error) + GetPageDataMutable func(num int) ([]byte, error) + GetPageSize func() int + GetSchemaPage func() int + PageCount func() int + Restore func([]byte) error + RollbackTxn func() error + SetPageData func(num int, data []byte) error + SetSchemaPage func(page int) + Snapshot func() []byte + type ParamExpr struct + Index int + Name string + func (e ParamExpr) String() string + type ParenExpr struct + Expr Expr + func (e ParenExpr) String() string + type ParseError struct + Col int + Line int + Msg string + func (e *ParseError) Error() string + type Parser struct + func NewParser(sql string) *Parser + func (p *Parser) Parse() (Statement, error) + func (p *Parser) ParseAll() ([]Statement, error) + type PragmaStmt struct + Name string + Value Expr + type Record struct + Columns []Value + func GetRecord() *Record + func ReadRecord(data []byte) (*Record, error) + func ReadRecordInto(data []byte, buf []Value) (*Record, error) + type ReindexStmt struct + TableName string + type Result struct + Columns []string + LastInsertID int64 + Rows [][]Value + RowsAffected int64 + type RollbackStmt struct + type RowIDExpr struct + func (e RowIDExpr) String() string + type Schema struct + func NewSchema() *Schema + func (s *Schema) AddIndex(info *IndexInfo) + func (s *Schema) AddTable(info *TableInfo) + func (s *Schema) Copy() *Schema + func (s *Schema) DropIndex(name string) bool + func (s *Schema) DropTable(name string) bool + func (s *Schema) GetIndex(name string) (*IndexInfo, bool) + func (s *Schema) GetTable(name string) (*TableInfo, bool) + func (s *Schema) IndexNames() []string + func (s *Schema) IndexesForTable(tableName string) []*IndexInfo + func (s *Schema) RenameTable(oldName, newName string) bool + func (s *Schema) TableNames() []string + type SelectColumn struct + As string + Expr Expr + type SelectStmt struct + Columns []SelectColumn + Distinct bool + From *FromClause + GroupBy []Expr + Having Expr + Limit Expr + Offset Expr + OrderBy []OrderItem + Where Expr + type SetClause struct + Column string + Expr Expr + type SetOp int + const SetOpExcept + const SetOpIntersect + const SetOpUnion + const SetOpUnionAll + type StarColumn struct + func (e StarColumn) String() string + type Statement interface + type SubqueryExpr struct + Select *SelectStmt + type TableInfo struct + AutoInc int64 + Columns []ColumnDef + ForeignKeys []ForeignKeyInfo + Name string + PrimaryKey int + RootPage int + SQL string + func BuildTableInfo(stmt *CreateTableStmt, rootPage int) *TableInfo + func (t *TableInfo) ColumnByName(name string) (ColumnDef, bool) + func (t *TableInfo) ColumnIndex(name string) int + func (t *TableInfo) HasRowIDAlias() bool + func (t *TableInfo) NextAutoIncrement() int64 + func (t *TableInfo) RowIDAliasColumn() string + func (t *TableInfo) SetAutoIncrement(v int64) + type TableRef struct + As string + Name string + Schema string + type Token struct + Col int + Line int + Pos int + Type TokenType + Value string + func (t Token) String() string + type TokenType int + const TokenADD + const TokenALL + const TokenALTER + const TokenAND + const TokenAS + const TokenASC + const TokenAUTOINCREMENT + const TokenAnd + const TokenBEGIN + const TokenBETWEEN + const TokenBLOB_KW + const TokenBY + const TokenBlob + const TokenCASE + const TokenCAST + const TokenCHECK + const TokenCOLLATE + const TokenCOLUMN + const TokenCOMMIT + const TokenCREATE + const TokenComma + const TokenConcat + const TokenDEFAULT + const TokenDELETE + const TokenDESC + const TokenDISTINCT + const TokenDROP + const TokenDot + const TokenDoubleEqual + const TokenELSE + const TokenEND + const TokenEOF + const TokenEXCEPT + const TokenEXISTS + const TokenEqual + const TokenError + const TokenFOREIGN + const TokenFROM + const TokenFloat + const TokenGLOB + const TokenGROUP + const TokenGreater + const TokenGreaterEq + const TokenHAVING + const TokenIF + const TokenIN + const TokenINDEX + const TokenINNER + const TokenINSERT + const TokenINTEGER_KW + const TokenINTERSECT + const TokenINTO + const TokenIS + const TokenIdent + const TokenInteger + const TokenJOIN + const TokenKEY + const TokenLEFT + const TokenLIKE + const TokenLIMIT + const TokenLParen + const TokenLess + const TokenLessEq + const TokenMinus + const TokenNOT + const TokenNULL + const TokenNot + const TokenNotEqual + const TokenOFFSET + const TokenON + const TokenOR + const TokenORDER + const TokenOUTER + const TokenOr + const TokenPRAGMA + const TokenPRIMARY + const TokenPercent + const TokenPlus + const TokenQuestion + const TokenQuotedID + const TokenREAL_KW + const TokenREFERENCES + const TokenREINDEX + const TokenRENAME + const TokenRIGHT + const TokenROLLBACK + const TokenROWID + const TokenRParen + const TokenSELECT + const TokenSET + const TokenSemicolon + const TokenSlash + const TokenStar + const TokenString + const TokenTABLE + const TokenTEXT_KW + const TokenTHEN + const TokenTO + const TokenTRANSACTION + const TokenTilde + const TokenUNION + const TokenUNIQUE + const TokenUPDATE + const TokenVACUUM + const TokenVALUES + const TokenVIEW + const TokenWHEN + const TokenWHERE + type UnaryExpr struct + Expr Expr + Op UnaryOp + func (e UnaryExpr) String() string + type UnaryOp int + const OpBitNot + const OpNegate + const OpNot + type UpdateStmt struct + Sets []SetClause + Table TableRef + Where Expr + type VacuumStmt struct + type Value struct + BlobVal []byte + FloatVal float64 + IntVal int64 + TextVal string + Type DataType + func ApplyAffinity(v Value, affinity ColumnAffinity) Value + func BlobValue(v []byte) Value + func DecodeRecordColumn(data []byte, colIdx int) (Value, error) + func FloatValue(v float64) Value + func IntegerValue(v int64) Value + func TextValue(v string) Value + func (v Value) AsFloat64() (float64, bool) + func (v Value) AsInt64() (int64, bool) + func (v Value) AsText() string + func (v Value) IsNull() bool + func (v Value) String() string + type ViewInfo struct + As Statement + Name string + SQL string v0.2.2 Jun 1, 2026 v0.2.1 Jun 1, 2026 v0.2.0 Jun 1, 2026
Go to main page