HEAD or TAIL? Why not both!
Posted: Fri Oct 18, 2024 2:24 pm
Just ran into this classic:
https://www.opensubtitles.org/en/ssearc ... movie-1535
Brilliant show! Filled some missing and now I thought do give some existing ones a make-over (if necessary) and got stuck at the italian ones, all lacking FPS:
So, I wanted to do a quick check and went into the preview of
https://www.opensubtitles.org/en/subtit ... be-seen-it
It goes until line 53 and I thought it already another FPS/release
Current:
52
00:03:08,400 --> 00:03:10,231
E ora qualcosa
di completamente div...
Mine:
52
00:02:19,079 --> 00:02:20,680
Che cosa ha da dire?
After some "tedious" scrolling...
57
00:03:08,799 --> 00:03:10,959
E ora qualcosa di completamente div...
Yeah, okay, it seems to be matching (time wise) but it was not easy/convenient to find the matching line (I am somewhat exaggerating but hear me out...).
It would be much easier to spot any difference IF the preview would also have the ending part aka TAIL as well instead of just the beginning part aka HEAD.
(using linux inspired head/tail here because complete sql syntax ORDER ASC/DESC LMIT seems too clumsy for general intuity).
Additionally it might allow easier post-upload determination of FPS (if desired) without downloading the entire subtitle...
https://www.opensubtitles.org/en/ssearc ... movie-1535
Brilliant show! Filled some missing and now I thought do give some existing ones a make-over (if necessary) and got stuck at the italian ones, all lacking FPS:
So, I wanted to do a quick check and went into the preview of
https://www.opensubtitles.org/en/subtit ... be-seen-it
It goes until line 53 and I thought it already another FPS/release
Current:
52
00:03:08,400 --> 00:03:10,231
E ora qualcosa
di completamente div...
Mine:
52
00:02:19,079 --> 00:02:20,680
Che cosa ha da dire?
After some "tedious" scrolling...
57
00:03:08,799 --> 00:03:10,959
E ora qualcosa di completamente div...
Yeah, okay, it seems to be matching (time wise) but it was not easy/convenient to find the matching line (I am somewhat exaggerating but hear me out...).

(using linux inspired head/tail here because complete sql syntax ORDER ASC/DESC LMIT seems too clumsy for general intuity).
Additionally it might allow easier post-upload determination of FPS (if desired) without downloading the entire subtitle...