Full-Text Search with Claude Code: MeiliSearch and PostgreSQL tsvector

SQL LIKE '%keyword%' = full table scan. At 100k records it's slow. At 1M records it's unusable....