Full-Text Search Tools: Elasticsearch, Meilisearch, Typesense, SQLite FTS5, and PostgreSQL
Mar 3 · 9 min read · Full-Text Search Tools: Elasticsearch, Meilisearch, Typesense, SQLite FTS5, and PostgreSQL Adding search to your application starts with a simple question: do you need a dedicated search engine, or can your existing database handle it? For many appli...
Join discussionPostgreSQL Full-Text Search: tsvector tsquery
Feb 12 · 11 min read · PostgreSQL Full-Text Search: Building Production-Grade Search with tsvector and tsquery Modern applications demand sophisticated search capabilities, yet many teams reflexively reach for Elasticsearch or Algolia before evaluating what their existing ...
Join discussionA Deep Dive into Lucene & Full-Text Search in AEM
Jan 19 · 4 min read · Lucene is what makes full-text search fast, scalable, and production-ready in AEM. If you’ve ever searched for content by keywords, text fragments, or metadata - you’ve used Lucene, whether you realized it or not. In this post, we’ll go one level dee...
Join discussionSQL Server - Full-Text Search
Dec 4, 2025 · 5 min read · While standard indexes (B-Trees) are like the index at the back of a book (sorted lists), Full-Text Indexes are like a search engine (Google/Bing) built inside your database. They are designed to query large amounts of unstructured text. 1. The Probl...
Join discussionBuilding Fast, Relevant Search & Discovery for Game Marketplaces
Oct 17, 2025 · 4 min read · Introduction A game marketplace lives or dies by discovery. If buyers can’t find the right PUBG account, the right CS2 skin, or the best WoW gold offer, no amount of escrow, UX polish, or marketing will help. This article shows a practical, productio...
Join discussionIntroducing Vechord: Turn PostgreSQL into your search engine in a Pythonic way.
Apr 23, 2025 · 4 min read · Today, we're thrilled to announce the release of Vechord, a new Python library designed to dramatically simplify building robust search infrastructure directly on top of the PostgreSQL database. In the rapidly evolving world of AI and large language ...
Join discussionPostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth)
Apr 2, 2025 · 6 min read · You might have come across discussions or blog posts suggesting that PostgreSQL's built-in full-text search (FTS) struggles with performance compared to dedicated search engines or specialized extensions. A notable recent example comes from Neon's bl...
Join discussion
VectorChord-BM25: Introducing pg_tokenizer—A Standalone, Multilingual Tokenizer for Advanced Search
Apr 2, 2025 · 6 min read · We're excited to announce the release of VectorChord-BM25 version 0.2, our PostgreSQL extension designed to bring advanced BM25-based full-text search ranking capabilities directly into your database! VectorChord-BM25 allows you to leverage the power...
Join discussion
VectorChord-BM25: Revolutionize PostgreSQL Search with BM25 Ranking — 3x Faster Than ElasticSearch
Feb 24, 2025 · 12 min read · We’re excited to share something special with you: VectorChord-BM25, a new extension designed to make PostgreSQL’s full-text search even better. Whether you’re building a small app or managing a large-scale system, this tool brings advanced BM25 scor...
Join discussion