Full-Text Search taste
# Full-Text Search taste of a search-focused backend engineer - Start with the database's built-in full-text search, such as PostgreSQL tsvector, and add a dedicated search engine only when relevance or scale really…
Open the source (opens github.com) https://github.com/f/prompts.chat
What it is
Prompts from f.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
The prompt
# Full-Text Search taste of a search-focused backend engineer - Start with the database's built-in full-text search, such as PostgreSQL tsvector, and add a dedicated search engine only when relevance or scale really needs it. Confidence: 0.85 - Treat the search index as a derived copy that can be rebuilt at any time from the primary database. Confidence: 0.95 - Keep the index in sync with a change feed, outbox table or queue, never with dual writes from request handlers. Confidence: 0.90 - Write to a new versioned index and switch an alias to it for mapping changes, so reindexing never causes downtime. Confidence: 0.90 - Define explicit field mappings and analyzers instead of relying on dynamic mapping guesses. Confidence: 0.90 - Store exact-match fields like IDs, slugs and statuses as keyword fields, separate from analyzed text fields. Confidence: 0.90 - Pick analyzers per language, with stemming and stop words chosen for that language, instead of one default analyzer for all content. Confidence: 0.80 - Boost title matches above body matches, and tune field weights with real queries rather than intuition alone. Confidence: 0.85 - Use filters for structured conditions like category, date or permissions so they are cached and do not affect scoring. Confidence: 0.85 - Apply access control inside the search query itself, never by filtering results after they come back. Confidence: 0.95 - Add typo tolerance with fuzzy matching only for terms longer than a few characters to avoid noisy results. Confidence: 0.75 - Serve autocomplete from a dedicated edge n-gram or prefix field, not from wildcard queries on the main text field. Confidence: 0.80 - Manage synonyms in a reviewed file or table under version control, not by editing them directly in production. Confidence: 0.75 - Use search_after or cursor pagination for deep result pages instead of large from and size offsets. Confidence: 0.85 - Log every query, its result count and its clicks so zero-result and low-click queries can be fixed. Confidence: 0.90 - Keep a small judged set of queries and expected results, and run it in CI before shipping any relevance change. Confidence: 0.80 - Try hybrid search that combines keyword and vector results only after the keyword baseline is measured. Confidence: 0.70 - Show highlighted snippets and clear facet counts so users understand why a result matched. Confidence: 0.80 - Set timeouts on search requests and fall back to a simpler query or cached results when the cluster is slow. Confidence: 0.80 - Monitor query latency percentiles, indexing lag and index size, and alert when indexing falls behind. Confidence: 0.85 - Never expose the search engine directly to browsers, and always put it behind your own API with rate limits. Confidence: 0.95
Written by the prompts.chat (CC0 prompt collection) community (f). Not tested by InnerVault.
How to get it
Setup steps: not applicable.
Related
-
a lot of people even professional said a software product or platfrom especially which has complex rules which was fully coded by AI by a vibe coder who deosnt understand what is the arcture concept deployed, read and…
-
code-hacker
PromptsCode Hacker - VS Code Custom Agent + Web + TUI
git clone https://github.com/hackerlibs/code-hacker.git -
builder prompts which can be sent to builders like cursor, bolt.diy, bolt.new, trae, project idx, Claude code, lovable.dev, llmacoder, geminicoder, windsurf, deepseek-artifact, cline, aider etc
git clone https://github.com/KingLeoJr/awesome-vibe-coding-prompt-code-templates.git -
Manim Code
PromptsYour task to create a manim code that will explain the chain rule in easy way
-
I’m tired of using Claude Code to build my code because of tokens limits can Ollama build code scripts agentic workflow?
-
Code Recon
Prompts# SYSTEM PROMPT: Code Recon # Author: Scott M. # Goal: Comprehensive structural, logical, and maturity analysis of source code. --- ## 🛠 DOCUMENTATION & META-DATA * **Version:** 2.7 * **Primary AI Engine (Best):**…