News for hackers. Stuff that matters.

A comment on Show HN: YouTube Full Text Search – Search all of a channel from the commandline.

Re:Show HN: YouTube Full Text Search – Search all of a chann... by simonw on Sunday May 21, 2023 @01:01AM (#36018153)
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#...

[ Parent | on HN ]
Re:Show HN: YouTube Full Text Search – Search all of a chann... by lfconsult on Sunday May 21, 2023 @09:52AM (#36020851)
You're right. Thanks for sharing the link to your full-text search helper, really neat.
[ Parent | on HN ]
Re:Show HN: YouTube Full Text Search – Search all of a chann... by notjoemartinez on Thursday June 01, 2023 @12:31AM (#36147588)
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

[ Parent | on HN ]