메뉴
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.
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 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.
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 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 | using-gosqlite |
| description | 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. |
A CGo-free SQLite driver + ecosystem for Go. Install: go get gosqlite.org. No CGo, no C toolchain.
The driver registers under two names (same singleton): "sqlite" (use for new code) and "sqlite3" (mattn-compat). Three levels of setup:
// 1. Plain database/sql.
import _ "gosqlite.org"
db, _ := sql.Open("sqlite", "file:app.db")
// 2. One-line presets (root pkg embeds *sql.DB).
import sqlite "gosqlite.org"
db, _ := sqlite.OpenWAL("app.db") // WAL + busy_timeout=5s + foreign_keys=on
mem, _ := sqlite.OpenInMemory() // private in-memory
shared, _ := sqlite.OpenShared("name") // shared in-memory (multi-conn tests)
ro, _ := sqlite.OpenReadOnly("seed.db") // refuses to create/write
// 3. Typed Config — pragmas and pool tuning in one value (encryption is via the crypto/vault VFS).
db, _ := sqlite.Open(sqlite.Config{
Path: "app.db",
Pragmas: sqlite.RecommendedPragmas(),
MaxOpenConns: 8,
})
Prefer typed pragma enums (sqlite.JournalWAL, sqlite.SynchronousNormal, …) over string literals. Legacy DSN strings ("file:app.db?_pragma=…&_fk=1") still work.
For an in-memory database that multiple connections must share, use OpenShared(name) or set db.SetMaxOpenConns(1) — a plain :memory: is private per connection.
| Goal | Package | Skill |
|---|---|---|
| ORM | gosqlite.org/gorm | gorm |
| Vector / similarity search | gosqlite.org/vec | vector-search |
| Full-text search | gosqlite.org/fts | full-text-search |
| Combine vec + fts results | gosqlite.org/fusion | hybrid-search |
| Encryption / checksums / in-memory / custom storage | gosqlite.org/vfs/... | encryption-and-vfs, custom-vfs |
| Bound the page-cache heap | gosqlite.org/pcache | (page cache: pcache.InstallBoundedLRU(maxPages) before first open) |
| SQL functions (regexp, uuid, hash, …) | gosqlite.org/ext/<name> | extensions |
| Migrations / savepoints / scalar reads | gosqlite.org/sqlitex | — |
These live on *sqlite.Conn, not *sql.DB. Pin a connection:
db.SetMaxOpenConns(1)
sc, _ := db.Conn(ctx)
sc.Raw(func(dc any) error {
c := dc.(*sqlite.Conn)
return c.RegisterFunc("myfn", func(x int64) int64 { return x*2 }, true)
})
// drive traffic through sc, not db.
Always close: defer db.Close(). Full narrative: docs/. Gotchas before shipping: the pitfalls skill.