Algolia

Promptfree, for everyone, and the only version there is

Open the prompt in Claude CodeOpen the prompt in CodexOpen the prompt in Cursor

Copy

Do not rebuild Algolia. Add real search to my app, and make the ceiling a number rather than a feeling.

STACK
- SQLite FTS5 through better-sqlite3 to start
- Typesense in a container only once the benchmark below says so

THE INDEX
- An FTS5 virtual table over the searchable columns with a porter tokenizer
- Kept in sync by triggers, so an insert or update can never leave it stale
- A rebuild command that recreates it from the source tables in one transaction

RANKING
- bm25() with per-column weights: a title match must outrank a body match
- A recency or popularity boost applied as a multiplier, not as a sort key
- Ties broken deterministically, so the same query never reorders between runs

TYPOS
- FTS5 will not forgive a misspelling; add a trigram second pass, run only when the primary query returns too few rows
- Document the threshold that triggers it

RESULTS
- Highlighted snippets with snippet(), and faceted counts by category computed in the same query
- /api/search with a hard result cap, a query-length limit and a per-IP rate limit

THE CEILING
- A benchmark loading 100,000 rows and printing p50 and p95 latency
- Write the number in the README at which you should stop and move to a real engine

Include a README with that number, the trigger for the trigram pass and the rebuild command.