5-fts5

Overview ¶

Command spike5 proves that ncruces/go-sqlite3 can run Filiation's real schema, including FTS5.

Spike 5 of docs/ARCHITECTURE_PHASE1.md §9. ADR-007 chose this driver for one reason — a WASM build of SQLite means no cgo, which means one static binary per platform — and flagged FTS5 availability as the open risk. M3 keyword search depends on it entirely. If FTS5 is missing, the options are an external index or a custom SQLite build, and that is worth knowing now.

This deliberately applies internal/store's actual schema.sql rather than a toy table, so it also tests the triggers, the partial index and the PRAGMAs that the store package will rely on.

Usage:

go run ./spikes/5-fts5