Here at the station, we have a piece of very expensive software that pulls the currently playing song title from the audio vault, writes it to a file, and uploads it via ftp. It does this every 10 seconds.
I need a way to log those. My first thought is mysql, but I’d be willing to take other options. The client doesn’t have a way to make dated filenames or anything, it simply over-writes every time.
Any suggestions?
So you currently have a single file that only ever contains one song title, and then gets overwritten every 10 seconds? Is there any particular reason it’s doing this anyway? Is your webserver reading this file to display the name of the song on the website?
I guess my first thought would be mysql as well, since you have nice things like date-time string specific data types. Or you could just run a cron that writes to a delimited flat-file every 20 seconds, but also checks to make sure the fetched song title is different than the one before.
Yes, it’s so we can print on the website what’s currently playing. And you’re right in your assesment, it’s a single file that only ever contains one song title, and then gets overwritten every 10 seconds.
Can I have cron on Gospelcom do that? It seems sort of server intensive to run a script every 10 seconds.
Run your cron on a box at the station, have it insert into a Gospelcom mysql db, and then query the db from the website.
Not really my area to approve crons of that nature, but since it’s for an Alliance thing, I don’t see why it couldn’t.