Loading video...

Video Failed to Load

Go Home

You may have noticed that search on the Visual Studio Code website has gotten a lot quicker lately. In our latest blogpost, João Moreno breaks down the engineering process behind docfind, a search engine we built that runs entirely in your browser using WebAssembly:

73,479 views • 6 months ago •via X (Twitter)

0 Comments

No comments available

Comments from the original post will appear here

Related Videos

Big moment for Postgres! Search has always been Postgres' weak spot, and everyone just accepted it. If you needed a real relevance-ranked keyword search, the default answer was to spin up Elasticsearch or add Algolia and deal with the data sync headaches forever. The problem isn't that Postgres can't do text search. It can. But the built-in `ts_rank` function uses a basic term frequency algorithm that doesn't come close to what modern search engines deliver. So teams end up: - Running a separate Elasticsearch cluster just for search - Building sync pipelines that inevitably drift out of consistency - Paying for managed search services that charge per query - Accepting mediocre search relevance because "good enough" ships faster But this is actually a solvable problem. You can realistically bring industry-standard search ranking directly into Postgres, which eliminates the need for external infra entirely. This exact solution is now available with the newly open-sourced pg_textsearch by Tiger Data - Creators of TimescaleDB, a Postgres extension that brings true BM25 relevance ranking into the database. BM25 is the algorithm behind Elasticsearch, Lucene, and most modern search engines. Now it runs natively in Postgres. Here's what pg_textsearch enables: - True BM25 ranking with configurable parameters (the same algorithm powering production search systems) - Simple SQL syntax: `ORDER BY content 'search terms'` - Works with Postgres text search configurations for multiple languages - Pairs naturally with pgvector for hybrid keyword + semantic search That last point matters a lot for RAG apps. The video below shows this in action, and I worked with the team to put this together. You can now do hybrid retrieval (combining keyword matching with vector similarity) in a single database, without stitching together multiple systems. The syntax is clean enough that you can add relevance-ranked search to existing queries in minutes. pg_textsearch is fully open-source under the PostgreSQL license. You can find a link to their GitHub repo in the next tweet.

Akshay 🚀

215,344 views • 6 months ago

I built a content engine that runs on telegram. Two commands... /discover: sends out to 9 sources across HackerNews, Reddit communities covering AI automation, prompt engineering, vibe coding, and specialist newsletters. Pulls everything published in the last 24 hours, runs each item through an AI extraction layer that scores it against 100+ niche keywords, deduplicates, and drops the relevant ideas into a Notion database. Takes about 90 seconds. Costs fractions of a cent. /ideas: this command pulls the top scored ideas from that database, randomizes the selection so you're not seeing the same ones every time, and sends them to you in a clean numbered list. You reply with /write 3 or whatever you choose, and the system researches the topic using Perplexity's live web search, generates three distinct outline options with different angles and hooks, saves them to a Google Doc, and sends you a message telling you they're ready. You read the outlines, and you pick one. You then reply with the command /outline 2. The system writes the full piece in your voice, following your brand guidelines, with specific examples and concrete claims. It can be done in under two minutes of your time. The whole thing runs on n8n, with no subscriptions beyond what you already use. If content takes too long or you don't have ideas, this solves that. I built this for myself; I can do it for you. If you're tired of knowing you should be posting and still not doing it, let's talk.

Savvy | Ai & Automation

14,879 views • 4 months ago