Skip to content

Instantly share code, notes, and snippets.

@usutani

usutani/fizzy-fts.md

Created April 30, 2026 07:44
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save usutani/e8a8599ca698fc5939098f09cf6a2d27 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save usutani/e8a8599ca698fc5939098f09cf6a2d27 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fizzy-fts.md
項目 SQLite FTS5 MySQL (Trilogy)
ステミングのタイミング FTS5内部で自動 保存時と検索時の両方
保存されるcontent 元の文章 ステミング済み文章
トークン化 FTS5内部 アプリ側で実施（gsub + split）
ハイライト FTS5の highlight() Rubyの Search::Highlighter
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment