Zachi's jev() is the entry on this page that most changes what a piece of software can be: a PostgreSQL function that takes a row and a plain-English question and returns whether it holds, so a WHERE clause can read 'could work from home'. No index and no embeddings; 129 rows judged in about a second for $0.0009, and a cached second run in 6 ms.
I think I just cooked something 🔥
jev(): a PostgreSQL extension that searches your whole database in natural language. No index, no embeddings, just one function.
WHERE jev(people, 'could work from home')
or
WHERE jev(people, 'name sounds european')
129 rows judged in ~1s for $0.0009. Second run: 6ms from cache.