Forum>Suggestions>Database streams

Index|Statistiken|Suchen|AnmeldenAntworten
 
NiceMusic
2 Beiträge
schrieb am 07.05.18 um 21:15 Uhr
Link zu diesem Post
I build a radio stream database and managing it , having more than 25.000 streams ( Country , Location , Genre ) .
Some facts i share with you .

Because i am curious , looked in your database , extracted ALTERNATIVE section streams …. and found the following

1.
Everithing after the …. ( ; ) ….. is useless . Here are some examples .
The first row was the orriginal stream , an mistake , the second row is the correct one .

http://s3.voscast.com:7820/;stream1370537750222/1;nop.mp3
http://s3.voscast.com:7820/

http://s3.voscast.com:7820/;stream1370537750222/1
http://s3.voscast.com:7820/

http://s7.voscast.com:7618/;.m3u
http://s7.voscast.com:7618/

http://192.111.130.38:8000/;listen.pls
http://192.111.130.38:8000/

http://radio.zimnetradio.com:8010/;?type=http&nocache=29;
http://radio.zimnetradio.com:8010/

http://66.55.145.43:7479/;?1508619804176
http://66.55.145.43:7479/
……………………………….
2.
This is true for …..( ? ) ….. too

http://ice24.securenetsystems.net/YESFM?&playSessionID=4BA214FD-9B65-1B9A-D51F9D49CDAD3536
http://ice24.securenetsystems.net/YESFM

http://192.240.102.197:8808/stream?type=.mp3
http://192.240.102.197:8808/stream

http://192.99.41.102/proxy/radioevangelistica/?mp=/stream
http://192.99.41.102/proxy/radioevangelistica/

http://emf.streamguys1.com/sk045_mp3_high_web?tsid=1523480162656
http://emf.streamguys1.com/sk045_mp3_high_web
………………………………
3.
After you clean up in this way , you will find some duplicate streams
…………………………….
4.
Here is a CSV file for section ALTERNATIVE , that i cleaned up

http://bit.do/AMBIENT-csv
 
alex
2549 Beiträge
schrieb am 09.05.18 um 15:56 Uhr
Link zu diesem Post
Hello,

it's impossible to cleanup since the database is managed completely by software. I think manually removed URLs will appear again after some time.
LG/Best regards, Alex

"Journalism is printing what someone else does not want printed. Everything else is public relations."
- George Orwell

D1734FA178BF7D5AE50CB1AD54442494