In 2026, Postgres and it's ecosystem just keep getting better with the recent example of pg_textsearch (BM25). A few years ago a gist of mine blew up on hacker news (gist:
https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f... thread:
https://news.ycombinator.com/item?id=39273954). Thought I'd turn the philosophy into a website with an easy to search directory of tools and extensions.