القائمة
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/.