News for hackers. Stuff that matters.
Re:Show HN: YouTube Full Text Search – Search all of a chann... by lopatin on Saturday May 20, 2023 @06:53AM (#36010801)
This will come in handy. I’ve always wanted to count how many times Lex Fridman has referred to something as a beautiful dance.
Re:Show HN: YouTube Full Text Search – Search all of a chann... by noman-land on Monday May 22, 2023 @10:25AM (#36031859)
I want to do a word count on the word "love".
Re:Show HN: YouTube Full Text Search – Search all of a chann... by notjoemartinez on Thursday June 01, 2023 @12:18AM (#36147518)
> yt-fts search "love" --channel "Lex Fridman" | grep "love" | wc -l

> 7060

Re:Show HN: YouTube Full Text Search – Search all of a chann... by lopatin on Thursday June 01, 2023 @08:26PM (#36159307)
Legend
Re:Show HN: YouTube Full Text Search – Search all of a chann... by noman-land on Friday June 02, 2023 @06:54PM (#36171883)
This comment blew my mind.
Re:Show HN: YouTube Full Text Search – Search all of a chann... by noman-land on Friday June 02, 2023 @07:53PM (#36172294)
Update, I couldn't get this to work. It returns 0 for me.

Running it without the grep etc says channel not found.

Re:Show HN: YouTube Full Text Search – Search all of a chann... by noman-land on Friday June 02, 2023 @10:36PM (#36173174)
Update, I had to download all the videos and then query the sqlite tables directly. Here is the top 10 from just the podcast. First column is "love"s per episode.

107 | Sarma Melngailis: Bad Vegan, Fraud, Pris | iZjby1LkTWQ

98 | Andrew Huberman: Focus, Stress, Relation | lvh3g7eszVQ

92 | Bishop Robert Barron: Christianity and t | WgytXF0SPh0

80 | David Buss: Sex, Dating, Relationships, | sndW9hzX-wA

79 | Duncan Trussell: Comedy, Sentient Robots | jdIyNMkusLE

76 | Rana el Kaliouby: Emotion AI, Social Rob | 36_rM7wpN5A

75 | Edward Frenkel: Reality is a Paradox - M | Osh0-J3T2nY

75 | Todd Howard: Skyrim, Elder Scrolls 6, Fa | H9AAnV59ddE

74 | Travis Oliphant: NumPy, SciPy, Anaconda, | gFEE3w7F0ww

74 | Kelsi Sheren: War, Artillery, PTSD, and | PbN3HzKkW4M

-----------------

SELECT count(s.video_id) AS love_count, substr(v.video_title, 1, 40), s.video_id

FROM Subtitles s, Videos v

WHERE s.video_id = v.video_id

AND s.video_id IN (

  SELECT v.video_id FROM Videos v

  WHERE v.video_title LIKE "%Podcast%"

  AND v.video_title NOT LIKE "%Podcast Clips%"
)

AND s.text LIKE "%love%"

GROUP BY s.video_id

ORDER BY love_count DESC