pg_textsearch
PostgreSQL extension for BM25 relevance-ranked full-text search
Visit tigerdata.com ↗What is pg_textsearch?
pg_textsearch is a PostgreSQL extension that adds modern ranked text search capabilities to Postgres using BM25 ranking. It supports simple query syntax, configurable ranking parameters, fast top-k queries with Block-Max WAND, and parallel index builds. The extension is designed for developers building search features directly in PostgreSQL without external dependencies.
The project is open-source under the PostgreSQL license and available on Tiger Data cloud. According to the creator, it was developed using Claude Code and Claude Opus, demonstrating how AI-assisted development accelerated the typical 6-12 month timeline to completion in approximately two quarters.
Momentum
Daily activity over the last 30 days: upvotes, unique visits, new GitHub stars and Hacker News points.
How do we know it's vibe coded?
vibetrend discovered pg_textsearch automatically. Evidence: HN post: "with the latest tools (Claude Code + Opus) and an experienced hand"; repo has AGENTS.md, CLAUDE.md. View source.
Similar vibe-coded apps
#1 this weekOpen-source local voice cloning, dubbing, transcription, and audiobook creation
#2 this week
#5 this weekSlash commands and agents for engineers using AI without compromising standards
#6 this week523 free lessons building AI systems from math and first principles
#7 this weekOpen-source design workspace that turns coding agents into a local design engine
#8 this week
#10 this weekAI-powered design intelligence toolkit for building professional interfaces

Free, open-source video editor with auto-captions, effects, and 4K export