So... Postgres is now basically a search engine? (And it's free)

youtube

🚀 Use Postgres for Free: pg_textsearch was just open sourced. It enables BM25 to search your database.... massive upgrade for keyword search. Google uses BM25 in their search engine. Now you can too. Claude told me: "if you're already on Postgres, you can now skip the whole sync-your-data-to-Elasticsearch dance for search." (ps, how can you not love Claude). This video is all about implementing your own pg_textsearch _and_ vector search for powerful hybrid searches. 🆇 pg_textsearch went viral: ✅ Blog post: 🖥️ Code: 🖥️ pg_textsearch: 00:00:00 Welcome 00:01:00 Search Engine Bot with Python, Postgres & pg_textsearch 00:04:08 AI Agent to Build a Command Line Tool with Python 00:16:04 Storing Basic Data 00:20:32 Web Scraping to Markdown 00:25:56 Scraping with a Web Browser 00:35:53 Adding New Features 00:38:40 Fixing Code Errors with Claude 00:39:35 Create a Claude Project 00:42:08 Get Interviewed by AI Agents 00:46:02 Tracking File Changes with GitHub 00:49:44 Start building from AI Agent Interview Spec 00:54:02 Postgres on Tiger Data Cloud with pg_textsearch 01:01:42 Postgres MCP with pg-aiguide 01:13:44 Add Links, Crawl and Search 01:25:07 Vector Search 01:33:16 Hybrid Search 01:43:04 Adding a Web App 01:51:39 Reviewing the UI 01:58:12 Creating a Search Engine MCP 02:04:58 Modify CLI to run the MCP Server 02:10:49 Using the MCP Server in LLMs 02:18:41 Using our MCP in Claude Desktop 02:22:10 Thank you