메뉴
Use when adding keyword, full-text, or FTS5/BM25 search to a Go app with gosqlite — the typed fts.Index[K, V] API, tokenizers (incl. custom Go tokenizers), query builder, ranking, snippet/highlight.
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 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.
| name | full-text-search |
| description | Use when adding keyword, full-text, or FTS5/BM25 search to a Go app with gosqlite — the typed fts.Index[K, V] API, tokenizers (incl. custom Go tokenizers), query builder, ranking, snippet/highlight. |
import (
_ "gosqlite.org"
"gosqlite.org/fts"
)
idx, _ := fts.New[int64, string](ctx, db, "docs", fts.Options{
Tokenizer: fts.Porter{Base: fts.Unicode61{RemoveDiacritics: 2}},
})
idx.Insert(ctx, fts.Attr[int64, string]{Key: 1, Value: "the quick brown fox"})
matches, _ := idx.SearchSlice(ctx, fts.Term("fox"),
fts.WithRanking(), // BM25
fts.WithSnippet("value", "[", "]", "…", 8))
fts.New[K, V] — K is the row key type, V the stored value type.fts.Porter, fts.Unicode61{RemoveDiacritics: 2}, fts.Trigram. For CJK / stemming / synonyms, register a custom Go tokenizer via (*Conn).RegisterFTS5Tokenizer.fts.Term, fts.And/Or/Not, phrase, NEAR, prefix, column filters — compose in Go, no raw MATCH strings.fts.WithRanking(), fts.WithSnippet(...), fts.WithHighlight(...), fts.WithLimit(n) / WithOffset(n), fts.WithFilter(sql, args...).fts.Options.fts.NewVocab(...) exposes term frequencies + prefix lookups.Tokenizers are applied symmetrically to both the indexed document and the query, so a reversible transform is invisible to MATCH — inspect indexed terms via fts5vocab if a custom tokenizer behaves unexpectedly. Tokens need iStart < iEnd (no zero-width).
For gorm models, use the tag-driven sidecar (fts5:"tokenize=porter+unicode61") — see the gorm skill. To combine with vector search, see hybrid-search. Full reference: docs/guides/full-text-search.md.