« Can’t say they didn’t give me Nothing | Main | rage »
Radio
By Jesse Morgan | November 6, 2005
One of my side projects this past year was developing a “Radio Show” program to track and display info about songs currently playing on my stream. I’ve taken the last few months off, but now I’m back on track.
http://morgajel.com/radio/index.php
Unfortunately the stream is not available to the public (You can thank the RIAA for that bit of bullshit).
If you have any comments, feel free to add them to my bugtracker: http://morgajel.com/mantis/
I gotta patch up a few bugs, rework how schedules are handled then optimize the actual radio.pl file. Interesting side note here- I was right about load- once the system gets a certain number of entries, it becomes bogged down under it’s own weight. I’m gonna have to heavily optimize some of my sql queries to get this ready for a production environment.
Once that’s done, I’ll open it up and offer it up for licensing.
Topics: Movies, Open Source, Website |
November 6th, 2005 at 1:31 pm
select playlist_history_id,location||’/'||file_name as file_path from playlist_history inner join playlist on playlist_id=playlist_id_fk inner join locations on location_id=location_id_fk where played=false order by playlist_history_id limit 1;
You know, I should really know better. This is the query I’m using- playlist_history has 35k enteries already! playlist has 4600, and location 370. Unfortunately, none of these have indexes! I’m hoping this will speed up the query.