homepage

Don't brainrot learn

Brainrot, or endlessly consuming low quality content, isn't just limited to social media apps and fast news, it can also poison virtuous endeavours like learning.

Building a hybrid search engine with just 2MB of SQLite

Instead of reaching for some fancy SAAS, if you just want a basic search complete with the power of vectors, then look no further than SQLite.

SQLite comes with some off the shelf extensions, plus some plug and play ones that make building a hybrid search engine really easy.

I'm going to walk you through building one such engine. We'll be using some food recipes as our test data and by the end of it we'll be able to handle lexical queries like quesadillas as well as semantic queries like grandma's comfort food or spicy south asian dish and using a blending algorithm to mix lexical and semantic search results.