It looks like you're running searches using LIKE: https://github.com/NotJoeMarti... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		simonw on May 21, 2023 \| parent \| context \| favorite \| on: Show HN: YouTube Full Text Search – Search all of ... It looks like you're running searches using LIKE: https://github.com/NotJoeMartinez/yt-fts/blob/050981c0519a96... SQLite has a really power full-text search mechanism built in - FTS5. It can handle things like stemming and stop words and relevance ranking. My sqlite-utils Python library includes helper methods for setting that up: https://sqlite-utils.datasette.io/en/stable/python-api.html#...

notjoemartinez on June 1, 2023 | [–]

Thank you! I was able to integrate this into the project[1]. I'm also looking into using your openai-to-sqlite[2] library for semantic search.

[1]https://github.com/NotJoeMartinez/yt-fts/pull/25 [2]https://github.com/simonw/openai-to-sqlite

lfconsult on May 21, 2023 | [–]

You're right. Thanks for sharing the link to your full-text search helper, really neat.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact