[mythtv] MythRoku - trying to mimic mythfrontend frame seeking

[Daniel Walton]

On Wed, 1 Feb 2006, Geoffrey Hausheer wrote:

> On 2/1/06, Daniel Walton wrote:
> > - how can I determine the framerate for the file that is being played?
> There is no direct info in myth.  this is done by parsing the header
> of the mpeg typically.  It is likely that an enhancement to
> mythbackend will be needed to support this, considering the
> limitations of the photobridge

ack, I'll look down that avenue.

>
> > - how does the mythfrontend build it's position map without downloading the
> > entire file and crunching through it?  There has to be something here that I'm
> > missing because that just doesn't seem feasible.
>
> This is stored in the SQL database.  There is a lot of info here, so I'm not
> sure it's worthwhile to store the whole thing in roku's memory.  perhaps just
> asking the backend to do the work would be easiest (send a query asking for a
> file position for a specific frame number (or ~PTS)

So when the frontend begins to play a recording it queries the SQL database for
the frame<->offset info?  I imagine it also queries for the commercial skip info
at this time too.  Are there any documents of the syntax of these queries?

Daniel