Personalized Search: Joining Per-User State Onto Shared Results
Keep catalog search and personal data on different query paths, and join them by ID after the fact instead of in the database.
menugoats
Autocomplete: Typo Tolerance with Postgres Trigrams
Trigram indexing in Postgres makes autocomplete tolerate typos, partial words, and mid-name matches — fast, and with no separate search engine.