go-sqlite

February 16, 2026 · View on GitHub

Note

This README was generated by SKILL, get the ZH version from here.

go-sqlite

A Go SQLite library built on read-write separation architecture, simplifying database access through a chainable API and automatic struct binding

Features
Architecture
File Structure
License
Author
Stars

Features

go get github.com/pardnchiu/go-sqlite · Documentation

Read-Write Separated Connection Pool

Initialization automatically creates dedicated read and write connections. The write side is restricted to a single connection with WAL mode and immediate transaction locks, preventing write conflicts at the root. The read side exposes a configurable connection pool, maintaining stable query throughput under high concurrency. A background goroutine periodically performs WAL checkpoints to prevent unbounded database file growth.

Chainable Query Builder

All query operations are chained through the Builder pattern, supporting Where, OrWhere, Having, Join, GroupBy, OrderBy, Limit, Offset and other complete SQL clauses. All column and table names undergo regex validation and SQL reserved word checks. Parameters are always bound via prepared statements, blocking SQL injection at the syntax level.

Automatic Struct Binding

Query results can be mapped directly to Go structs or slices via the Bind() method, using db tags for column name matching. Passing a struct pointer automatically appends LIMIT 1, while passing a slice pointer scans all result rows. Developers no longer need to manually handle rows.Scan and column mapping logic.

Architecture

graph LR
    A[Application] --> B[New]
    B --> C[Write Builder]
    B --> D[Read Builder]
    C -->|Single Conn + WAL| E[(SQLite)]
    D -->|Conn Pool + Read-Only| E
    F[WAL Checkpoint] -.->|Every 30s| E

File Structure

go-sqlite/
├── instance.go              # Entry point, creates read-write connections
├── core/
│   ├── interface.go         # Type definitions (Config, Builder, Connector)
│   ├── builder.go           # Builder core: Create, Delete, Raw
│   ├── connector.go         # Connector: Query, Exec, Close
│   ├── select.go            # SELECT queries and Bind mapping
│   ├── select_ext.go        # First, Last, Count
│   ├── select_where.go      # Where clause methods
│   ├── select_or_where.go   # OrWhere clause methods
│   ├── select_having.go     # Having clause methods
│   ├── select_or_having.go  # OrHaving clause methods
│   ├── insert.go            # Insert, InsertBatch, Conflict
│   ├── update.go            # Update, Increase, Decrease, Toggle
│   └── utils.go             # Column validation and SQL keyword checks
├── go.mod
└── LICENSE