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

Cool.

"We also parse subtitle files and correlate each subtitle line's timecode with the timecode of the screenshot. Finally, the frinkiac binary can upload the data set to frinkiac-server. "

Could you elaborate on this parsing of the subtitle files. I've seen the "open source" star wars gifs file with the dialog and time codes[1], but I'm not sure how they pulled the text from the close-captioning? (edit: someone else something similar...sorry).

Also aside from the two character index search index you describe how are you searching the quotes with postgres? Are you using postgres's full text search[2] or something else?

Thanks, I love the simpsons and this is really cromulent[3] and cool.

[1]https://github.com/LindseyB/starwars-dot-gif/blob/master/sub... [2] http://www.postgresql.org/docs/current/static/textsearch.htm... [3]https://frinkiac.com/?p=caption&q=cromulent&e=S07E16&t=10420....



> Could you elaborate on this parsing of the subtitle files.

Not the creator, but subtitles are easy to find, and super easy to parse.

    1
    00:02:17,440 --> 00:02:20,375
    Senator, we're making
    our final approach into Coruscant.

    2
    00:02:20,476 --> 00:02:22,501
    Very good, Lieutenant.


.srt files are quite straight forward, but some of the other formats can get quite annoying in my experience.




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

Search: