tinysql

package module

Go to main page

Versions in this module

v0

v0.5.3

Dec 19, 2025

v0.5.2

Dec 19, 2025

v0.5.1

Dec 18, 2025

v0.5.0

Dec 3, 2025

v0.4.1

Nov 25, 2025

v0.4.0

Nov 25, 2025

v0.3.1

Oct 3, 2025

Changes in this version

+ type FuzzyImportOptions = importer.FuzzyImportOptions

type ImportResult

+ func FuzzyImportCSV(ctx context.Context, db *DB, tenant, tableName string, src io.Reader, ...) (*ImportResult, error)

+ func FuzzyImportJSON(ctx context.Context, db *DB, tenant, tableName string, src io.Reader, ...) (*ImportResult, error)

v0.3.0

Oct 1, 2025

Changes in this version

+ func ToSQL(stmt engine.Statement) string

type DB

+ func OpenFile(ctx context.Context, filePath string, opts *ImportOptions) (*DB, string, error)

+ type DeleteBuilder struct

+ func DeleteFrom(table string) *DeleteBuilder

+ func (db *DeleteBuilder) Build() *engine.Delete

+ func (db *DeleteBuilder) Where(condition ExprBuilder) *DeleteBuilder

+ type ExprBuilder interface

+ Build func() engine.Expr

+ func Add(left, right ExprBuilder) ExprBuilder

+ func And(exprs ...ExprBuilder) ExprBuilder

+ func Avg(expr ExprBuilder) ExprBuilder

+ func Coalesce(exprs ...ExprBuilder) ExprBuilder

+ func Col(name string) ExprBuilder

+ func Concat(exprs ...ExprBuilder) ExprBuilder

+ func Count(expr ExprBuilder) ExprBuilder

+ func CountStar() ExprBuilder

+ func Div(left, right ExprBuilder) ExprBuilder

+ func Eq(left, right ExprBuilder) ExprBuilder

+ func Ge(left, right ExprBuilder) ExprBuilder

+ func Gt(left, right ExprBuilder) ExprBuilder

+ func IsNotNull(expr ExprBuilder) ExprBuilder

+ func IsNull(expr ExprBuilder) ExprBuilder

+ func Le(left, right ExprBuilder) ExprBuilder

+ func Lower(expr ExprBuilder) ExprBuilder

+ func Lt(left, right ExprBuilder) ExprBuilder

+ func MD5(expr ExprBuilder) ExprBuilder

+ func Max(expr ExprBuilder) ExprBuilder

+ func Min(expr ExprBuilder) ExprBuilder

+ func Mul(left, right ExprBuilder) ExprBuilder

+ func Ne(left, right ExprBuilder) ExprBuilder

+ func Not(expr ExprBuilder) ExprBuilder

+ func Null() ExprBuilder

+ func Or(exprs ...ExprBuilder) ExprBuilder

+ func SHA1(expr ExprBuilder) ExprBuilder

+ func SHA256(expr ExprBuilder) ExprBuilder

+ func SHA512(expr ExprBuilder) ExprBuilder

+ func Sub(left, right ExprBuilder) ExprBuilder

+ func Sum(expr ExprBuilder) ExprBuilder

+ func Trim(expr ExprBuilder) ExprBuilder

+ func Upper(expr ExprBuilder) ExprBuilder

+ func Val(value any) ExprBuilder

+ type ImportOptions = importer.ImportOptions

+ type ImportResult = importer.ImportResult

+ func ImportCSV(ctx context.Context, db *DB, tenant, tableName string, src io.Reader, ...) (*ImportResult, error)

+ func ImportFile(ctx context.Context, db *DB, tenant, tableName, filePath string, ...) (*ImportResult, error)

+ func ImportJSON(ctx context.Context, db *DB, tenant, tableName string, src io.Reader, ...) (*ImportResult, error)

+ type InsertBuilder struct

+ func InsertInto(table string) *InsertBuilder

+ func (ib *InsertBuilder) Build() *engine.Insert

+ func (ib *InsertBuilder) Columns(cols ...string) *InsertBuilder

+ func (ib *InsertBuilder) Values(values ...ExprBuilder) *InsertBuilder

+ type SelectBuilder struct

+ func Select(projections ...ExprBuilder) *SelectBuilder

+ func SelectDistinct(projections ...ExprBuilder) *SelectBuilder

+ func SelectStar() *SelectBuilder

+ func With(ctes ...WithQuery) *SelectBuilder

+ func (sb *SelectBuilder) Build() *engine.Select

+ func (sb *SelectBuilder) From(table string) *SelectBuilder

+ func (sb *SelectBuilder) FromAs(table, alias string) *SelectBuilder

+ func (sb *SelectBuilder) GroupBy(columns ...string) *SelectBuilder

+ func (sb *SelectBuilder) GroupByExpr(exprs ...ExprBuilder) *SelectBuilder

+ func (sb *SelectBuilder) Having(condition ExprBuilder) *SelectBuilder

+ func (sb *SelectBuilder) Join(table string, on ExprBuilder) *SelectBuilder

+ func (sb *SelectBuilder) JoinAs(table, alias string, on ExprBuilder) *SelectBuilder

+ func (sb *SelectBuilder) LeftJoin(table string, on ExprBuilder) *SelectBuilder

+ func (sb *SelectBuilder) LeftJoinAs(table, alias string, on ExprBuilder) *SelectBuilder

+ func (sb *SelectBuilder) Limit(n int) *SelectBuilder

+ func (sb *SelectBuilder) Offset(n int) *SelectBuilder

+ func (sb *SelectBuilder) OrderBy(column string) *SelectBuilder

+ func (sb *SelectBuilder) OrderByDesc(column string) *SelectBuilder

+ func (sb *SelectBuilder) Where(condition ExprBuilder) *SelectBuilder

+ type TableBuilder struct

+ func NewTableBuilder(name string) *TableBuilder

+ func (tb *TableBuilder) Bool(name string) *TableBuilder

+ func (tb *TableBuilder) Build() *engine.CreateTable

+ func (tb *TableBuilder) Column(name string, colType ColType) *TableBuilder

+ func (tb *TableBuilder) Create(db *DB, tenant string) error

+ func (tb *TableBuilder) Float(name string) *TableBuilder

+ func (tb *TableBuilder) Int(name string) *TableBuilder

+ func (tb *TableBuilder) JSON(name string) *TableBuilder

+ func (tb *TableBuilder) Temp() *TableBuilder

+ func (tb *TableBuilder) Text(name string) *TableBuilder

+ func (tb *TableBuilder) Timestamp(name string) *TableBuilder

+ type UpdateBuilder struct

+ func Update(table string) *UpdateBuilder

+ func (ub *UpdateBuilder) Build() *engine.Update

+ func (ub *UpdateBuilder) Set(column string, value ExprBuilder) *UpdateBuilder

+ func (ub *UpdateBuilder) Where(condition ExprBuilder) *UpdateBuilder

+ type WithQuery struct

+ Name string

+ Query *SelectBuilder

v0.2.1

Oct 1, 2025

Changes in this version

+ const TxStatusAborted

+ const TxStatusCommitted

+ const TxStatusInProgress

+ const WALOpAbort

+ const WALOpBegin

+ const WALOpCheckpoint

+ const WALOpCommit

+ const WALOpDelete

+ const WALOpInsert

+ const WALOpUpdate

+ type AdvancedWAL = storage.AdvancedWAL

+ func NewAdvancedWAL(path string) (*AdvancedWAL, error)

+ func OpenAdvancedWAL(config AdvancedWALConfig) (*AdvancedWAL, error)

+ type AdvancedWALConfig = storage.AdvancedWALConfig

+ type ColType = storage.ColType

+ const BoolType

+ const DateTimeType

+ const DateType

+ const Float32Type

+ const Float64Type

+ const FloatType

+ const Int16Type

+ const Int32Type

+ const Int64Type

+ const Int8Type

+ const IntType

+ const JsonType

+ const JsonbType

+ const StringType

+ const TextType

+ const TimeType

+ const TimestampType

+ const Uint8Type

+ const UintType

+ type Column = storage.Column

+ type CompiledQuery = engine.CompiledQuery

+ type DB = storage.DB

+ type IsolationLevel = storage.IsolationLevel

+ const ReadCommitted

+ const RepeatableRead

+ const Serializable

+ const SnapshotIsolation

+ type LSN = storage.LSN

+ type MVCCManager = storage.MVCCManager

+ type Parser = engine.Parser

+ type QueryCache = engine.QueryCache

+ type ResultSet = engine.ResultSet

+ type Row = engine.Row

+ type Statement = engine.Statement

+ func MustParseSQL(sql string) Statement

+ func ParseSQL(sql string) (Statement, error)

+ type Table = storage.Table

+ func NewTable(name string, cols []Column, isTemp bool) *Table

+ type Timestamp = storage.Timestamp

+ type TxContext = storage.TxContext

+ type TxID = storage.TxID

+ type TxStatus = storage.TxStatus

+ type WALOperationType = storage.WALOperationType

+ type WALRecord = storage.WALRecord

v0.2.0

Oct 1, 2025

Changes in this version

+ func Compile(cache *engine.QueryCache, sql string) (*engine.CompiledQuery, error)

+ func Execute(ctx context.Context, db *storage.DB, tenant string, stmt engine.Statement) (*engine.ResultSet, error)

+ func ExecuteCompiled(ctx context.Context, db *storage.DB, tenant string, ...) (*engine.ResultSet, error)

+ func GetVal(row engine.Row, name string) (any, bool)

+ func LoadFromFile(filename string) (*storage.DB, error)

+ func MustCompile(cache *engine.QueryCache, sql string) *engine.CompiledQuery

+ func NewDB() *storage.DB

+ func NewParser(sql string) *engine.Parser

+ func NewQueryCache(maxSize int) *engine.QueryCache

+ func SaveToFile(db *storage.DB, filename string) error

v0.1.3

Sep 29, 2025

v0.1.2

Sep 27, 2025

v0.1.1

Sep 27, 2025

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