Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: database "shoutcast_scores" does not exist in /var/www/sites/mozai.com/shoutcast_scores/include.php on line 2
Mozai's Shoutcast Scoreboard

Mozai's Shoutcast Scoreboard

This is a list of how many people were listening to particular songs on shoutcast stations. Listeners did not vote for these songs, but they were receiving a stream of the song at the time the stations were polled, so it's assumed the music wasn't so horrible they turned it off; the point of this is to get a list of popular songs, not good ones. If you've been in a nightclub (as a DJ or as a patron), you'll know that people don't go to the dancefloor for good music, but what's familiar. This list should help predict what will be well received in the clubs.

Currently, I only poll the top five hundred most popular Shoutcast stations. The last poll was
Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/sites/mozai.com/shoutcast_scores/include.php on line 134

Warning: pg_errormessage(): supplied argument is not a valid PostgreSQL link resource in /var/www/sites/mozai.com/shoutcast_scores/include.php on line 136

Suggestions? Kicks or kudos? Mail 'em to moc.iazom@sesom

2006-01-03: I started work at a place where music is their business, so I'm putting this project aside. If you want to tinker with it yourself, you can have the source code. I used PHP, PostgreSQL and Python, but you could substitute MySQL if you wanted to. The database ran over a gigabyte, though, so watch out.

11 Most popular songs


Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/sites/mozai.com/shoutcast_scores/include.php on line 36

Warning: pg_errormessage(): supplied argument is not a valid PostgreSQL link resource in /var/www/sites/mozai.com/shoutcast_scores/include.php on line 45

Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/sites/mozai.com/shoutcast_scores/include.php on line 50

Warning: pg_errormessage(): supplied argument is not a valid PostgreSQL link resource in /var/www/sites/mozai.com/shoutcast_scores/include.php on line 53

Warning: pg_errormessage(): supplied argument is not a valid PostgreSQL link resource in /var/www/sites/mozai.com/shoutcast_scores/include.php on line 53
ScoreSongArtist

quer(y/ies) took 0.000 seconds
TODO: speed. caching queries now, but first query is slow.
TODO: better detection of non-songs
TODO: Top artist list: easy to do, but how to display?