Forem

# search

Search indexing and queries

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Hybrid search with RRF: combining pgvector, tsvector, and a knowledge graph in one query"
Cover image for Hybrid search with RRF: combining pgvector, tsvector, and a knowledge graph in one query"

Hybrid search with RRF: combining pgvector, tsvector, and a knowledge graph in one query"

Comments
9 min read
Stop Guessing on Search Tuning: Using OpenSearch Search Relevance to Improve Results

Stop Guessing on Search Tuning: Using OpenSearch Search Relevance to Improve Results

Comments
6 min read
Building a Search System with SQLite FTS5 and CJK Support

Building a Search System with SQLite FTS5 and CJK Support

Comments
3 min read
Accelerating Solr Search for Global Financial Institutions
Cover image for Accelerating Solr Search for Global Financial Institutions

Accelerating Solr Search for Global Financial Institutions

1
Comments
3 min read
Beyond Keywords: Unpacking Elasticsearch's Inverted Index for Sub-Millisecond Search

Beyond Keywords: Unpacking Elasticsearch's Inverted Index for Sub-Millisecond Search

Comments
7 min read
Building Fast Video Search with SQLite FTS5

Building Fast Video Search with SQLite FTS5

Comments
3 min read
Multi‑Vector Embeddings in Production: Typed Vectors, Cache Keys, and a Generator That Refuses Poison Records

Multi‑Vector Embeddings in Production: Typed Vectors, Cache Keys, and a Generator That Refuses Poison Records

Comments
9 min read
Adding Hybrid Search to Your Application (In Diagrams)

Adding Hybrid Search to Your Application (In Diagrams)

Comments
1 min read
The Backyard Quarry, Part 4: Searching a Pile of Rocks
Cover image for The Backyard Quarry, Part 4: Searching a Pile of Rocks

The Backyard Quarry, Part 4: Searching a Pile of Rocks

1
Comments
4 min read
How I Cut My Google Search Dependence in Half

How I Cut My Google Search Dependence in Half

3
Comments
8 min read
Search Bar in Compose — SearchBar, Filtering & Debounce

Search Bar in Compose — SearchBar, Filtering & Debounce

Comments
2 min read
How We Built AI-Powered Bundle Discovery for Shopify

How We Built AI-Powered Bundle Discovery for Shopify

Comments
2 min read
From 30 Seconds to 3 Milliseconds: Replacing LIKE with FTS5 on 1.7M Patent Records

From 30 Seconds to 3 Milliseconds: Replacing LIKE with FTS5 on 1.7M Patent Records

1
Comments
4 min read
When Gemini Hallucinates Patent Numbers: Fixing the FTS5 + LLM Analysis Pipeline

When Gemini Hallucinates Patent Numbers: Fixing the FTS5 + LLM Analysis Pipeline

Comments
3 min read
How Google Finds Every Restaurant in Japan — And Why Your Full-Text Search Can't

How Google Finds Every Restaurant in Japan — And Why Your Full-Text Search Can't

2
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.