Technology

FTS5

FTS5 is a high-performance SQLite virtual table module designed for lightning-fast full-text indexing and prefix searching.

FTS5 replaces its predecessors (FTS3 and FTS4) with a revamped ranking system using the BM25 algorithm and a more efficient data structure. It handles complex queries across millions of rows with sub-millisecond latency: supporting proximity searches, boolean operators, and custom tokenizers. Developers use it to build robust search features directly within the database layer, eliminating the need for external search engines like Elasticsearch for many applications.

https://www.sqlite.org/fts5.html

What builders pair with FTS5

Projects using both technologies. Select a pairing to see a project.

Built with FTS5

CLI 1 shared project Python 1 shared project SQLite 1 shared project SQLite FTS5 1 shared project SQLite with FTS5 (full-text search with porter stemming) 1 shared project Textual 1 shared project

2 more pairings

TUI 1 shared project Used Python 1 shared project

Pairing: CLI

Photo from the event — Event photo

ThreadHop: local-first context sharing across coding agent sessions

Montreal · April 22, 2026

view project | view CLI

Recent Talks & Demos

Showing 1-1 of 1

Members-Only

Sign in to see who built these projects

Sign in View FAQ

ThreadHop: Agent Context Sharing

Montreal Apr 22