# FTS5 Projects at AI Tinkerers

> Canonical HTML: https://aitinkerers.org/technologies/fts5
> Markdown URL: https://aitinkerers.org/technologies/fts5.md
> Technology record last updated: 2026-09-18T15:13:58Z
> Generated: 2026-09-22T09:50:21Z

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.

- Official technology site: https://www.sqlite.org/fts5.html
- Public AI Tinkerers demos and talks: 2
- Result page: 1 of 1

## Recent Public Talks and Demos

### [ThreadHop: local-first context sharing across coding agent sessions](https://montreal.aitinkerers.org/talks/rsvp_72wf-elK3uc)

ThreadHop is a local TUI and CLI app that turns isolated coding-agent sessions into a connected workspace with a chat history view, cross-session Full Text Search (FTS5), a kanban board for session tagging, automatically extracted decisions and TODOs, bookmarks, and compressed handoffs. In this demo, I want to show how conversation history can be reused instead of ignored. ThreadHop indexes local transcripts, lets you organize chats on a kanban board with simple states like backlog, in progress, in review, and done, and makes it easy to bring the right context into a new session — whether that is a bookmarked turn, the open TODOs and decisions a background observer has already pulled out, or a full handoff through the /threadhop:handoff skill that packages decisions, TODOs, ADRs, and cross-session conflicts so work can carry forward. The goal is to make multi-agent coding feel like one continuous workspace rather than a pile of disconnected chats.

- Event context: AI Tinkerers Montreal - April Demo Night — 2026-04-22 — Montreal
- Public talk page: https://montreal.aitinkerers.org/talks/rsvp_72wf-elK3uc

### [Soul, Memory, Skills, Brain: Building a Zero-PII Personal AI Agent in Docker](https://austin.aitinkerers.org/talks/rsvp_11W1r8whPMs)

Rent-An-Agent.AI is a self-hostable personal AI agent platform where each agent is a four-layer artifact — Soul (persona in SOUL.md), Memory (SQLite+FTS5 with daemon-thread fact extraction), Skills (52 marketplace skills exposed through an OpenAI-compatible bridge API), and Brain (user-configurable LLM: DeepSeek, Ollama, Claude). It runs on a Mac Mini in Austin, ships as Docker containers on GitHub, exposes itself via Cloudflare Tunnel, and uses a 48-character hex token as the only identity — no email, no password, no PII. Live demo: provision a fresh agent in 10 seconds with persona picker, have a conversation, show the daemon thread silently extracting facts into SQLite, rewrite the Soul mid-conversation („Luna, sei ab jetzt formeller"), fire a marketplace skill call through the Bridge, and settle a tier upgrade with a real BOLT11 Lightning invoice via the Alby webhook.

- Event context: AI Tinkerers Austin: April 2026 Demo Night — 2026-04-16 — Austin
- Public talk page: https://austin.aitinkerers.org/talks/rsvp_11W1r8whPMs

## Related Technologies

- [Python](https://aitinkerers.org/technologies/python) ([Markdown](https://aitinkerers.org/technologies/python.md)) — 662 public demos
- [SQLite](https://aitinkerers.org/technologies/sqlite) ([Markdown](https://aitinkerers.org/technologies/sqlite.md)) — 28 public demos
- [CLI](https://aitinkerers.org/technologies/cli) ([Markdown](https://aitinkerers.org/technologies/cli.md)) — 9 public demos
- [Cloudflare Tunnel](https://aitinkerers.org/technologies/cloudflare-tunnel) ([Markdown](https://aitinkerers.org/technologies/cloudflare-tunnel.md)) — 1 public demo
- [DeepSeek Chat & Reasoner](https://aitinkerers.org/technologies/deepseek-chat-reasoner) ([Markdown](https://aitinkerers.org/technologies/deepseek-chat-reasoner.md)) — 1 public demo
- [Docker](https://aitinkerers.org/technologies/docker) ([Markdown](https://aitinkerers.org/technologies/docker.md)) — 147 public demos
- [SQLite FTS5](https://aitinkerers.org/technologies/sqlite-fts5) ([Markdown](https://aitinkerers.org/technologies/sqlite-fts5.md)) — 3 public demos
- [Textual](https://aitinkerers.org/technologies/textual) ([Markdown](https://aitinkerers.org/technologies/textual.md)) — 2 public demos
- [TUI](https://aitinkerers.org/technologies/tui) ([Markdown](https://aitinkerers.org/technologies/tui.md)) — 2 public demos
- [Used Python](https://aitinkerers.org/technologies/used-python) ([Markdown](https://aitinkerers.org/technologies/used-python.md)) — 1 public demo