Apr 2 · 10 min read · Every application eventually needs search. At first, a few WHERE LIKE queries get the job done. But as your data grows and your users expect instant, typo-tolerant, relevant results, those SQL queries
Join discussion
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 discussionFeb 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 discussionDec 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 discussionOct 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 discussionApr 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 discussionApr 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
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
