菜单
Use when debugging surprising behaviour with gosqlite, or as a pre-ship checklist — the gotchas around per-conn hooks, the connection pool, vec quirks, bind limits, and what is not supported.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Use when the task needs a SQL function or virtual table from the gosqlite ext/ catalog — regexp, uuid, hash, ipaddr, zorder, stats, unicode, encode, text, fuzzy, decimal, money, time, eval, csv, lines, statement, closure, pivot, rtree, series, array, bloom, spellfix1, fileio, blobio.
Use when the task needs encryption at rest, storing a database compressed at rest, page-checksum corruption detection, an in-memory database with isolation, or serving a database from an embed.FS / byte buffer in a Go app with gosqlite.
Use when using gorm.io/gorm with gosqlite — the gosqlite.org/gorm dialector, a CGo-free drop-in for glebarez/sqlite and gorm.io/driver/sqlite, shipped as its own module.
Use when switching an existing Go project to gosqlite from mattn/go-sqlite3, modernc.org/sqlite, glebarez/sqlite, gorm.io/driver/sqlite, or ncruces/go-sqlite3.
Use when opening a SQLite database in Go with gosqlite.org, choosing the "sqlite" vs "sqlite3" driver name, or deciding which sub-package to reach for. The starting point for any task using this driver.
Use when storing large, growable, or randomly-writable byte objects (files, uploads, streamed content) in SQLite with gosqlite — the blobstore package, plus when to reach for the fixed-size Conn.OpenBlob / ext/blobio instead.
| name | pitfalls |
| description | Use when debugging surprising behaviour with gosqlite, or as a pre-ship checklist — the gotchas around per-conn hooks, the connection pool, vec quirks, bind limits, and what is not supported. |
Conn.Raw, and CREATE VIRTUAL TABLE module registrations live on ONE connection. db.Exec/db.Query may pick any pooled conn, so "install once on db" is fragile. Fix: db.SetMaxOpenConns(1) + db.Conn(ctx) + sc.Raw(...), then drive traffic through sc. For pool-wide function/vtab registration, use the /auto blank-import or Driver.RegisterConnectionHook.:memory: is private per connection. Each pooled conn gets its own empty database. For a shared in-memory DB use sqlite.OpenShared(name) or db.SetMaxOpenConns(1).INSERT OR REPLACE on vec0 — use (*Table).Update.KNN inside a gorm.Transaction is not supported — run it outside the transaction.bit[N] needs N%8==0; int8 quantization needs values in [-1, 1].col || zeroblob(delta) silently truncates. SQLite drops zeroblob operands under || (x'0102' || zeroblob(10) has length 2, not 12); cast/substr don't materialize it either. You cannot grow a value that way — you get a shorter blob and no error. To pre-size, INSERT … VALUES (zeroblob(N)) or UPDATE SET col = zeroblob(N), then write with Conn.OpenBlob / writeblob.Blob (OpenBlob) is fixed-size. WriteAt past Size() errors; growth means re-sizing the row. For an unbounded, growable, randomly-writable byte stream (files, uploads), use gosqlite.org/blobstore instead of hand-rolling chunk tables._auth* DSN flags are rejected — userauth was removed upstream. Remove them when migrating from mattn.go.mod must use the modernc.org/libc version this module pins, or the C ABI drifts; go mod tidy against this module maintains it."sqlite3"); blank-importing both panics at init.(*Stmt).Explain(sqlite.ExplainQueryPlan) flips a prepared statement to EXPLAIN QUERY PLAN mode (bound parameters carry over); ExplainOff flips it back to run normally.Userauth; SQLCipher on-disk format / MAC (encryption is confidentiality-only); cross-process WAL on a custom (non-platform) VFS; beating mattn on hot per-row UDF throughput.
When something behaves unexpectedly, check this list first, then the relevant feature skill, then docs/.