[mythtv-users] Radio stream database update

[John Pilkington]

On 16/10/17 11:55, Stephen Worthington wrote:
> On Mon, 16 Oct 2017 11:04:23 +0100, you wrote:
> 
>> On 14/10/17 13:55, Paul Harrison wrote:
>>> On 14/10/17 12:05, Robin Gilks wrote:
>>>>> On 0.28, do I have to do anything to get this or does it get it all
>>>>> on its
>>>>> own?
>>>>>
>>>>> -- 
>>>>> Robin Gilks
>>>>>
>>>>>
>>>>> There is a house keeping task that should check for updates every 24hrs
>>>>> IIRC and update the DB if required.
>>>>>
>>>>> You can also just go to the stream search screen and if it detects an
>>>>> update will do the update before showing the list. If you do that there
>>>>> will be a longer delay than normal while the update is pulled in but the
>>>>> next time will be quicker.
>>>> Discovered something of interest (or not!!). I VNC'd into my main
>>>> frontend
>>>> as it has no keyboard and searching for new radio stations is hard work
>>>> without one and as soon as I hit the Radio Streaming page it was
>>>> constantly updating. The Goom icon was updating in the bottom right
>>>> corner
>>>> so I expected some activity but not the whole screen being constantly
>>>> repainted.
>>>>
>>>> Is this acceptable behaviour?
>>>>
>>>
>>> That sounds like the overhead required by VNC to stream the screen
>>> rather than a problem with MythTV. MythUI does update the screen 70
>>> times a second so probably not surprising VNC can't cope especially if
>>> has to emulate OpenGL in software.
>>>
>>> Paul H.
>>
>> Paul:  This looks as if it's a splendid resource, but I find it
>> difficult to get into using it.  At present, on this box, master head,
>> mine starts from a url that appears to be dead; I see big red warning
>> crosses that can only be stopped by killing the frontend and I see no
>> obvious way of dropping that url and entering another.  Another box
>> works but the search window really expects me to know what is available.
>>
>> I can get some idea of what that is by direct access to the DB:
>>
>> MariaDB [mythconverg]> select channel, description from music_streams
>> limit 100 ;
>>
>> - without the limit I get 12492 rows.
>>
>> Is there somewhere else that gives a better overview - not necessarily
>> within Myth?
>>
>> John
> 
> The genre field helps with breaking down that long list:
> 
> MariaDB [mythconverg]> select distinct genre from music_streams order
> by genre;
> +-----------------------------+
> | genre                       |
> +-----------------------------+
> | -                           |
> | 50s/60s                     |
> | 70s/80s                     |
> | 90s                         |
> | Adult Contemporary          |
> | Adult Standards / Nostalgia |
> | African                     |
> | All News                    |
> | Americana                   |
> | Arabic                      |
> | Asian                       |
> | Big Band/Swing              |
> | Bluegrass                   |
> | Blues                       |
> | Bollywood                   |
> | Children                    |
> | Choral-Religious            |
> | Christian                   |
> | Christian-Contemporary      |
> | Christian-Gospel            |
> | Christian-Pop Adult         |
> | Classical                   |
> | College/University          |
> | Community                   |
> | Country                     |
> | Country-Classic             |
> | Dance/DJ                    |
> | Easy Listening              |
> | Eclectic                    |
> | Electronica                 |
> | Electronica-Ambient         |
> | Electronica-Breakbeat       |
> | Electronica-Chillout        |
> | Electronica-Dance/DJ        |
> | Electronica-Drum & Bass     |
> | Electronica-Electro         |
> | Electronica-Experimental    |
> | Electronica-Hard House      |
> | Electronica-House           |
> | Electronica-Industrial      |
> | Electronica-Lounge          |
> | Electronica-Techno          |
> | Electronica-Trance          |
> | Fajta                       |
> | Folk                        |
> | Funk                        |
> | Hit Radio - Rock/Top 40     |
> | Hits                        |
> | Hits: New and Old           |
> | Hot Adult Contemporary      |
> | Independent                 |
> | Irish/Celtic                |
> | Islamic                     |
> | Island                      |
> | Island-Caribbean            |
> | Island-Hawaii               |
> | Island-Reggae               |
> | Island-Reggaeton            |
> | Jazz                        |
> | Jazz-Classical              |
> | Jazz-Easy Listening         |
> | Jazz-Latin                  |
> | Jazz-Smooth                 |
> | Jazz-Swing                  |
> | Latin                       |
> | Medieval                    |
> | Mexican                     |
> | Middle Eastern              |
> | Musical Comedy              |
> | Musicals                    |
> | Mystery Shows               |
> | New Age                     |
> | Old Time Radio              |
> | Oldies                      |
> | Opera                       |
> | Pop                         |
> | Public Radio                |
> | Rap/Hip Hop                 |
> | Religious-Jewish            |
> | Religious-Sikhism           |
> | Religious-Spiritual         |
> | Rock                        |
> | Rock-Alternative            |
> | Rock-Classic                |
> | Rock-Goth                   |
> | Rock-Hair Bands             |
> | Rock-Hard/Metal             |
> | Rock-Heavy Metal            |
> | Rock-Indie                  |
> | Rock-Pop                    |
> | Rock-Progressive            |
> | Rock-Punk                   |
> | Rock-Rockabilly             |
> | Seasonal                    |
> | Seasonal-Christmas          |
> | Seasonal-Halloween          |
> | Soft Adult Contemporary     |
> | Soul/R&B                    |
> | Soundtracks                 |
> | Spanish                     |
> | Talk                        |
> | Talk-Business               |
> | Talk-Comedy                 |
> | Talk-Government             |
> | Talk-News                   |
> | Talk-Progressive            |
> | Talk-Public Radio           |
> | Talk-Religious              |
> | Talk-Sports                 |
> | Talk-Weather                |
> | Tejano                      |
> | Tropical                    |
> | University                  |
> | Urban Contemporary          |
> | Variety                     |
> | Western                     |
> | World/Folk                  |
> +-----------------------------+
> 117 rows in set (0.04 sec)

Yes, thanks.  I eventually managed to escape the Big Red Crosses by 
persistent poking of the keyboard.  And 'Linn Classical' makes noises 
that I enjoy, although it chops them at random points.  Now I've got 
back to the entry screen I can hunt more :-)

Re-sending this to the List.  It's hit me before; I think I remember 
something about changes in TBird?

John