[mythtv-users] Channel Line-up change and previously recorded

[David Engel]

On Fri, May 25, 2018 at 10:02:33AM -0700, Jay Foster wrote:
> On 5/25/2018 1:26 AM, John Veness wrote:
> > On 24/05/2018 21:34, Greg Oliver wrote:
> > > I ... was just wondering if people keep their lineups around forever
> > > (I have non-watched recordings from 2013 still) so their displays
> > > are not #xxxx on each recording..
> > 
> > Here in the UK, channels often change number, so I too have lots of
> > recordings that show #xxxx for the channel name, which looks ugly. Even
> > worse, sometimes new channels take over an old number, so recordings
> > that were originally recorded on, say, Drama, may change to say they
> > were recorded on ITV3, which is positively misleading!
> > 
> > It would involve a database schema change, but I think the best solution
> > would be to save the channel *name* for each recording in the recordings
> > table, and use that when displaying in the UI, rather than doing a
> > lookup of the number in the channels table. This would use slightly more
> > disk space but would be slightly quicker (one fewer lookup) and would
> > retain what channel a recording was made on, even if that channel moves
> > or is renamed later. This seems more "correct" behaviour to me.
> > 
> I concur with John and give his idea a +1.  This also affects the Mythweb
> statistics page.

We already do something similar for other tables (program, ratings,
etc.), so this seems like a good idea.  I put it on my own TODO list,
but I have no idea when I'll act on it.  In the mean time, patches are
welcome.

David
-- 
David Engel
david at istwok.net