How to Fix FULLTEXT Not Using Your Index
Wrong query shape can bypass FULLTEXT entirely.

"Full-Text Search in SQLite: A Practical Guide"
> #FullText Search (FTS) in #SQLite is a powerful feature that enables efficient searching through large amounts of text data. Unlike traditional SQL LIKE queries that perform linear scans, #FTS uses sophisticated indexing techniques to deliver lightning-fast search results with ranking capabilities.
Full-Text Search (FTS) in SQLite is a powerful feature that enables efficient searching through large amounts of text data. Unlike traditional SQL LIKE queries that perform linear scans, FTS uses sophisticated indexing techniques to deliver lightning-fast search results with ranking capabilities.
"MiniSearch, a client-side full-text search engine"
by @lucaong
> This blog post is to introduce #MiniSearch, a #JavaScript library that provides client-side #FullText #search capabilities. It has zero runtime dependencies, and uses a space optimized index to support memory constrained environments like mobile browsers.
This blog post is to introduce MiniSearch, a JavaScript library that provides client-side full-text search capabilities. It has zero runtime dependencies, and uses a space optimized index to support memory constrained environments like mobile browsers.
Быстрый алгоритм fulltext-поиска без токенизации
Меня зовут Дмитрий Ольшанский, я ведущий инженер Т-Банка. Расскажу о новом (насколько мне известно) алгоритме поиска текста по шаблону. Такая задача возникла в рамках проекта Sage — observability-платформы от Т-Банка, для которой мы строим новый бэкэнд для структурированных логов, SageDB.
Extension for full-text browser history search
https://rearview-ai.vercel.app/
#HackerNews #Extension #fulltext #browser #history #search #RearviewAI #productivity
is:articlelang:, domain:, before:, and after:, and some oddballs like is:bot (would require extra join) and sort: (would break ID-based paging)tsvector column that concatenates (with record separators? as an array?) the contents of filterableFields for a status, updates it every time the status or its attachments are edited, and GIN-indexes that columnILIKE that vanilla GTS usesedit: fixed a backwards flag in has:media and related operators